Index

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

_ wildcard character 1
$$PLSQL_LINE inquiry directive 1
$$PLSQL_UNIT_OWNER inquiry directive 1
$$PLSQL_UNIT_TYPE inquiry directive 1
$$PLSQL_UNIT inquiry directive 1
%BULK_EXCEPTIONS cursor attribute 1
%BULK_ROWCOUNT cursor attribute 1
%FOUND cursor attribute
- for implicit cursor 1
- for named cursor 1
%ISOPEN cursor attribute
- for implicit cursor 1
- for named cursor 1
%NOTFOUND cursor attribute
- for implicit cursor 1
- for named cursor 1
%ROWCOUNT cursor attribute
- for implicit cursor 1
- for named cursor 1
%ROWTYPE attribute
- column alias and 1
- explicit cursor and 1
- invisible columns and 1
- syntax diagram 1
- virtual columns and 1
%TYPE attribute
- initial value and 1
- NOT NULL constraint and 1
- syntax diagram 1
% wildcard character 1

A

Abstract Data Type (ADT)
- creating 1
accent-insensitive comparison 1
ACCESS_INTO_NULL exception 1
ACCESSIBLE BY clause
- in package specification 1
- in subprogram 1
ADT
- See: Abstract Data Type (ADT)
aggregate function
- in PL/SQL expression 1
- pipelined table function as 1
- SQL%NOTFOUND attribute and 1
alias
- column
  - in cursor FOR LOOP 1
  - in explicit cursor 1
- table
  - for avoiding inner capture 1
  - for row expression 1
  - for table element attribute or method 1
aliasing (problem)
- SELECT BULK COLLECT INTO statement and 1
- subprogram parameter 1
ALTER FUNCTION statement 1
ALTER LIBRARY statement 1
ALTER PACKAGE statement 1
ALTER PROCEDURE statement 1
ALTER TRIGGER statement 1
ALTER TYPE statement 1
AND operator 1
anonymous block
- AUTHID property and 1
ANYDATA data type 1
ANYDATASET data type 1
ANYTYPE data type 1
architecture of PL/SQL 1
array
- associative
  - See associative array 1
- non-PL/SQL 1
assignment of value
- to composite variable
  - collection 1
  - record 1
- to scalar variable 1
assignment statement
- syntax diagram 1
associative array
- characteristics of 1
- comparisons 1
- declaring constant 1
- FIRST and LAST methods for 1
- in FORALL statement 1
- NLS parameters and 1
atomic (lexical) unit 1
atomically null collection
- See: null collection
attribute
- %ROWTYPE
  - See %ROWTYPE attribute 1
- %TYPE
  - See %TYPE attribute 1
- cursor
  - See cursor attribute 1
AUTHID property 1
AUTONOMOUS_TRANSACTION pragma
- for pipelined table function 1
- syntax diagram 1
autonomous routine
- declaring 1
autonomous transaction
- controlling 1
- pipelined table function in 1
autonomous trigger 1

B

bag data structure 1
base type 1
basic LOOP statement
- syntax diagram 1
BETWEEN operator 1
BINARY_DOUBLE data type
- predefined constants for 1
- subtype of 1
- tuning code and 1
BINARY_FLOAT data type
- predefined constants for 1
- subtype of 1
- tuning code and 1
BINARY_INTEGER data type
- See: PLS_INTEGER data type
bind variable
- avoiding SQL injection with 1
- placeholder for
  - See placeholder for bind variable 1
blank-padding
- in assignment 1
- in comparison 1
block
- syntax diagram 1
BOOLEAN data type 1
BOOLEAN expression 1
BOOLEAN static expression 1
BOOLEAN variable 1
built-in function
- See: SQL function
bulk binding 1
BULK COLLECT clause
- aliasing and 1
- of FETCH statement 1
- of RETURNING INTO clause
  - FORALL statement and 1
- of SELECT INTO statement 1
- query result set processing and 1
- that returns no rows 1
bulk SQL
- in compound DML trigger 1

C

cache, function result 1
calculated column
- See: virtual column
call specification
- in CREATE FUNCTION statement 1
- in CREATE PROCEDURE statement 1
- in package 1
call stack, AUTHID property and 1
capture 1
cascading triggers 1
CASE_NOT_FOUND exception 1
CASE expression
- searched 1
- simple 1
case-insensitive comparison 1
case sensitivity
- character comparison and 1
- character literal and 1
- identifier and
  - quoted user-defined identifier 1
- keyword and 1
- LIKE operator and 1
- reserved word and 1
CASE statement
- searched
  - syntax diagram 1
- simple
  - IF THEN ELSIF statement and 1
  - syntax diagram 1
character code 1
character literal 1
- See also: string
character set 1
CHAR data type 1
CHAR data type family 1
CLOB data type and comparison operator 1
CLOB data type family 1
CLOSE statement 1
collating sequence 1
collection
- as public package item 1
- assigning one to another 1
- comparing one to another 1
- cursor variable and 1
- declaration syntax 1
- empty
  - creating with constructor 1
- index
  - See index collection 1
- internal size of
  - DELETE method and 1
  - EXTEND method and 1
  - TRIM method and 1
- multidimensional 1
- null
  - assigning to collection variable 1
- pipelined table function and 1
- querying
  - with dynamic SQL 1
  - with static SQL 1
- retrieving query results into 1
- types of 1
COLLECTION_IS_NULL exception 1
collection constructor 1
collection method
- as subprogram parameter 1
- invocation syntax 1
- null collection and 1
column alias
- in cursor FOR LOOP 1
- in explicit cursor 1
comment
- nested 1
- PL/SQL Wrapper utility and 1
- syntax diagram 1
COMMIT statement
- FOR UPDATE cursor and 1
- in autonomous transaction 1
comparison operator
- cursor variable and 1
compatible data type
- for collection variables 1
- for scalar variables 1
compilation
- conditional 1
- for native execution 1
- interpreted 1
compilation parameter
- displaying value of 1
- predefined inquiry directive for 1
compiler directive
- See: pragma
compile-time warning 1
composite data type 1
composite variable 1
compound trigger 1
computation-intensive code 1
concatenation operator (||) 1
concurrent transactions 1
condition, SQL multiset 1
conditional compilation 1
conditional compilation directive
- error 1
- inquiry 1
- restrictions on 1
- selection 1
conditional predicate 1
conditional selection statement 1
conditional trigger 1
constant
- declaring
  - associative array 1
  - record 1
  - syntax diagram 1
- initial value of 1
- predefined 1
- static
  - in DBMS_DB_VERSION package 1
constrained subtype
- in performance-critical code 1
- subprogram parameter and 1
constraint
- cursor parameter and 1
- NOT NULL
  - See NOT NULL constraint 1
- trigger compared to 1
constructor
- See: collection constructor
context of transaction 1
CONTINUE statement
- syntax diagram 1
CONTINUE WHEN statement
- syntax diagram 1
control statement 1
control token 1
correlated subquery 1
correlation name
- with LONG or LONG RAW column 1
COUNT collection method 1
C procedure, invoking 1
CREATE_WRAPPED procedure 1
CREATE FUNCTION statement 1
CREATE LIBRARY statement 1
CREATE PACKAGE statement 1
CREATE TRIGGER statement 1
CREATE TYPE BODY statement 1
CREATE TYPE statement 1
crossedition trigger 1
CURRENT OF clause
- FOR UPDATE cursor and 1
- ROWID pseudocolumn instead of 1
CURRVAL pseudocolumn 1
cursor
- explicit
  - See explicit cursor 1
- FOR UPDATE
  - after COMMIT or ROLLBACK 1
- implicit
  - See implicit cursor 1
- in SERIALLY_REUSABLE package 1
- named
  - pipelined table function and 1
  - See also explicit cursor and cursor variable 1
- nested 1
CURSOR_ALREADY_OPEN exception 1
cursor attribute
- for cursor variable 1
- for explicit cursor
  - %FOUND 1
  - %ISOPEN 1
  - %NOTFOUND 1
  - %ROWCOUNT 1
- for implicit cursor
  - DBMS_SQL package and 1
  - native dynamic SQL and 1
  - SQL%BULK_EXCEPTIONS 1
  - SQL%BULK_ROWCOUNT 1
  - SQL%FOUND 1
  - SQL%ISOPEN 1
  - SQL%NOTFOUND 1
  - SQL%ROWCOUNT 1
- where you can use 1
CURSOR expression
- passing to pipelined table function 1
cursor FOR LOOP statement
- query result set processing with 1
- recursive invocation in 1
- syntax diagram 1
cursor number
- converting cursor variable to 1
- converting to cursor variable 1
- DBMS_SQL.GET_NEXT_RESULT procedure and 1
- DBMS_SQL.RETURN_RESULT procedure and 1
cursor parameter 1
cursor specification 1
cursor variable
- converting cursor number to 1
- converting to cursor number 1
- DBMS_SQL.GET_NEXT_RESULT procedure and 1
- DBMS_SQL.RETURN_RESULT procedure and 1
- declaration syntax diagram 1

D

data abstraction 1
database character set 1
DATABASE trigger 1
data definition language statement
- See: DDL statement
Data Pump Import and triggers 1
data type
- collection
  - See collection 1
- compatible
  - for collection variables 1
  - for scalar variables 1
- composite 1
- object
  - See Abstract Data Type (ADT) 1
- of expression 1
- predefined 1
- RECORD
  - See record 1
- scalar 1
- SQL 1
- user-defined
  - See Abstract Data Type (ADT) 1
- what it determines 1
data type conversion
- implicit
  - See implicit data type conversion 1
- SQL injection and 1
data type family
- overloaded subprogram and 1
- predefined data types grouped by 1
- subtypes with base types in same 1
DATE data type family 1
DBMS_ASSERT package 1
DBMS_DB_VERSION package 1
DBMS_DDL package 1
DBMS_PARALLEL_EXECUTE package 1
DBMS_PREPROCESSOR package 1
DBMS_PROFILE package 1
DBMS_SQL.GET_NEXT_RESULT procedure 1
DBMS_SQL.RETURN_RESULT procedure 1
DBMS_SQL.TO_NUMBER function 1
DBMS_SQL.TO_REFCURSOR function 1
DBMS_SQL package
- switching to native dynamic SQL from 1
DBMS_STANDARD package 1
DBMS_TRACE package 1
DBMS_WARNING package 1
dbmsupgin.sql script 1
dbmsupgnv.sql script 1
DDL statement
- dynamic SQL for 1
- in trigger 1
- subprogram side effects and 1
deadlock
- autonomous transaction and 1
- implicit rollback and 1
declaration
- exception raised in 1
default value
- of cursor parameter 1
- of subprogram parameter 1
DEFINE
- binding category 1
definer’s rights unit
- See: DR unit
DELETE collection method
- COUNT method and 1
- EXISTS method and 1
- EXTEND method and 1
- FIRST method and 1
- LAST method and 1
- NEXT method and 1
- PRIOR method and 1
- TRIM method and 1
DELETE statement
- BEFORE statement trigger and 1
- PL/SQL extension to 1
DELETING conditional predicate 1
delimiter 1
dense collection 1
Descriptive Intermediate Attributed Notation for Ada (DIANA) 1
DETERMINISTIC option
- for pipelined table function 1
directive
- compiler
  - See pragma 1
- error 1
- inquiry 1
- selection 1
direct-key partitioning 1 , 2
DML statement
- avoiding inner capture in 1
- in FORALL statement 1
- inside pipelined table function 1
- on pipelined table function result 1
- PL/SQL syntax of 1
- repeating efficiently 1
DML trigger 1
dot notation
- for collection method 1
- for identifier in named PL/SQL unit 1
- for pseudocolumn 1
- for record field 1
- name resolution and 1
double quotation mark (") 1
DROP FUNCTION statement 1
DROP LIBRARY statement 1
DROP PACKAGE statement 1
DROP PROCEDURE statement 1
DROP TRIGGER statement 1
DROP TYPE BODY statement 1
DR unit
- call stack and 1
- dynamic SQL and 1
- name resolution and 1
- privilege checking and 1
- SCHEMA trigger and 1
- static SQL and 1
DUP_VAL_ON_INDEX exception 1
dynamic SQL
- AUTHID property and 1
- native
  - switching to DBMS_SQL package from 1
- placeholder for bind variable in
  - EXECUTE IMMEDIATE statement and 1
  - repeated 1
- tuning 1

E

editioned 1
editioned Abstract Data Type (ADT) 1
element of collection 1
embedded SQL
- See: static SQL
empty collection
- creating with constructor 1
error directive 1
error handling 1
error-reporting function
- SQLCODE 1
- SQLERRM
  - SQL%BULK_EXCEPTIONS and 1
escape character 1
escaped identifier 1
evaluation order 1
events publication 1
evolution of type 1
exception
- handling
  - in FORALL statement 1
  - in trigger 1
  - See also exception handler 1
- internally defined
  - See internally defined exception 1
- predefined
  - See predefined exception 1
- raised in cursor FOR LOOP statement 1
- raised in declaration 1
- raised in exception handler 1
- raising explicitly 1
- reraising 1
- unhandled
  - in FORALL statement 1
- user-defined
  - See user-defined exception 1
EXCEPTION_INIT pragma
- for giving error code to user-defined exception 1
- for giving name to internally defined exception 1
exception handler
- continuing execution after 1
- exception raised in 1
- for NO_DATA_NEEDED 1
- GOTO statement and 1
- locator variables for 1
- retrieving error code and message in 1
- retrying transaction after 1
- syntax diagram 1
EXECUTE IMMEDIATE statement
- syntax diagram 1
EXISTS collection method 1
exiting a loop 1
EXIT statement
- syntax diagram 1
EXIT WHEN statement
- in basic LOOP statement 1
- syntax diagram 1
explicit cursor
- declaration syntax diagram 1
- in package
  - declaring 1
  - opening and closing 1
- query result processing with
  - in FOR LOOP statement 1
  - with OPEN, FETCH, and CLOSE statements 1
explicit format model 1
expression
- CURSOR
  - passing to pipelined table function 1
- data type of 1
- in explicit cursor 1
- SQL function in PL/SQL 1
- static 1
- syntax diagram 1
EXTEND collection method 1
external subprogram 1

F

FETCH FIRST clause 1
FETCH statement
- across COMMIT 1
- record variable and 1
- syntax diagram 1
- that returns no row 1
- with BULK COLLECT clause 1
- with cursor variable 1
- with explicit cursor 1
field of record 1
FIRST collection method 1
FORALL statement
- associative array in 1
- bulk binding and 1
- BULK COLLECT clause and 1
- for sparse collection
  - SQL%BULK_EXCEPTIONS and 1
- handling exception raised in
  - after FORALL completes 1
  - immediately 1
- number of rows affected by 1
- syntax diagram 1
- unhandled exception in 1
FOR LOOP statement
- bounds of 1
- FORALL statement and 1
- STEP clause and 1
- syntax diagram 1
format model 1
FOR UPDATE cursor
- after COMMIT or ROLLBACK 1
forward declaration of subprogram 1
function
- aggregate
  - See aggregate function 1
- built-in
  - See SQL function 1
- declaration syntax diagram 1
- error-reporting
  - SQLCODE 1
  - SQLERRM 1
- invoking
  - in SQL statement 1
- options for 1
- SQL
  - See SQL function 1
- structure of 1
- table
  - See table function 1
function result cache 1
function specification 1

G

generated column
- See: virtual column
GET_NEXT_RESULT procedure 1
global identifier 1
GOTO statement
- restrictions on 1
- syntax diagram 1
granting roles to PL/SQL units 1

H

hardware arithmetic 1
hash table 1
hiding PL/SQL source text
- See: wrapping PL/SQL source text
host variable
- bulk-binding 1
- cursor variable as 1
- packages and 1

I

identifier
- ambiguous reference to 1
- escaped 1
- global 1
- in static SQL 1
- local 1
- reference to 1
- scope of 1
- user-defined
  - collecting data about 1
- visibility of 1
IDL 1
IF statement
- IF THEN ELSE form 1
- IF THEN ELSIF form
  - nested IF THEN ELSE statement and 1
  - simple CASE statement and 1
- IF THEN form 1
- nested 1
- syntax diagram 1
imp and triggers 1
implicit cursor
- CURSOR expression with 1
- declaration syntax 1
- dynamic SQL and 1
- query result processing with
  - with cursor FOR LOOP statement 1
  - with SELECT INTO statement 1
implicit data type conversion
- minimizing 1
- of subprogram parameter
  - causing overload error 1
- of subtypes
  - constrained 1
  - unconstrained 1
  - with base types in same family 1
implicitly returning query results 1
implicit ROLLBACK statement 1
Import and triggers 1
in-bind 1
independent transaction
- See: autonomous transaction
index-by table
- See: associative array
index collection
- representing subset with 1
index of collection 1
infinite loop 1
INFORMATIONAL compile-time warning 1
INHERIT ANY PRIVILEGES privilege 1
INHERIT PRIVILEGES privilege 1
initialization parameter 1
initial value
- %TYPE attribute and 1
- NOT NULL constraint and 1
- of constant 1
- of variable
  - nested table 1
  - record 1
  - scalar 1
  - varray 1
INLINE pragma
- syntax diagram 1
inner capture
- avoiding 1
IN operator 1
IN OUT parameter mode 1
IN parameter mode 1
input 1
inquiry directive 1
INSERTING conditional predicate 1
INSERT statement
- inserting record with
  - restrictions on 1
- PL/SQL extension to 1
INSTEAD OF trigger
- for CREATE statement 1
- on DML statement
  - compound 1
  - for pipelined table function result 1
  - on nested table column 1
Interface Definition Language (IDL) 1
internally defined exception
- giving name to 1
- raising explicitly 1
interpreted compilation 1
INVALID_CURSOR exception 1
INVALID_NUMBER exception 1
invisible column 1
invoker’s rights unit
- See: IR unit
IR unit
- call stack and 1
- dynamic SQL and 1
- granting roles to 1
- name resolution and 1
- privilege checking and 1
- static SQL and 1 , 2
- template objects for 1
IS [NOT] NULL operator
- collections and 1
isolation level of transaction 1

J

Java class method invocation 1

K

key-value pair
- See: associative array
keywords
- list of 1

L

labeled LOOP statement 1
LAST collection method 1
LEVEL pseudocolumn 1
lexical unit 1
library
- creating 1
- dropping 1
- explicitly recompiling 1
library arithmetic 1
LIKE operator 1
LIMIT clause 1
LIMIT collection method 1
line-continuation character 1
literal 1
local identifier 1
locator variable 1
locking
- overriding default 1
- result set row 1
- table 1
lock mode 1
LOCK TABLE statement 1
logical operator 1
logical value 1
LOGIN_DENIED exception 1
LONG data type
- in trigger 1
LONG RAW data type
- in trigger 1
LOOP statement
- exiting 1
- kinds of 1
- labeled 1 , 2
- nested 1
- optimizing 1
LOOP UNTIL structure 1

M

MALFORMED_WRAP_INPUT exception 1
manageability 1
MapReduce workloads 1 , 2
materialized view, trigger and 1
membership test 1
method, collection
- See: collection method
Method 4 1
mixed parameter notation 1
mode
- lock 1
- subprogram parameter 1
multibyte character set
- as database character set 1
- variables for values from 1
multidimensional collection 1
multiline comment 1
multiple data transformations 1
multiset condition 1
mutating table 1
mutating-table error
- for function 1
- for trigger 1

N

name
- qualified
  - See dot notation 1
- qualified remote 1
- remote 1
- simple 1
named cursor
- pipelined table function and 1
named parameter notation 1
name resolution
- AUTHID property and 1
- in static SQL 1
- PL/SQL and SQL differences 1
national character set 1
native dynamic SQL
- switching to DBMS_SQL package from 1
native execution, compilation for 1
NATURALN subtype 1
NATURAL subtype 1
nested comment 1
nested cursor 1
nested IF statement
- IF THEN ELSIF form and 1
nested LOOP statement 1
nested record
- assignment example 1
- declaration example 1
nested subprogram
- declaration and definition of 1
- forward declaration for 1
nested table
- assigning null value to 1
- assigning set operation result to 1
- characteristics of 1
- column in view, trigger on 1
- comparing to NULL 1
- comparing two 1
- correlation names and 1
- COUNT method for 1
- FIRST and LAST methods for 1
- returned by function 1
- SQL multiset conditions and 1
nested transaction 1
NEW correlation name
- with LONG or LONG RAW column 1
NEXT collection method 1
NEXTVAL pseudocolumn 1
NLS parameters
- associative array and 1
- character comparison and 1
- SQL injection and 1
NO_DATA_FOUND exception 1
NO_DATA_NEEDED exception
- SQLCODE for 1
NOCOPY hint
- subprogram parameter aliasing and 1
- tuning subprogram invocation with 1
nonpadded comparison semantics 1
no-op (no operation) statement 1
NOT_LOGGED_ON exception 1
NOT NULL constraint
- %TYPE attribute and 1
- EXTEND method and 1
NOT operator 1
null collection
- assigning to collection variable 1
- collection method and 1
NULL statement
- syntax diagram 1
- uses for 1
null string 1
NULL value
- assigning to record variable 1
- comparing to collection
  - associative array 1
  - nested table 1
  - varray 1
- comparison operator and 1
- concatenation operator and 1
- for $$PLSQL_UNIT_OWNER inquiry directive 1
- for $$PLSQL_UNIT inquiry directive 1
- for collection variable 1
- for subprogram parameter 1
- for unresolvable inquiry directive 1
- in control statement 1
- IN operator and 1
- in set 1
- in USING clause 1
- simple CASE expression and 1
- simple CASE statement and 1
NUMBER data type family
- inefficiency of 1
- members of 1

O

obfuscating PL/SQL source text
- See: wrapping PL/SQL source text
OBJECT_VALUE pseudocolumn 1
object type
- See: Abstract Data Type (ADT)
OCI
- associative array and 1
- cursor variable and 1
of RETURNING INTO clause 1
OLD correlation name 1
OPEN FOR statement
- recursive invocation and 1
OPEN statement
- recursive invocation and 1
operation 1
operator
- comparison
  - cursor variable and 1
- logical 1
- relational
  - collection and 1
operator precedence 1
optimizer
- PL/SQL 1
- SQL 1
Oracle Call Interface (OCI)
- associative array and 1
- cursor variable and 1
Oracle RAC environment, result caches in 1
ORA-n error
- See: internally defined exception
ordinary user-defined identifier 1
Original Import and triggers 1
OR operator 1
out-bind 1
outer capture 1
OUT parameter mode 1
output 1
overloaded subprogram
- INLINE pragma and 1

P

package
- body of
  - See package body 1
- DBMS_STANDARD 1
- explicitly recompiling 1
- features of 1
- granting roles to 1
- guidelines for writing 1
- initialization of 1
- of static constants 1
- private items in 1
- product-specific 1
- public items in
  - See public package item 1
- reasons to use 1
- SERIALLY_REUSABLE 1
- specification of
  - See package specification 1
- STANDARD
  - See STANDARD package 1
- state of 1
- supplied by Oracle 1
- wrapping
  - guideline for 1
package body
- creating 1
- dropping 1
- initialization part of
  - assigning initial values in 1
- replacing 1
package specification
- creating 1
- cursor variable in 1
- dropping 1
- replacing 1
package subprogram 1
PARALLEL_ENABLE option
- for pipelined table function 1
- for table function 1
parallel DML
- bulk binding and 1
- for large table 1
parameter
- compilation
  - See compilation parameter 1
- explicit cursor 1
- initialization 1
- subprogram
  - See subprogram parameter 1
parameter mode 1
PARENT correlation name
- with LONG or LONG RAW column 1
parentheses
- nested 1
- to control evaluation order 1
- to improve readability 1
pattern matching 1
percent sign (%) wildcard character 1
PERFORMANCE compile-time warning 1
PIPELINED option
- where to specify 1
pipelined table function
- as aggregate function 1
- in autonomous transaction 1
PIPE ROW statement
- in autonomous routine 1
PL/Scope tool 1
PL/SQL architecture 1
PL/SQL block
- See: block
PL/SQL engine 1
PL/SQL function result cache 1
PL/SQL language
- advantages of 1
- high performance of 1
- high productivity with 1
- lexical units of 1
- limits of 1
- main features of 1
- manageability and 1
- portability of 1
- program limits of 1
- scalability of 1
- SQL integration in 1
- syntax and semantics 1
PL/SQL optimizer 1
PL/SQL table
- See: associative array
PL/SQL unit
- stored
  - See stored PL/SQL unit 1
PL/SQL Wrapper utility 1
placeholder for bind variable
- in conditional compilation directive 1
- in dynamic SQL
  - EXECUTE IMMEDIATE statement and 1
  - repeated 1
- in static SQL
  - OPEN FOR statement and 1
- in trigger body 1
PLS_INTEGER data type
- tuning code and 1
PLS_INTEGER static expression 1
PLSQL_CCFLAGS compilation parameter 1
PLSQL_OPTIMIZE_LEVEL compilation parameter 1
PLSQL_WARNINGS compilation parameter
- displaying value of
  - with ALL_PLSQL_OBJECT_SETTINGS view 1
  - with DBMS_WARNING subprogram 1
- setting value of
  - with ALTER statements 1
  - with PLSQL_WARNINGS subprogram 1
portability 1
positional parameter notation 1
POSITIVEN subtype 1
POSITIVE subtype 1
post-processed source text 1
pragma
- AUTONOMOUS_TRANSACTION
  - for pipelined table function 1
- EXCEPTION_INIT 1
- INLINE
  - syntax diagram 1
- RESTRICT_REFERENCES 1
- SERIALLY_REUSABLE 1
- UDF 1
precedence, operator 1
predefined constant 1
predefined data type 1
predefined exception
- raising explicitly 1
- redeclared 1
predefined inquiry directive 1
predefined subtype 1
preprocessor control token 1
PRIOR collection method 1
privilege checking and AUTHID property 1
procedure
- declaration syntax 1
- invoking 1
- structure of 1
procedure specification 1
product-specific package 1
Profiler API 1
profiling and tracing programs 1
PROGRAM_ERROR exception 1
program limits 1
pseudocolumn
- OBJECT_VALUE 1
pseudoinstruction
- See: pragma
pseudorecord 1
- See also: correlation name
public package item
- appropriate 1
- collection type as 1
- cursor variable as 1
- declaring 1
- RECORD type as 1
- referencing 1
- remote variable 1
- scope of 1
- visibility of 1
publishing events 1
purity rules for subprograms 1

Q

qualified name
- See: dot notation
qualified remote name 1
query
- implicitly returning results of 1
- invoking function in 1
- processing result set of
  - multiple-row dynamic query 1
quotation mark, single or double 1
quoted user-defined identifier 1

R

RAISE_APPLICATION_ERROR procedure 1
RAISE statement
- syntax diagram 1
raising exception explicitly 1
range test 1
read-only transaction 1
read-write transaction 1
recompiling stored PL/SQL unit 1
record
- as public package item 1
- assigning value to 1
- comparing one to another 1
- creating
  - syntax diagram 1
- declaring constant 1
- nested
  - See nested record 1
- representing row 1
- types of 1
recursive subprogram
- result-cached 1
recursive trigger 1
REF CURSOR
- See: cursor variable
REF CURSOR type 1
relational operator
- collection and 1
RELEASE constant 1
remote exception handling
- subprograms and 1
- triggers and 1
remote name 1
remote public package variable 1
remote subprogram
- exceptions in 1
- invoked by trigger 1
- with composite parameter 1
REPEAT UNTIL structure 1
replacing stored PL/SQL unit 1
reraising exception 1
reserved preprocessor control token 1
reserved words
- information about 1
- list of 1
RESTRICT_REFERENCES pragma 1
RESULT_CACHE clause 1
RESULT_CACHE option for function 1 , 2
result cache 1
RETURN_RESULT procedure 1
RETURN clause of function 1
RETURNING INTO clause
- BULK COLLECT clause of
  - FORALL statement and 1
returning query results implicitly 1
RETURN INTO clause
- See: RETURNING INTO clause
RETURN statement 1
REUSE SETTINGS clause 1
ROLLBACK statement
- FOR UPDATE cursor and 1
- implicit 1
- in autonomous transaction 1
- transparent 1
rowid 1
ROWID data type 1
ROWID pseudocolumn
- instead of CURRENT OF clause 1
row-level trigger 1
ROWNUM pseudocolumn
- bulk SELECT operation and 1
- single-row result set and 1
ROWTYPE_MISMATCH exception
- error code for 1
- example of 1
runtime error
- See: exception

S

same-scope capture 1
SAMPLE clause 1
SAVEPOINT statement
- in autonomous transaction 1
scalability
- SERIALLY_REUSABLE packages and 1
- subprograms and 1
scalar data type 1
scalar variable
- assigning value to 1
- declaration
  - syntax diagram 1
- initial value of 1
schema object
- See: stored PL/SQL unit
SCHEMA trigger 1
scope of identifier 1
searched CASE expression 1
searched CASE statement
- syntax diagram 1
security mechanism
- against SQL injection 1
- PL/SQL source text wrapping
  - benefit of 1
  - limitations of 1
- trigger as 1
SELECT FOR UPDATE statement 1
SELECT INTO statement
- assigning values with
  - to record variable 1
  - to scalar variables 1
- avoiding inner capture in 1
- query result set processing with 1
- SQL%NOTFOUND attribute and 1
- SQL%ROWCOUNT attribute and 1
- syntax diagram 1
- with BULK COLLECT clause 1
selection directive 1
selector
- in simple CASE expression 1
- in simple CASE statement 1
SELF_IS_NULL exception 1
sequence 1
sequential control statement 1
SERIALLY_REUSABLE package 1
SERIALLY_REUSABLE pragma 1
session cursor 1
set data structure 1
set membership test 1
SET TRANSACTION statement 1
SEVERE compile-time warning 1
short-circuit evaluation
- how it works 1
- tuning code and 1
side effects of subprogram 1
SIGNTYPE subtype 1
SIMPLE_DOUBLE subtype
- tuning code and 1
SIMPLE_FLOAT subtype
- tuning code and 1
SIMPLE_INTEGER subtype
- tuning code and 1
simple CASE expression 1
simple CASE statement
- IF THEN ELSIF statement and 1
- syntax diagram 1
simple DML trigger 1
simple name 1
single-line comment 1
single quotation mark (’) 1
sparse collection
- FORALL statement for 1
- SQL%BULK_EXCEPTIONS and 1
- traversing 1
specification
- cursor 1
- function 1
- package
  - See package specification 1
- procedure 1
SQL
- bulk
  - in compound DML trigger 1
- dynamic
  - See dynamic SQL 1
- static
  - See static SQL 1
SQL*Loader and triggers 1
SQL%BULK_EXCEPTIONS cursor attribute 1
SQL%BULK_ROWCOUNT cursor attribute 1
SQL%FOUND cursor attribute 1
SQL%NOTFOUND cursor attribute 1
SQL%ROWCOUNT cursor attribute 1
SQLCODE function 1
SQL cursor
- See: implicit cursor
SQL data type 1
SQLERRM function
- SQL%BULK_EXCEPTIONS and 1
SQL function
- in PL/SQL expression 1
- tuning and 1
SQL injection 1
SQL integration in PL/SQL 1
SQLJ object type, creating 1
SQL multiset condition 1
SQL MULTISET operator 1
SQL optimizer 1
SQL statement
- for stored PL/SQL unit 1
- in trigger 1
- invoking collection method in 1
- invoking PL/SQL function in 1
- tuning 1
standalone subprogram
- function
  - creating 1
  - dropping 1
  - explicitly recompiling 1
  - replacing 1
- procedure
  - creating 1
  - dropping 1
  - explicitly recompiling 1
  - replacing 1
STANDARD package
- data type defined in
  - See predefined data type 1
- exception defined in
  - See predefined exception 1
- how it defines PL/SQL environment 1
- listing identifiers defined in 1
- referencing item defined in 1
statement injection 1
statement-level trigger 1
statement modification 1
static constant
- in DBMS_DB_VERSION package 1
static expression 1
static SQL
- AUTHID property and 1
- name resolution in 1
- PL/SQL identifier in 1
- placeholder for bind variable in
  - OPEN FOR statement and 1
STORAGE_ERROR exception
- recursive invocation and 1
stored PL/SQL unit
- creating 1
- recompiling 1
- replacing 1
- wrapping 1
stored subprogram
- unhandled exception in 1
- wrapping 1
store table 1
string
- null 1
- zero-length 1
STRING subtype 1
strong REF CURSOR type
- creating 1
- FETCH statement and 1
subprogram
- inlining 1
- invoked by trigger 1
- remote
  - See remote subprogram 1
- unhandled exception in 1
subprogram invocation
- optimization of 1
- resolution of 1
- syntax of 1
- tuning 1
subprogram parameter
- collection as 1
- composite variable as 1
- CURSOR expression as actual 1
- cursor variable as 1
- optional 1
- query result as 1
- required 1
subquery
- correlated 1
- result set processing with 1
SUBSCRIPT_BEYOND_COUNT exception 1
SUBSCRIPT_OUTSIDE_LIMIT exception 1
subtype
- constrained
  - subprogram parameter and 1
- of BINARY_DOUBLE data type 1
- of BINARY_FLOAT data type 1
- of PLS_INTEGER data type 1
- predefined 1
- unconstrained 1
- user-defined 1
synonym 1
SYS_INVALID_ROWID exception 1
SYS_REFCURSOR type 1
system trigger 1

T

table
- hash 1
- index-by
  - See associative array 1
- mutating 1
- nested
  - characteristics of 1
- parallel DML for large 1
- PL/SQL
  - See associative array 1
- store 1
- unordered 1
- updating large in parallel 1
table alias
- for avoiding inner capture 1
- for row expression 1
- for table element attribute or method 1
table function
- pipelined
  - See pipelined table function 1
- weak cursor variable argument to 1
TABLE operator 1
TCL statement
- in subprogram invoked by trigger 1
- in trigger 1
template object 1
TIMEOUT_ON_RESOURCE exception 1
timing point
- of DML trigger
  - compound 1
  - simple 1
- of system trigger 1
- trigger firing order and 1
TO_NUMBER function 1
TO_REFCURSOR function 1
TOO_MANY_ROWS exception 1
Trace API 1
trace file 1
tracing and profiling programs 1
transaction
- autonomous
  - pipelined table function in 1
- context of 1
- ending
  - with COMMIT statement 1
  - with ROLLBACK statement 1
- isolation level of 1
- nested 1
- read-only 1
- read-write 1
- retrying after handling exception 1
- SQL%ROWCOUNT cursor attribute and 1
- visibility of 1
Transaction Control Language
- See: TCL statement
TRANSACTIONS initialization parameter 1
trigger
- as security mechanism 1
- AUTHID property and 1
- autonomous 1
- cascading 1
- DDL statement in 1
- hiding implementation details of 1
- materialized view and 1
- recursive 1
- TCL statement in 1
TRIM collection method 1
tri-state logic 1
tuning PL/SQL code 1
type
- See: data type
type-compatible data type
- for collection variables 1
- for scalar variables 1

U

UDF pragma 1
unconstrained subtype 1
underscore (_) wildcard character 1
unhandled exception
- in FORALL statement 1
unordered table 1
UPDATE statement
- BEFORE statement trigger and 1
- PL/SQL extensions to 1
- with values in record
  - restrictions on 1
UPDATING conditional predicate 1
UROWID data type 1
USER_DUMP_DEST initialization parameter 1
user-defined exception
- giving error code to 1
- raising
  - with RAISE_APPLICATION_ERROR procedure 1
  - with RAISE statement 1
user-defined identifier
- collecting data about 1
user-defined subtype 1
user-defined type
- See: Abstract Data Type (ADT)
utlrp.sql script 1

V

V$RESERVED_WORDS view 1
validation check for avoiding SQL injection 1
VALUE_ERROR exception 1
VARCHAR2 data type 1
VARCHAR2 static expression 1
VARCHAR subtype 1
variable
- binding of 1
- BOOLEAN 1
- collection
  - See collection 1
- composite 1
- cursor
  - See cursor variable 1
- host
  - cursor variable as 1
  - packages and 1
- in cursor variable query 1
- in explicit cursor query 1
- locator 1
- record
  - See record 1
- remote public package 1
- scalar
  - See scalar variable 1
- with undefined value 1
variable-size array
- See: varray
varray
- assigning null value to 1
- characteristics of 1
- comparing to NULL 1
- COUNT method for 1
- FIRST and LAST methods for 1
- returned by function 1
VERSION constant 1
view
- AUTHID property and 1
- INSTEAD OF trigger and 1
- materialized, trigger and 1
virtual column
- %ROWTYPE attribute and 1
- explicit cursors and 1
visibility
- of identifier 1
- of transaction 1

W

warning, compile-time 1
weak REF CURSOR type
- creating 1
- FETCH statement and 1
WHILE LOOP statement
- syntax diagram 1
white list
- See: ACCESSIBLE BY clause
whitespace character
- between lexical units 1
- in character literal 1
- in database character set 1
wildcard character 1
WRAP function 1
wrapping PL/SQL source text
- inquiry directives and 1
wrap utility
- See: PL/SQL Wrapper utility

Z

ZERO_DIVIDE exception 1
zero-length string 1

Scripting on this page enhances content navigation, but does not change the content in any way.