1. Index

Index

Symbols  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  Z  

Symbols

A

  • Abstract Data Type (ADT) 1.2.8.5, 14.6
  • accent-insensitive comparison 2.7.5.2.3
  • ACCESS_INTO_NULL exception 11.4
  • ACCESSIBLE BY clause 13.1
    • in CREATE FUNCTION statement 14.7
    • in CREATE PACKAGE statement 14.9
    • in CREATE PROCEDURE statement 14.11
    • in CREATE TYPE BODY statement 14.14
    • in CREATE TYPE statement 14.13
    • in package specification 10.1
    • in subprogram 8.2
  • accessor 13.1
  • ADT
    • See: Abstract Data Type (ADT)
  • aggregate 5.6
  • AGGREGATE clause 13.2
    • in CREATE FUNCTION statement 14.7
  • aggregate function 14.7
    • in PL/SQL expression 2.7.8
    • pipelined table function as 12.5.6
    • SQL%NOTFOUND attribute and 6.2.1.3
  • alias
    • column
    • table
      • for avoiding inner capture B.6
      • for row expression B.6.2
      • for table element attribute or method B.6.1
  • aliasing (problem)
    • SELECT BULK COLLECT INTO statement and 12.4.2.1.1
    • subprogram parameter 8.7.4
  • ALTER FUNCTION statement 14.1
  • ALTER LIBRARY statement 14.2
  • ALTER PACKAGE statement 14.3
  • ALTER PROCEDURE statement 14.4
  • ALTER TRIGGER statement 14.5
  • ALTER TYPE statement 14.6
  • AND operator 2.7.3
  • anonymous block 1.2.2
    • AUTHID property and 8.14
  • ANYDATA data type 12.5.2
  • ANYDATASET data type 12.5.2
  • ANYTYPE data type 12.5.2
  • application common object
  • architecture of PL/SQL 1.3
  • array
    • associative
      • See associative array 5.1
    • non-PL/SQL 5.1
  • assignment of value
    • to composite variable
    • to scalar variable 2.6
  • assignment statement 2.6.1
    • syntax diagram 13.3
  • associative array 5.2
    • See also: collection
    • characteristics of 5.1
    • comparisons 5.9
    • declaring constant 5.2.1
    • FIRST and LAST methods for 5.10.5.1
    • in FORALL statement 13.34
    • NLS parameters and 5.2.2
  • atomic (lexical) unit 2.2
  • atomically null collection
    • See: null collection
  • attribute
    • %ROWTYPE
      • See %ROWTYPE attribute 5.12.4
    • %TYPE
      • See %TYPE attribute 2.3.5
    • cursor
      • See cursor attribute 6.2
  • AUTHID property 8.14
  • AUTONOMOUS_TRANSACTION pragma 6.7.4
    • for pipelined table function 12.5.2
    • syntax diagram 13.4
  • autonomous routine 6.7
  • autonomous transaction 6.7
    • controlling 6.7.5
    • pipelined table function in 13.48
  • autonomous trigger 6.7.6

B

  • bag data structure 5.1
  • base type 3
  • basic LOOP statement 4.2.1
    • syntax diagram 13.5
  • BETWEEN operator 2.7.5.4
  • BINARY_DOUBLE data type
  • BINARY_FLOAT data type
  • BINARY_INTEGER data type
    • See: PLS_INTEGER data type
  • bind variable
    • avoiding SQL injection with 7.4.2.1
    • placeholder for
      • See placeholder for bind variable 7.2.1
  • blank-padding
  • block 1.2.2
    • syntax diagram 13.6
  • BOOLEAN data type 3.2
  • BOOLEAN expression 2.7.6
  • BOOLEAN static expression 2.7.9.2
  • BOOLEAN variable 2.6.4
  • built-in function
    • See: SQL function
  • bulk binding 12.4
  • BULK COLLECT clause 12.4.2, 12.4.2.3
  • bulk SQL 12.4

C

  • cache, function result 8.12
  • calculated column
    • See: virtual column
  • call specification 8.15
    • in CREATE FUNCTION statement 14.7
    • in CREATE PROCEDURE statement 14.11
    • in CREATE TYPE statement 14.13
    • in package 10.1
    • syntax diagram 13.7
  • call stack, AUTHID property and 8.14
  • capture B.5
  • cascading triggers 9.11
  • CASE_NOT_FOUND exception 11.4
  • CASE expression
  • case-insensitive comparison 2.7.5.2.3
  • case sensitivity
    • character comparison and 2.7.5.2.3
    • character literal and 2.2.3
    • identifier and 2.2.2
    • keyword and D
    • LIKE operator and 2.7.5.3
    • reserved word and D
  • CASE statement 4.1
  • C declaration 13.7
  • character code 2.1
  • character literal 2.2.3
    • See also: string
  • character set 2.1
  • CHAR data type 3.1.4
  • CHAR data type family E
  • CLOB data type and comparison operator 2.7.5
  • CLOB data type family E
  • CLOSE statement 13.9
  • collating sequence 2.7.5.2.3
  • collation 13.20
  • collection 5
    • as public package item 5.11
    • assigning one to another 5.7
    • comparing one to another 5.9
    • cursor variable and 13.18
    • declaration syntax 13.11
    • empty 5.1
      • creating with constructor 5.5
    • index
    • internal size of
    • multidimensional 5.8
    • null 5.1
      • assigning to collection variable 5.7.2
    • pipelined table function and 12.5.1
    • querying
    • retrieving query results into 12.4.2
    • types of 5.1
  • COLLECTION_IS_NULL exception 11.4
  • collection constructor 5.5
  • collection method 5.10
    • as subprogram parameter 5.10
    • invocation syntax 13.10
    • null collection and 5.10
  • column alias
  • COLUMNS pseudo-operator 12.6.3.2
  • comment 2.2.5
  • COMMIT statement 6.6.1
  • comparison operator 2.7.5
    • cursor variable and 13.18
  • compatible data type
    • for collection variables 5.7.1
    • for scalar variables 2.6
  • compilation
  • compilation parameter 1.3.2
  • compile_clause
    • in ALTER FUNCTION statement 14.1
  • compile_clause syntax diagram 13.13
  • compile clause 13.13
  • compiler directive
    • See: pragma
  • compile-time warning 11.1
  • composite data type 5
  • composite variable 5
  • compound trigger 9.3.3
  • computation-intensive code 12.3.5
  • concatenation operator (||) 2.7.1
  • concurrent transactions 6.7.5.4
  • condition, SQL multiset 5.9.3
  • conditional compilation 2.9
  • conditional compilation directive 2.9.1
  • conditional predicate 9.3.1
  • conditional selection statement 4.1
  • conditional trigger 9.1
  • constant
  • constrained subtype 3.4.2
  • constraint
    • cursor parameter and 13.30
    • NOT NULL
      • See NOT NULL constraint 2.3.1
    • trigger compared to 9.2
  • constructor
    • See: collection constructor
  • context of transaction 6.7.2
  • CONTINUE statement 4.2.4
  • CONTINUE WHEN statement 4.2.5
  • control statement 4
  • control token 2.9.1.1
  • correlated subquery 6.3.4
  • correlation name 9.4
    • See also: pseudorecord
    • with LONG or LONG RAW column 9.10.2
  • COUNT collection method 5.10.6
  • COVERAGE pragma 13.16
  • C procedure, invoking 8.15
  • CREATE_WRAPPED procedure A.4
  • CREATE FUNCTION statement 14.7
  • CREATE LIBRARY statement 14.8
  • CREATE PACKAGE statement 14.9
  • CREATE TRIGGER statement 14.12
  • CREATE TYPE BODY statement 14.14
  • CREATE TYPE statement 14.13
  • crossedition trigger 9.1
  • CURRENT OF clause 6.6.6.2
  • CURRVAL pseudocolumn 6.1.2.1
  • cursor 6.2
    • explicit
      • See explicit cursor 6.2.2
    • FOR UPDATE 6.6.6.2
    • implicit
      • See implicit cursor 6.2.1
    • in SERIALLY_REUSABLE package 10.7.2
    • named 6.2.2
      • pipelined table function and 12.5.5
      • See also explicit cursor and cursor variable 6.2.2
    • nested 6.5
  • CURSOR_ALREADY_OPEN exception 11.4
  • cursor attribute
  • CURSOR expression 6.5
    • passing to pipelined table function 12.5.6
  • cursor FOR LOOP statement
    • query result set processing with 6.3.2
    • recursive invocation in 8.10
    • syntax diagram 13.17
  • cursor number
    • converting cursor variable to 7.3.4
    • converting to cursor variable 7.3.3
    • DBMS_SQL.GET_NEXT_RESULT procedure and 7.3.2
    • DBMS_SQL.RETURN_RESULT procedure and 7.3.1
  • cursor parameter 6.2.2.6
  • cursor specification 13.30
  • cursor variable 6.4
    • converting cursor number to 7.3.3
    • converting to cursor number 7.3.4
    • DBMS_SQL.GET_NEXT_RESULT procedure and 7.3.2
    • DBMS_SQL.RETURN_RESULT procedure and 7.3.1
    • declaration syntax diagram 13.18

D

  • data abstraction 1.2.8
  • database character set 2.1.1
  • database links
  • DATABASE trigger 9.5.2
  • Data-bound collation 13.20
  • data definition language statement
    • See: DDL statement
  • Data Pump Import and triggers 9.14
  • datatype
    • in CREATE TYPE statement 14.13
  • Datatype 13.19
  • data type 3
    • See also: subtype
    • collection
      • See collection 5
    • compatible
      • for collection variables 5.7.1
      • for scalar variables 2.6
    • composite 5
    • object
      • See Abstract Data Type (ADT) 1.2.8.5
    • of expression 2.7
    • predefined E
    • RECORD
      • See record 5
    • scalar 3
    • SQL 3.1
    • user-defined
      • See Abstract Data Type (ADT) 1.2.8.5
    • what it determines 3
  • data type conversion 3.1
    • implicit
      • See implicit data type conversion 12.3.5.3
    • SQL injection and 7.4.1.3
  • data type family 3
    • overloaded subprogram and 8.9
    • predefined data types grouped by E
    • subtypes with base types in same 3.4.3
  • DATE data type family E
  • DBMS_ASSERT package 7.4.2.2
  • DBMS_DB_VERSION package 2.9.1.5
  • DBMS_DDL package A.4
  • DBMS_PARALLEL_EXECUTE package 12.7
  • DBMS_PREPROCESSOR package 2.9.3
  • DBMS_SQL.GET_NEXT_RESULT procedure 7.3.2
  • DBMS_SQL.RETURN_RESULT procedure 7.3.1
  • DBMS_SQL.TO_NUMBER function 7.3.4
  • DBMS_SQL.TO_REFCURSOR function 7.3.3
  • DBMS_SQL package 7.3
    • switching to native dynamic SQL from 7.3
  • DBMS_STANDARD package 2.4
  • DBMS_WARNING package 11.1.1
  • dbmsupgin.sql script 12.10.5
  • dbmsupgnv.sql script 12.10.5
  • DDL statement
    • dynamic SQL for 7
    • in trigger 6.7.6
    • subprogram side effects and 8.13
  • deadlock
    • autonomous transaction and 6.7.5.4
    • implicit rollback and 6.6.4
  • declaration 2.3
  • DEFAULT COLLATION clause 13.20
    • in CREATE FUNCTION statement 14.7
    • in CREATE PACKAGE statement 14.9
    • in CREATE PROCEDURE statement 14.11
    • in CREATE TRIGGER statement 14.12
    • in CREATE TYPE statement 14.13
  • default value 8.7.5
    • See also: initial value
  • DEFINE
    • binding category 12.4
  • definer’s rights clause 13.41
  • definer’s rights unit
    • See: DR unit
  • DELETE collection method 5.10.1
  • DELETE statement 13.21
    • See also: DML statement
    • BEFORE statement trigger and 9.9
    • PL/SQL extension to 13.21
  • DELETING conditional predicate 9.3.1
  • delimiter 2.2.1
  • dense collection 5.1
  • DEPRECATE pragma 13.22
  • Descriptive Intermediate Attributed Notation for Ada (DIANA) C
  • DETERMINISTIC
    • in CREATE FUNCTION statement 14.7
  • DETERMINISTIC clause 13.23
  • DETERMINISTIC option 13.36
    • for pipelined table function 12.5.2
  • DIAGNOSTIC_DEST initialization parameter 11
  • directive 2.9.1
    • See also: conditional compilation directive
  • direct-key partitioning 14.7, 14.14
  • DML statement
    • avoiding inner capture in B.6
    • in FORALL statement 12.4.1
    • inside pipelined table function 12.5.2
    • on pipelined table function result 12.5.7
    • PL/SQL syntax of 6.1.1
    • repeating efficiently 12.4.1
  • DML trigger 9.3
  • dot notation
    • for collection method 5.10
    • for identifier in named PL/SQL unit 2.4
    • for pseudocolumn 6.1.2.1
    • for record field 5
    • name resolution and B.1
  • double quotation mark (") 2.1.1
  • DROP FUNCTION statement 14.15
  • DROP LIBRARY statement 14.16
  • DROP PACKAGE statement 14.17
  • DROP PROCEDURE statement 14.18
  • DROP TRIGGER statement 14.19
  • DROP TYPE BODY statement 14.21
  • DR unit 8.14
    • See also: AUTHID property
    • call stack and 8.14
    • database links 8.14.3
    • dynamic SQL and 8.14
    • INHERIT REMOTE PRIVILEGES privilege 8.14.3
    • name resolution and 8.14
    • privilege checking and 8.14
    • SCHEMA trigger and 9.5.1
    • static SQL and 8.14
  • DUP_VAL_ON_INDEX exception 11.4
  • dynamic SQL 7
    • AUTHID property and 8.14
    • native 7.2
      • switching to DBMS_SQL package from 7.3
    • placeholder for bind variable in
      • EXECUTE IMMEDIATE statement and 7.2.1
      • repeated 7.2.3
    • tuning 12.2

E

  • editioned 14.6
  • editioned Abstract Data Type (ADT) 14.6
  • element of collection 5
  • element specification
    • in CREATE TYPE statement 14.13
    • syntax diagram 13.24
  • embedded SQL
    • See: static SQL
  • empty collection 5.1
    • creating with constructor 5.5
  • error directive 2.9.1.3
  • error handling 11
  • error-reporting function
  • escape character 2.7.5.3
  • escaped identifier B.4
  • evaluation order 2.7.2
  • events publication 9.15
  • evolution of type 14.6
  • exception
    • handling 11.2
      • in FORALL statement 12.4.1.2
      • in trigger 9.8
      • See also exception handler 11.2
    • internally defined
      • See internally defined exception 11.3
    • predefined
      • See predefined exception 11.4
    • raised in cursor FOR LOOP statement 6.3.2
    • raised in declaration 11.8.1
    • raised in exception handler 11.8.2
    • raising explicitly 11.7
    • reraising 11.7.1.3
    • unhandled 11.9
    • user-defined
      • See user-defined exception 11.5
  • EXCEPTION_INIT pragma 13.25
    • for giving error code to user-defined exception 11.7.2
    • for giving name to internally defined exception 11.3
  • exception handler 11.2
    • continuing execution after 11.11
    • exception raised in 11.8.2
    • for NO_DATA_NEEDED 12.5.8
    • GOTO statement and 13.37
    • locator variables for 11.2.2
    • retrieving error code and message in 11.10
    • retrying transaction after 11.12
    • syntax diagram 13.27
  • EXECUTE IMMEDIATE statement 7.2.1
  • EXISTS collection method 5.10.4
  • exiting a loop 4.2
  • EXIT statement 4.2.2
  • EXIT WHEN statement 4.2.3
    • in basic LOOP statement 4.2.3
    • syntax diagram 13.29
  • explicit cursor 6.2.2
    • declaration syntax diagram 13.30
    • in package
    • query result processing with
      • in FOR LOOP statement 6.3.2
      • with OPEN, FETCH, and CLOSE statements 6.3.3
  • explicit format model 7.4.2.3
  • expression 2.7
  • EXTEND collection method 5.10.3
  • external subprogram 8.15
    • call specification 13.7

F

G

  • generated column
    • See: virtual column
  • GET_NEXT_RESULT procedure 7.3.2
  • global identifier 2.5
  • GOTO statement 4.3.1
  • granting roles to PL/SQL units 8.14.1

H

  • hardware arithmetic 12.3.5.1
  • hash table 5.1
  • hiding PL/SQL source text
    • See: wrapping PL/SQL source text
  • host variable

I

  • identifier 2.2.2, 2.4
    • See also: name
    • ambiguous reference to B
    • escaped B.4
    • global 2.5
    • in static SQL 6.1.1
    • local 2.5
    • reference to 2.4
    • scope of 2.5
    • user-defined 2.2.2.3
      • collecting data about 12.8
    • visibility of 2.5
  • IDL C
  • IF statement 4.1
    • IF THEN ELSE form 4.1.2
    • IF THEN ELSIF form 4.1.3
      • nested IF THEN ELSE statement and 4.1.3
      • simple CASE statement and 4.1.3
    • IF THEN form 4.1.1
    • nested 4.1.2
    • syntax diagram 13.38
  • imp and triggers 9.14
  • implicit cursor 6.2.1
    • CURSOR expression with 6.5
    • declaration syntax 13.39
    • dynamic SQL and 7.3
    • query result processing with
      • with cursor FOR LOOP statement 6.3.2
      • with SELECT INTO statement 6.3.1
  • implicit data type conversion
    • minimizing 12.3.5.3
    • of subprogram parameter 8.7.2
      • causing overload error 8.9.3
    • of subtypes
      • constrained 3.4.2
      • unconstrained 3.4.1
      • with base types in same family 3.4.3
  • implicitly returning query results 7.3.1
  • implicit ROLLBACK statement 6.6.4
  • Import and triggers 9.14
  • in-bind 12.4
  • independent transaction
    • See: autonomous transaction
  • index-by table
    • See: associative array
  • index collection 12.4.1.1
  • index of collection 5
  • infinite loop 4.2.1
  • INFORMATIONAL compile-time warning 11.1
  • INHERIT ANY PRIVILEGES privilege 8.14
  • INHERIT PRIVILEGES privilege 8.14
  • INHERIT REMOTE PRIVILEGES privilege 8.14.3
  • initialization parameter 1.3.2
  • initial value 8.7.5
    • See also: default value
  • INLINE pragma 12.1.1
  • inner capture B.5.3
  • IN operator 2.7.5.5
  • IN OUT parameter mode 8.7.3
  • IN parameter mode 8.7.3
  • input 1.2.7
  • inquiry directive 2.9.1.4
  • INSERTING conditional predicate 9.3.1
  • INSERT statement 13.42
    • See also: DML statement
    • inserting record with 5.15
      • restrictions on 5.17
    • PL/SQL extension to 13.42
  • INSTEAD OF trigger 9.1
    • for CREATE statement 9.5.3
    • on DML statement 9.3.2
      • compound 9.3.3.1
      • for pipelined table function result 12.5.7
      • on nested table column 9.3.2
  • Interface Definition Language (IDL) C
  • internally defined exception 11.3
  • interpreted compilation 12.10.5
  • INVALID_CURSOR exception 11.4
  • INVALID_NUMBER exception 11.4
  • invisible column 5.12.4.4
  • invoker’s rights clause 13.41
  • invoker’s rights unit
    • See: IR unit
  • IR unit 8.14
    • See also: AUTHID property
  • IS [NOT] NULL operator 2.7.5.1
  • isolation level of transaction 6.7.3

J

  • Java class method invocation 8.15
  • Java method declaration 13.7

K

  • key-value pair
    • See: associative array
  • keywords 2.2.2.1
    • list of D

L

M

  • MALFORMED_WRAP_INPUT exception A.4
  • manageability 1.1.6
  • MapReduce workloads 14.7, 14.14
  • materialized view, trigger and 14.12
  • membership test 2.7.5.5
  • method, collection
    • See: collection method
  • Method 4 7.3
  • mixed parameter notation 8.7.6
  • mode
  • multibyte character set
    • as database character set 2.1.1
    • variables for values from 3.1.4.2
  • multidimensional collection 5.8
  • multiline comment 2.2.5.2
  • multiple data transformations 12.5
  • multiset condition 5.9.3
  • mutating table 9.10.3
  • mutating-table error

N

  • name 2.4
    • See also: identifier
    • qualified
      • See dot notation 2.4
    • qualified remote 2.4
    • remote 2.4
    • simple 2.4
  • named cursor 6.2.2
    • See also: explicit cursor and cursor variable
    • pipelined table function and 12.5.5
  • named parameter notation 8.7.6
  • name resolution B
    • AUTHID property and 8.14
    • in static SQL B.4
    • PL/SQL and SQL differences B.3
  • national character set 2.1.2
  • native dynamic SQL 7.2
    • switching to DBMS_SQL package from 7.3
  • native execution, compilation for 12.10
  • NATURALN subtype 3.3.2
  • NATURAL subtype 3.3.2
  • nested comment 2.2.5.2
  • nested cursor 6.5
  • nested IF statement 4.1.2
    • IF THEN ELSIF form and 4.1.3
  • nested LOOP statement 4.2.3
  • nested record
  • nested subprogram 8.2
    • declaration and definition of 8.2
    • forward declaration for 8.6
  • nested table 5.4
    • See also: collection
    • assigning null value to 5.7.2
    • assigning set operation result to 5.7.3
    • characteristics of 5.1
    • column in view, trigger on 9.3.2
    • comparing to NULL 5.9.1
    • comparing two 5.9.2
    • correlation names and 9.4
    • COUNT method for 5.10.6.2
    • FIRST and LAST methods for 5.10.5.3
    • returned by function 12.5.1
    • SQL multiset conditions and 5.9.3
  • nested transaction 6.7
  • NEW correlation name 9.4
    • with LONG or LONG RAW column 9.10.2
  • NEXT collection method 5.10.8
  • NEXTVAL pseudocolumn 6.1.2.1
  • NLS parameters
  • NO_DATA_FOUND exception 11.4
  • NO_DATA_NEEDED exception 12.5.8
  • NOCOPY hint 13.35
    • subprogram parameter aliasing and 8.7.4.1
    • tuning subprogram invocation with 12.3.3
  • nonpadded comparison semantics 3.1.4.3.3
  • no-op (no operation) statement 4.3.2
  • NOT_LOGGED_ON exception 11.4
  • NOT NULL constraint 2.3.1
  • NOT operator 2.7.3
  • null collection 5.1
    • assigning to collection variable 5.7.2
    • collection method and 5.10
  • NULL statement
  • null string 2.2.3
  • NULL value
    • assigning to record variable 5.13.3
    • comparing to collection
    • comparison operator and 2.7.5
    • concatenation operator and 2.7.1
    • for $$PLSQL_UNIT_OWNER inquiry directive 2.9.1.4.1
    • for $$PLSQL_UNIT inquiry directive 2.9.1.4.1
    • for collection variable 5.7.2
    • for subprogram parameter 8.7.5
    • for unresolvable inquiry directive 2.9.1.4.3
    • in control statement 2.7.3
    • IN operator and 2.7.5.5
    • in set 2.7.5.5
    • in USING clause 7.2.1
    • simple CASE expression and 2.7.7.1
    • simple CASE statement and 4.1.4
  • NUMBER data type family

O

  • obfuscating PL/SQL source text
    • See: wrapping PL/SQL source text
  • OBJECT_VALUE pseudocolumn 9.4.1
  • object type
    • See: Abstract Data Type (ADT)
  • OCI
    • associative array and 5.2.3
    • cursor variable and 6.4.9
  • of RETURNING INTO clause 12.4.2.3
  • OLD correlation name 9.4
  • OPEN FOR statement 13.46
    • recursive invocation and 8.10
  • OPEN statement 13.45
    • recursive invocation and 8.10
  • operation 2.7.2
  • operator
  • operator precedence 2.7.2
  • optimizer
  • Oracle Call Interface (OCI)
    • associative array and 5.2.3
    • cursor variable and 6.4.9
  • Oracle RAC environment, result caches in 8.12.5.6
  • ORA-n error
    • See: internally defined exception
  • ordinary user-defined identifier 2.2.2.3.1
  • Original Import and triggers 9.14
  • OR operator 2.7.3
  • out-bind 12.4
  • outer capture B.5.1
  • OUT parameter mode 8.7.3
  • output 1.2.7
  • overloaded subprogram 8.9

P

  • package 10.1
    • body of
      • See package body 10.4
    • DBMS_STANDARD 2.4
    • explicitly recompiling 14.3
    • features of 10.2
    • granting roles to 8.14.1
    • guidelines for writing 10.8
    • initialization of 10.5
    • of static constants 2.7.9.4
    • private items in 10.4
    • product-specific 10
    • public items in
      • See public package item 10.3
    • reasons to use 10.2
    • SERIALLY_REUSABLE 10.7
    • specification of
      • See package specification 10.3
    • STANDARD
      • See STANDARD package 10.10
    • state of 10.6
    • supplied by Oracle 10
    • wrapping A
      • guideline for A.2
  • package body 10.1
  • package specification 10.1, 10.3
    • See also: public package item
  • package subprogram 8.2
  • PARALLEL_ENABLE clause 13.47
    • in CREATE FUNCTION statement 14.7
  • PARALLEL_ENABLE option 13.36
    • for pipelined table function 12.5.2
    • for table function 12.5.1
  • parallel DML
    • bulk binding and 12.4
    • for large table 12.7
  • parameter
    • compilation
      • See compilation parameter 1.3.2
    • explicit cursor 6.2.2.6
    • initialization 1.3.2
    • subprogram
      • See subprogram parameter 8.7
  • parameter mode 8.7.3
  • PARENT correlation name 9.4
    • with LONG or LONG RAW column 9.10.2
  • parentheses
    • nested 2.7.2
    • to control evaluation order 2.7.2
    • to improve readability 2.7.2
  • pattern matching 2.7.5.3
  • percent sign (%) wildcard character 2.7.5.3
  • PERFORMANCE compile-time warning 11.1
  • PIPELINED Function
  • PIPELINED option 12.5.1
  • pipelined table function 12.5, 12.5.1
    • See also: table function
    • as aggregate function 12.5.6
    • in autonomous transaction 13.48
  • PIPE ROW statement 12.5.2
  • PL/Scope tool 12.8
  • PL/SQL architecture 1.3
  • PL/SQL block
    • See: block
  • PL/SQL engine 1.3.1
  • PL/SQL function result cache 8.12
  • PL/SQL language
    • advantages of 1.1
    • high performance of 1.1.2
    • high productivity with 1.1.3
    • lexical units of 2.2
    • limits of C
    • main features of 1.2
    • manageability and 1.1.6
    • portability of 1.1.4
    • program limits of C
    • scalability of 1.1.5
    • SQL integration in 1.1.1
    • syntax and semantics 13
  • PL/SQL optimizer 12.1
  • PL/SQL table
    • See: associative array
  • PL/SQL unit 1.3.2
    • stored
      • See stored PL/SQL unit 1.3.2
  • PL/SQL Wrapper utility A.3
  • placeholder for bind variable
    • in conditional compilation directive 2.9.4
    • in dynamic SQL
      • EXECUTE IMMEDIATE statement and 7.2.1
      • repeated 7.2.3
    • in static SQL 6.1.1
      • OPEN FOR statement and 6.4.2
    • in trigger body 9.4
  • PLS_INTEGER data type 3.3
  • PLS_INTEGER static expression 2.7.9.1
  • PLSQL_CCFLAGS compilation parameter 2.9.1.4.2
  • PLSQL_OPTIMIZE_LEVEL compilation parameter 12.1
  • PLSQL_WARNINGS compilation parameter
    • displaying value of
      • with ALL_PLSQL_OBJECT_SETTINGS view 11.1
      • with DBMS_WARNING subprogram 11.1.1
    • setting value of
      • with ALTER statements 11.1
      • with PLSQL_WARNINGS subprogram 11.1.1
  • polymorphic table function 12.6
  • portability 1.1.4
  • positional parameter notation 8.7.6
  • POSITIVEN subtype 3.3.2
  • POSITIVE subtype 3.3.2
  • post-processed source text 2.9.3
  • pragma 2.2.4
  • precedence, operator 2.7.2
  • predefined constant 3.1.2
  • predefined data type E
  • predefined exception 11.4
  • predefined inquiry directive 2.9.1.4.1
  • predefined subtype E
  • preprocessor control token 2.9.1.1
  • PRIOR collection method 5.10.8
  • privilege checking and AUTHID property 8.14
  • procedure 8
    • See also: subprogram
  • procedure specification 13.50
  • product-specific package 10
  • profiling and tracing programs 12.9
  • PROGRAM_ERROR exception 11.4
  • program limits C
  • pseudocolumn 6.1.2
  • pseudoinstruction
    • See: pragma
  • pseudorecord 9.4
    • See also: correlation name
  • public package item
  • publishing events 9.15
  • purity rules for subprograms 8.13

Q

  • qualified expression 5.6
  • qualified name
    • See: dot notation
  • qualified remote name 2.4
  • query 6.1.1
    • See also: SELECT INTO statement
    • implicitly returning results of 7.3.1
    • invoking function in 12.3.2
    • processing result set of 6.3
      • multiple-row dynamic query 7.2.2
  • quotation mark, single or double 2.1.1
  • quoted user-defined identifier 2.2.2.3.2

R

  • RAISE_APPLICATION_ERROR procedure 11.7.2
  • RAISE statement 11.7.1
  • raising exception explicitly 11.7
  • range test 2.7.5.4
  • read-only transaction 6.6.5
  • read-write transaction 6.6.5
  • recompiling stored PL/SQL unit 14
  • record 5
  • recursive subprogram 8.10
  • recursive trigger 9.9
  • REF CURSOR
    • See: cursor variable
  • REF CURSOR type 6.4.1
  • relational operator 2.7.5.2
    • collection and 5.9
  • RELEASE constant 2.9.1.5
  • remote exception handling
    • subprograms and 11.8
    • triggers and 9.8
  • remote name 2.4
  • remote public package variable 10.3.1
  • remote subprogram
    • exceptions in 11.8
    • invoked by trigger 9.6
    • with composite parameter 5
  • REPEAT UNTIL structure 4.2.7
  • replacing stored PL/SQL unit 14
  • reraising exception 11.7.1.3
  • reserved preprocessor control token 2.9.1.1
  • reserved words
  • RESTRICT_REFERENCES pragma 13.53
  • RESULT_CACHE clause 8.12.1, 13.56
  • RESULT_CACHE option for function 13.36, 14.7
  • result cache 8.12
  • RETURN_RESULT procedure 7.3.1
  • RETURN clause of function 8.5.1
  • RETURNING INTO clause 13.55
  • returning query results implicitly 7.3.1
  • RETURN INTO clause
    • See: RETURNING INTO clause
  • RETURN statement 8.5.2
  • REUSE SETTINGS clause 1.3.2
  • ROLLBACK statement 6.6.2
  • rowid 3.1.6
  • ROWID data type 3.1.6
  • ROWID pseudocolumn 6.1.2
    • instead of CURRENT OF clause 6.6.6.3
  • row-level trigger 9.3
  • ROWNUM pseudocolumn
  • ROWTYPE_MISMATCH exception
  • runtime error
    • See: exception

S

  • same-scope capture B.5.2
  • SAMPLE clause 12.4.2.1.2
  • SAVEPOINT statement 6.6.3
    • in autonomous transaction 6.7.5.3
  • scalability
    • SERIALLY_REUSABLE packages and 10.7
    • subprograms and 1.1.5
  • scalar data type 3
  • scalar variable
  • schema object
    • See: stored PL/SQL unit
  • SCHEMA trigger 9.5.1
  • scope of identifier 2.5
  • searched CASE expression 2.7.7.2
  • searched CASE statement 4.1.5
    • syntax diagram 13.8
  • security mechanism
    • against SQL injection 7.4
    • PL/SQL source text wrapping
      • benefit of A
      • limitations of A.1
    • trigger as 9.2
  • SELECT FOR UPDATE statement 6.6.6.2
  • SELECT INTO statement 6.1.1
    • See also: query
    • assigning values with
    • avoiding inner capture in B.6
    • query result set processing with 6.3.1
    • SQL%NOTFOUND attribute and 6.2.1.3
    • SQL%ROWCOUNT attribute and 6.2.1.4
    • syntax diagram 13.59
    • with BULK COLLECT clause 12.4.2.1
  • selection directive 2.9.1.2
  • selector
    • in simple CASE expression 2.7.7.1
    • in simple CASE statement 4.1.4
  • SELF_IS_NULL exception 11.4
  • sequence 6.1.2.1
  • sequential control statement 4.3
  • SERIALLY_REUSABLE package 10.7
  • SERIALLY_REUSABLE pragma 13.60
  • session cursor 6.2
  • set data structure 5.1
  • set membership test 2.7.5.5
  • SET TRANSACTION statement 6.6.5
  • SEVERE compile-time warning 11.1
  • SHARING clause
    • in CREATE FUNCTION statement 14.7
    • in CREATE LIBRARY statement 14.8
    • in CREATE PACKAGE statement 14.9
    • in CREATE PROCEDURE statement 14.11
    • in CREATE TRIGGER statement 14.12
    • in CREATE TYPE statement 14.13
    • sharing_clause syntax diagram 13.61
  • short-circuit evaluation
  • side effects of subprogram 8.11
  • SIGNTYPE subtype 3.3.2
  • SIMPLE_DOUBLE subtype 3.1.3
  • SIMPLE_FLOAT subtype 3.1.3
  • SIMPLE_INTEGER subtype 3.3.3
  • simple CASE expression 2.7.7.1
  • simple CASE statement 4.1.4
    • IF THEN ELSIF statement and 4.1.3
    • syntax diagram 13.8
  • simple DML trigger 9.3
  • simple name 2.4
  • single-line comment 2.2.5.1
  • single quotation mark (’) 2.1.1
  • sort ordering 13.20
  • sparse collection 5.1
  • specification
  • SQL
    • bulk 12.4
    • dynamic
      • See dynamic SQL 7
    • static
      • See static SQL 6
  • SQL*Loader and triggers 9.14
  • SQL%BULK_EXCEPTIONS cursor attribute 12.4.1.4
  • SQL%BULK_ROWCOUNT cursor attribute 12.4.1.5
  • SQL%FOUND cursor attribute 6.2.1.2
  • SQL%NOTFOUND cursor attribute 6.2.1.3
  • SQL%ROWCOUNT cursor attribute 6.2.1.4
  • SQLCODE function 13.62
  • SQL cursor
    • See: implicit cursor
  • SQL data type 3.1
  • SQLERRM function 13.63
  • SQL function
  • SQL injection 7.4
  • SQL integration in PL/SQL 1.1.1
  • SQL multiset condition 5.9.3
  • SQL MULTISET operator 5.7.3
  • SQL optimizer 12.5.5
  • SQL statement 1.2.2
    • See also: anonymous block
    • for stored PL/SQL unit 14
    • in trigger 9.1
    • invoking collection method in 5.10
    • invoking PL/SQL function in 8.13
    • tuning 12.3.1
  • standalone subprogram 8.2
  • STANDARD package
    • data type defined in
      • See predefined data type E
    • exception defined in
      • See predefined exception 11.4
    • how it defines PL/SQL environment 10.10
    • listing identifiers defined in 2.2.2.2
    • referencing item defined in 2.4
  • statement injection 7.4.1.2
  • statement-level trigger 9.3
  • statement modification 7.4.1.1
  • static constant 2.7.9.4
    • in DBMS_DB_VERSION package 2.9.1.5
  • static expression 2.7.9
  • static SQL 6
    • AUTHID property and 8.14
    • name resolution in B.4
    • PL/SQL identifier in 6.1.1
    • placeholder for bind variable in 6.1.1
      • OPEN FOR statement and 6.4.2
  • STORAGE_ERROR exception 11.4
    • recursive invocation and 8.10
  • stored PL/SQL unit 1.3.2
    • creating 14
    • recompiling 14
    • replacing 14
    • wrapping A
  • stored subprogram 8.2
    • unhandled exception in 11.9
    • wrapping A
  • store table 5.4.2
  • string 2.2.3
    • See also: character literal
  • STRING subtype 3.1.4.3.1
  • strong REF CURSOR type
  • subprogram 8
    • inlining 12.1.1
    • invoked by trigger 9.6
    • remote
      • See remote subprogram 5
    • unhandled exception in 11.9
  • subprogram invocation
  • subprogram parameter 8.7
    • collection as 5.10
    • composite variable as 5
    • CURSOR expression as actual 6.5
    • cursor variable as 6.4.8
    • optional 8.7.5
    • query result as 6.4.8
    • required 8.7.5
  • subprogram property 8.4
  • subquery
    • correlated 6.3.4
    • result set processing with 6.3.4
  • SUBSCRIPT_BEYOND_COUNT exception 11.4
  • SUBSCRIPT_OUTSIDE_LIMIT exception 11.4
  • subtype 3
    • See also: data type
    • constrained 3.4.2
    • of BINARY_DOUBLE data type 3.1.3
    • of BINARY_FLOAT data type 3.1.3
    • of PLS_INTEGER data type 3.3.2
    • predefined E
    • unconstrained 3.4.1
    • user-defined 3.4
  • synonym 2.4
  • SYS_INVALID_ROWID exception 11.4
  • SYS_REFCURSOR type 6.4.1
  • system trigger 9.5

T

  • table
    • hash 5.1
    • index-by
      • See associative array 5.2
    • mutating 9.10.3
    • nested 5.4
      • characteristics of 5.1
    • parallel DML for large 12.7
    • PL/SQL
      • See associative array 5.2
    • store 5.4.2
    • unordered 5.1
    • updating large in parallel 12.7
  • table alias
    • for avoiding inner capture B.6
    • for row expression B.6.2
    • for table element attribute or method B.6.1
  • table function 12.5.1
    • pipelined
      • See pipelined table function 12.5
    • weak cursor variable argument to 6.4.1
  • TABLE operator 6.4.6
  • TCL statement 6.1.1
    • in subprogram invoked by trigger 9.6
    • in trigger 6.7.6
  • template object 8.14.2
  • TIMEOUT_ON_RESOURCE exception 11.4
  • timing point
    • of DML trigger
    • of system trigger 9.5
    • trigger firing order and 9.11
  • TO_NUMBER function 7.3.4
  • TO_REFCURSOR function 7.3.3
  • TOO_MANY_ROWS exception 11.4
  • trace file 11
  • tracing and profiling programs 12.9
  • transaction
    • autonomous 6.7
      • pipelined table function in 13.48
    • context of 6.7.2
    • ending
      • with COMMIT statement 6.6.1
      • with ROLLBACK statement 6.6.2
    • isolation level of 6.7.3
    • nested 6.7
    • read-only 6.6.5
    • read-write 6.6.5
    • retrying after handling exception 11.12
    • SQL%ROWCOUNT cursor attribute and 6.2.1.4
    • visibility of 6.7.3
  • Transaction Control Language
    • See: TCL statement
  • TRANSACTIONS initialization parameter 6.7.5.4
  • trigger 9
    • as security mechanism 9.2
    • AUTHID property and 8.14
    • autonomous 6.7.6
    • cascading 9.11
    • DDL statement in 6.7.6
    • hiding implementation details of A.1
    • materialized view and 14.12
    • recursive 9.9
    • TCL statement in 6.7.6
  • TRIM collection method 5.10.2
  • tri-state logic 2.7.3
  • tuning PL/SQL code 12
  • type
    • See: data type
  • type-compatible data type
    • for collection variables 5.7.1
    • for scalar variables 2.6
  • typemark 5.6

U

  • UDF pragma 13.65
  • unconstrained subtype 3.4.1
  • underscore (_) wildcard character 2.7.5.3
  • unhandled exception 11.9
  • unordered table 5.1
  • UPDATE statement 13.66
    • See also: DML statement
    • BEFORE statement trigger and 9.9
    • PL/SQL extensions to 13.66
    • with values in record 5.16
      • restrictions on 5.17
  • UPDATING conditional predicate 9.3.1
  • UROWID data type 3.1.6
  • user-defined exception 11.5
    • giving error code to 11.7.2
    • raising
      • with RAISE_APPLICATION_ERROR procedure 11.7.2
      • with RAISE statement 11.7.1.1
  • user-defined identifier 2.2.2.3
    • collecting data about 12.8
  • user-defined subtype 3.4
  • user-defined type
    • See: Abstract Data Type (ADT)
  • USING_NLS_COMP 13.20
  • utlrp.sql script 12.10.5

V

  • V$RESERVED_WORDS view D
  • validation check for avoiding SQL injection 7.4.2.2
  • VALUE_ERROR exception 11.4
  • VARCHAR2 data type 3.1.4
  • VARCHAR2 static expression 2.7.9.3
  • VARCHAR subtype 3.1.4.3.1
  • variable
    • binding of 12.4
    • BOOLEAN 2.6.4
    • collection
      • See collection 5
    • composite 5
    • cursor
      • See cursor variable 6.4
    • host
    • in cursor variable query 6.4.5
    • in explicit cursor query 6.2.2.4
    • locator 11.2.2
    • record
      • See record 5
    • remote public package 10.3.1
    • scalar
      • See scalar variable 2.3.2
    • with undefined value 6.1.1
  • variable-size array
    • See: varray
  • variadic pseudo-operator 12.6.3.1
  • varray 5.3
    • See also: collection
  • VERSION constant 2.9.1.5
  • view
    • AUTHID property and 8.14
    • INSTEAD OF trigger and 14.12
    • materialized, trigger and 14.12
  • virtual column
  • visibility
    • of identifier 2.5
    • of transaction 6.7.3

W

  • warning, compile-time 11.1
  • weak REF CURSOR type
  • WHILE LOOP statement 4.2.7
  • white list 13.1
    • See: ACCESSIBLE BY clause
  • whitespace character
    • between lexical units 2.2.6
    • in character literal 2.2.3
    • in database character set 2.1.1
  • wildcard character 2.7.5.3
  • WRAP function A.4
  • wrapping PL/SQL source text A
  • wrap utility
    • See: PL/SQL Wrapper utility

Z

  • ZERO_DIVIDE exception 11.4
  • zero-length string 2.2.3