索引

A

Accessing Subprogram Variables After Row-Level Trigger After Statement-Level Trigger

Anonymous Blocks Assignment Associative Arrays Attributes

B

Basic Object Concepts Basic SPL Elements Basic Statements

Before Row-Level Trigger Before Statement-Level Trigger Block Relationships

C

Calling a Function Calling a Procedure CASE Expression Case Sensitivity CASE Statement Character Set Closing a Cursor Closing a Cursor Variable Collection Methods Collections COMMIT Compilation Errors in Procedures and Functions Compound Triggers, [1] Conclusion

Constants Constructor Methods CONTINUE Control Structures COUNT Creating a Function Creating a Procedure Creating a Subfunction Creating a Subprocedure Creating Object Instances Creating Object Types Creating Triggers Cursor Attributes Cursor FOR Loop

D

Database Object Name Resolution Database Object Privileges Declaring a Cursor Declaring a Cursor Variable Declaring a SYS_REFCURSOR Cursor Variable Declaring a User Defined REF CURSOR Type Variable Declaring a Variable

Definer’s vs. Invokers Rights DELETE, [1] Deleting a Function Deleting a Procedure Dropping an Object Type Dynamic Queries With REF CURSORs Dynamic SQL

E

Errors and Messages Examples Exception Handling EXECUTE IMMEDIATE BULK COLLECT

EXECUTE Privilege EXISTS EXIT EXTEND

F

FETCH BULK COLLECT Fetching Rows From a Cursor Fetching Rows From a Cursor Variable

FIRST FOR (integer variant) Functions Overview

G

GOTO Statement

I

Identifiers IF Statement IF-THEN IF-THEN-ELSE

IF-THEN-ELSE IF IF-THEN-ELSIF-ELSE INSERT INSTEAD OF Trigger Invoking Subprograms

L

LAST LIMIT

LOOP Loops

M

Member Methods

Methods Modularizing Cursor Operations

N

Nested Tables

NEXT NULL

O

Object Type Body Syntax Object Type Components Object Type Specification Syntax Object Types and Objects Obtaining the Result Status

Opening a Cursor Opening a Cursor Variable Overloading Methods Overloading Subprograms Overview

P

Packages Parameter Modes Parameterized Cursors Positional vs. Named Parameter Notation PRAGMA AUTONOMOUS_TRANSACTION

PRAGMA EXCEPTION_INIT PRIOR Procedure and Function Parameters Procedures Overview Program Security

Q

Qualifiers

R

RAISE_APPLICATION_ERROR REF CURSOR Overview REF CURSORs and Cursor Variables Referencing an Object

RETURN Statement Returning a REF CURSOR From a Function RETURNING BULK COLLECT ROLLBACK

S

Searched CASE Expression Searched CASE Statement Security Example SELECT BULK COLLECT SELECT INTO Selector CASE Expression

Selector CASE Statement SPL Block Structure SPL Programs Static Cursors Static Methods Subprograms – Subprocedures and Subfunctions Summary of Cursor States and Attributes

T

TABLE() Transaction Control Transactions and Exceptions Trigger Examples

Trigger Variables Triggers TRIM Types of Triggers

U

UPDATE Usage Restrictions User-defined Exceptions User-Defined PL/SQL Subtypes User-Defined Record Types and Record Variables Using %ROWTYPE in Record Declarations Using %ROWTYPE With Cursors

Using %TYPE in Variable Declarations Using Default Values in Parameters Using Forward Declarations Using the BULK COLLECT Clause Using the FORALL Statement Using the MULTISET UNION Operator Using the RETURNING INTO Clause

V

Variable Declarations

Varrays

W

WHILE

Working with Collections

記号

％FOUND ％ISOPEN

％NOTFOUND ％ROWCOUNT