Index

Symbols

_ wildcard character 2.7.5.3
$$PLSQL_LINE inquiry directive 2.9.1.4.1
$$PLSQL_UNIT_OWNER inquiry directive 2.9.1.4.1
$$PLSQL_UNIT_TYPE inquiry directive 2.9.1.4.1
$$PLSQL_UNIT inquiry directive 2.9.1.4.1
%BULK_EXCEPTIONS cursor attribute 12.4.1.4
%BULK_ROWCOUNT cursor attribute 12.4.1.5
%FOUND cursor attribute
- for implicit cursor 6.2.1.2
- for named cursor 6.2.2.7.2
%ISOPEN cursor attribute
- for implicit cursor 6.2.1.1
- for named cursor 6.2.2.7.1
%NOTFOUND cursor attribute
- for implicit cursor 6.2.1.3
- for named cursor 6.2.2.7.3
%ROWCOUNT cursor attribute
- for implicit cursor 6.2.1.4
- for named cursor 6.2.2.7.4
%ROWTYPE attribute 5.12.4
- column alias and 6.2.2.5
- explicit cursor and 6.2.2.5
- invisible columns and 5.12.4.4
- syntax diagram 13.57
- virtual columns and 5.12.4.3
%TYPE attribute 2.3.5
- initial value and 2.3.5
- NOT NULL constraint and 2.3.5
- syntax diagram 13.65
% wildcard character 2.7.5.3

A

Abstract Data Type (ADT) 1.2.8.5, 14.6
- creating 14.13
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
accessor list 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
  - in cursor FOR LOOP 6.3.2
  - in explicit cursor 6.2.2.5
- 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
- metadata-linked 13.61
architecture of PL/SQL 1.3
array
- associative
  - See associative array 5.1
- non-PL/SQL 5.1
assignment of value
- to composite variable
  - collection 5.7
  - record 5.13
- 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
- syntax diagram 13.41
AUTONOMOUS_TRANSACTION pragma 6.7.4
- for pipelined table function 12.5.2
- syntax diagram 13.4
autonomous routine 6.7
- declaring 6.7.4
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
- predefined constants for 3.1.2
- subtype of 3.1.3
- tuning code and 12.3.5.1
BINARY_FLOAT data type
- predefined constants for 3.1.2
- subtype of 3.1.3
- tuning code and 12.3.5.1
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
- in assignment 3.1.4.3.2
- in comparison 3.1.4.3.3
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
- aliasing and 12.4.2.1.1
- of FETCH statement 12.4.2.2
- of RETURNING INTO clause
  - FORALL statement and 12.4.3
- of SELECT INTO statement 12.4.2.1
- query result set processing and 6.3.1.2
- that returns no rows 12.4.2
bulk SQL 12.4
- in compound DML trigger 9.3.3.3

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
- searched 2.7.7.2
- simple 2.7.7.1
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
  - quoted user-defined identifier 2.2.2.3.2
- keyword and D
- LIKE operator and 2.7.5.3
- reserved word and D
CASE statement 4.1
- searched 4.1.5
  - syntax diagram 13.8
- simple 4.1.4
  - IF THEN ELSIF statement and 4.1.3
  - syntax diagram 13.8
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
  - See index collection 12.4.1.1
- internal size of
  - DELETE method and 5.10.1
  - EXTEND method and 5.10.3
  - TRIM method and 5.10.2
- multidimensional 5.8
- null 5.1
  - assigning to collection variable 5.7.2
- pipelined table function and 12.5.1
- querying
  - with dynamic SQL 7.2.2
  - with static SQL 6.4.6
- 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
- in cursor FOR LOOP 6.3.2
- in explicit cursor 6.2.2.5
COLUMNS pseudo-operator 12.6.3.2
comment 2.2.5
- nested 2.2.5.2
- PL/SQL Wrapper utility and A.3
- syntax diagram 13.12
COMMIT statement 6.6.1
- FOR UPDATE cursor and 6.6.6.3
- in autonomous transaction 6.7.5.2
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
- conditional 2.9
- for native execution 12.10
- interpreted 12.10.5
compilation parameter 1.3.2
- displaying value of 2.9.1.4.1
- predefined inquiry directive for 2.9.1.4.1
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
- error 2.9.1.3
- inquiry 2.9.1.4
- restrictions on 2.9.4
- selection 2.9.1.2
conditional predicate 9.3.1
conditional selection statement 4.1
conditional trigger 9.1
constant
- declaring 2.3.3
  - associative array 5.2.1
  - record 5.12.2
  - syntax diagram 13.14
- initial value of 2.3.4
- predefined 3.1.2
- static 2.7.9.4
  - in DBMS_DB_VERSION package 2.9.1.5
constrained subtype 3.4.2
- in performance-critical code 12.3.5.2
- subprogram parameter and 8.7.1.1
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
- syntax diagram 13.15
CONTINUE WHEN statement 4.2.5
- syntax diagram 13.15
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
- FOR UPDATE cursor and 6.6.6.2
- ROWID pseudocolumn instead of 6.6.6.3
CURRVAL pseudocolumn 6.1.2.1
cursor 6.2
- explicit
  - See explicit cursor 6.2.2
- FOR UPDATE 6.6.6.2
  - after COMMIT or ROLLBACK 6.6.6.3
- 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
- for cursor variable 6.4.7
- for explicit cursor 6.2.2.7
  - %FOUND 6.2.2.7.2
  - %ISOPEN 6.2.2.7.1
  - %NOTFOUND 6.2.2.7.3
  - %ROWCOUNT 6.2.2.7.4
- for implicit cursor 6.2.1
  - DBMS_SQL package and 7.3
  - native dynamic SQL and 7.2
  - SQL%BULK_EXCEPTIONS 12.4.1.4
  - SQL%BULK_ROWCOUNT 12.4.1.5
  - SQL%FOUND 6.2.1.2
  - SQL%ISOPEN 6.2.1.1
  - SQL%NOTFOUND 6.2.1.3
  - SQL%ROWCOUNT 6.2.1.4
- where you can use 6.2
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
- DR units 8.14.3
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
- exception raised in 11.8.1
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
- of cursor parameter 6.2.2.6.1
- of subprogram parameter 8.7.5
DEFINE
- binding category 12.4
definer’s rights clause 13.41
definer’s rights unit
- See: DR unit
DELETE collection method 5.10.1
- COUNT method and 5.10.6
- EXISTS method and 5.10.4
- EXTEND method and 5.10.3
- FIRST method and 5.10.5
- LAST method and 5.10.5
- NEXT method and 5.10.8
- PRIOR method and 5.10.8
- TRIM method and 5.10.2
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
- compiler
  - See pragma 2.2.4
- error 2.9.1.3
- inquiry 2.9.1.4
- selection 2.9.1.2
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
- SQLCODE 13.62
- SQLERRM 13.63
  - SQL%BULK_EXCEPTIONS and 12.4.1.4
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
  - in FORALL statement 12.4.1.2
- 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
- syntax diagram 13.28
EXISTS collection method 5.10.4
exiting a loop 4.2
EXIT statement 4.2.2
- syntax diagram 13.29
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
  - declaring 10.8
  - opening and closing 10.7.3
- 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
- CURSOR 6.5
  - passing to pipelined table function 12.5.6
- data type of 2.7
- in explicit cursor 6.2.2.5
- SQL function in PL/SQL 2.7.8
- static 2.7.9
- syntax diagram 13.31
EXTEND collection method 5.10.3
external subprogram 8.15
- call specification 13.7

F

FETCH FIRST clause 12.4.2.1.2
FETCH statement
- across COMMIT 6.6.6.3
- record variable and 5.13.2.2
- syntax diagram 13.32
- that returns no row 6.2.2.3
- with BULK COLLECT clause 12.4.2.2
- with cursor variable 6.4.3
- with explicit cursor 6.2.2.3
field of record 5
FIRST collection method 5.10.5
FORALL statement 12.4.1
- associative array in 13.34
- bulk binding and 12.4
- BULK COLLECT clause and 12.4.3
- for sparse collection 12.4.1.1
  - SQL%BULK_EXCEPTIONS and 12.4.1.4.1
- handling exception raised in
  - after FORALL completes 12.4.1.4
  - immediately 12.4.1.3
- number of rows affected by 12.4.1.5
- syntax diagram 13.34
- unhandled exception in 12.4.1.2
FOR LOOP statement 4.2.6
- See also: cursor FOR LOOP statement
- bounds of 4.2.6.2
- FORALL statement and 12.4.1
- STEP clause and 4.2.6
- syntax diagram 13.33
format model 7.4.2.3
FOR UPDATE cursor 6.6.6.2
- after COMMIT or ROLLBACK 6.6.6.3
forward declaration of subprogram 8.6
function 8
- See also: subprogram
- aggregate
  - See aggregate function 12.5.6
- built-in
  - See SQL function 12.3.6
- declaration syntax diagram 13.36
- error-reporting
  - SQLCODE 13.62
  - SQLERRM 12.4.1.4
- invoking 8.3
  - in SQL statement 8.13
- options for 8.5.1
- SQL
  - See SQL function 12.3.6
- structure of 8.5.1
- table
  - See table function 12.5.1
function result cache 8.12
function specification 13.36

G

generated column
- See: virtual column
GET_NEXT_RESULT procedure 7.3.2
global identifier 2.5
GOTO statement 4.3.1
- restrictions on 13.37
- syntax diagram 13.37
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
- bulk-binding 12.4.4
- cursor variable as 6.4.9
- packages and 10.2

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
- representing subset with 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
- %TYPE attribute and 2.3.5
- NOT NULL constraint and 2.3.1
- of constant 2.3.4
- of variable
  - nested table 5.4
  - record 5.12.1
  - scalar 2.3.4
  - varray 5.3
INLINE pragma 12.1.1
- syntax diagram 13.40
inner capture B.5.3
- avoiding B.6
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
- giving name to 11.3
- raising explicitly 11.7.1.2
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
- call stack and 8.14
- dynamic SQL and 8.14
- granting roles to 8.14.1
- name resolution and 8.14
- privilege checking and 8.14
- static SQL and 8.14, 8.14.2
- template objects for 8.14.2
IS [NOT] NULL operator 2.7.5.1
- collections and 5.9.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

labeled LOOP statement 4.2.3
LAST collection method 5.10.5
LEVEL pseudocolumn 6.1.2
lexical unit 2.2
library
- creating 14.8
- dropping 14.16
- explicitly recompiling 14.2
library arithmetic 12.3.5.1
LIKE operator 2.7.5.3
LIMIT clause 12.4.2.2.1
LIMIT collection method 5.10.7
line-continuation character 2.2.3
literal 2.2.3
local identifier 2.5
locator variable 11.2.2
locking
- overriding default 6.6.6
- result set row 6.6.6.2
- table 6.6.6.1
lock mode 6.6.6.1
LOCK TABLE statement 6.6.6.1
logical operator 2.7.3
logical value 3.2
LOGIN_DENIED exception 11.4
LONG data type 3.1.5
- in trigger 9.10.2
LONG RAW data type 3.1.5
- in trigger 9.10.2
LOOP statement
- exiting 4.2
- kinds of 4.2
- labeled 4.2, 4.2.3
- nested 4.2.3
- optimizing 12.3.4
LOOP UNTIL structure 4.2.7

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
- lock 6.6.6.1
- subprogram parameter 8.7.3
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
- for function 8.13
- for trigger 9.10.3

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
- assignment example 5.13.1
- declaration example 5.12.3
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
- associative array and 5.2.2
- character comparison and 2.7.5.2.3
- SQL injection and 7.4.1.3
NO_DATA_FOUND exception 11.4
NO_DATA_NEEDED exception 12.5.8
- SQLCODE for 11.4
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
- %TYPE attribute and 2.3.5
- EXTEND method and 5.10.3
NOT operator 2.7.3
null collection 5.1
- assigning to collection variable 5.7.2
- collection method and 5.10
NULL statement
- syntax diagram 13.44
- uses for 4.3.2
null string 2.2.3
NULL value
- assigning to record variable 5.13.3
- comparing to collection
  - associative array 5.9
  - nested table 5.9.1
  - varray 5.9.1
- 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
- inefficiency of 12.3.5.1
- members of E

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
- comparison 2.7.5
  - cursor variable and 13.18
- logical 2.7.3
- relational 2.7.5.2
  - collection and 5.9
operator precedence 2.7.2
optimizer
- PL/SQL 12.1
- SQL 12.5.5
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
- INLINE pragma and 12.1.1

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
- creating 14.10
- dropping 14.17
- initialization part of 10.4
  - assigning initial values in 10.8
- replacing 14.10
package specification 10.1, 10.3
- See also: public package item
- creating 14.9
- cursor variable in 13.18
- dropping 14.17
- replacing 14.9
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
- syntax diagram 13.49
PIPELINED option 12.5.1
- where to specify 12.5.2
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
- in autonomous routine 6.7.5.4
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
- tuning code and 12.3.5.1
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
- compilation and execution 12.6.4
- definition 12.6.1
- implementation 12.6.2
- invocation 12.6.3
  - COLUMNS pseudo-operator 12.6.3.2
- optimization 12.6.5
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
- AUTONOMOUS_TRANSACTION 13.4
  - for pipelined table function 12.5.2
- COVERAGE 13.16
- DEPRECATE 13.22
- EXCEPTION_INIT 13.25
- INLINE 12.1.1
  - syntax diagram 13.40
- RESTRICT_REFERENCES 13.53
- SERIALLY_REUSABLE 13.60
- UDF 13.66
precedence, operator 2.7.2
predefined constant 3.1.2
predefined data type E
predefined exception 11.4
- raising explicitly 11.7.1.2
- redeclared 11.6
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
- declaration syntax 13.50
- invoking 8.3
- structure of 8.5.1
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
- OBJECT_VALUE 9.4.1
pseudoinstruction
- See: pragma
pseudorecord 9.4
- See also: correlation name
public package item
- appropriate 10.3.1
- collection type as 5.11
- cursor variable as 13.18
- declaring 10.3
- RECORD type as 5.12.3
- referencing 10.3
- remote variable 10.3.1
- scope of 10.3
- visibility of 10.3
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
- syntax diagram 13.51
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
- as public package item 5.12.3
- assigning value to 5.13
- comparing one to another 5.14
- creating 5.12
  - syntax diagram 13.52
- declaring constant 5.12.2
- nested
  - See nested record 5.12.3
- representing row 5.12.4
- types of 5.12.3
recursive subprogram 8.10
- result-cached 8.12.4.2
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
- information about 2.2.2.1
- list of D
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
- BULK COLLECT clause of 12.4.2.3
  - FORALL statement and 12.4.3
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
- FOR UPDATE cursor and 6.6.6.3
- implicit 6.6.4
- in autonomous transaction 6.7.5.2
- transparent 9.9
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
- bulk SELECT operation and 12.4.2.1.2
- single-row result set and 6.3.1.1
ROWTYPE_MISMATCH exception
- error code for 11.4
- example of 11.4
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
- assigning value to 2.6
- declaration 2.3.2
  - syntax diagram 13.58
- initial value of 2.3.4
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
  - to record variable 5.13.2.1
  - to scalar variables 2.6.2
- 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
- how it works 2.7.4
- tuning code and 12.3.7
side effects of subprogram 8.11
SIGNTYPE subtype 3.3.2
SIMPLE_DOUBLE subtype 3.1.3
- tuning code and 12.3.5.1
SIMPLE_FLOAT subtype 3.1.3
- tuning code and 12.3.5.1
SIMPLE_INTEGER subtype 3.3.3
- tuning code and 12.3.5.1
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
- FORALL statement for 12.4.1.1
- SQL%BULK_EXCEPTIONS and 12.4.1.4.1
- traversing 5.10.8
specification
- cursor 13.30
- function 13.36
- package
  - See package specification 10.1
- procedure 13.50
SQL
- bulk 12.4
  - in compound DML trigger 9.3.3.3
- dynamic
  - See dynamic SQL 7
- static
  - See static SQL 6
SQL_MACRO 13.64
SQL_MACRO clause
- in CREATE FUNCTION statement 14.7
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%BULK_EXCEPTIONS and 12.4.1.4
SQL function
- in PL/SQL expression 2.7.8
- tuning and 12.3.6
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
- function
  - creating 14.7
  - dropping 14.15
  - explicitly recompiling 14.1
  - replacing 14.7
- procedure
  - creating 14.11
  - dropping 14.18
  - explicitly recompiling 14.4
  - replacing 14.11
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
- null 2.2.3
- zero-length 2.2.3
STRING subtype 3.1.4.3.1
strong REF CURSOR type
- creating 6.4.1
- FETCH statement and 6.4.3
subprogram 8
- inlining 12.1.1
- invoked by trigger 9.6
- remote
  - See remote subprogram 5
- unhandled exception in 11.9
subprogram invocation
- optimization of 12.1.1
- resolution of 8.8
- syntax of 8.3
- tuning 12.3.3
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
  - subprogram parameter and 8.7.1.1
- 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
  - compound 9.3.3.1
  - simple 9.3
- 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.66
unconstrained subtype 3.4.1
underscore (_) wildcard character 2.7.5.3
unhandled exception 11.9
- in FORALL statement 12.4.1.2
unordered table 5.1
UPDATE statement 13.67
- See also: DML statement
- BEFORE statement trigger and 9.9
- PL/SQL extensions to 13.67
- 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
  - cursor variable as 6.4.9
  - packages and 10.2
- 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
- assigning null value to 5.7.2
- characteristics of 5.1
- comparing to NULL 5.9.1
- COUNT method for 5.10.6.1
- FIRST and LAST methods for 5.10.5.2
- returned by function 12.5.1
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
- %ROWTYPE attribute and 5.12.4.3
- explicit cursors and 6.2.2.5
visibility
- of identifier 2.5
- of transaction 6.7.3

W

warning, compile-time 11.1
weak REF CURSOR type
- creating 6.4.1
- FETCH statement and 6.4.3
WHILE LOOP statement 4.2.7
- syntax diagram 13.68
white list
- 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
- inquiry directives and 2.9.1.4.3
wrap utility
- See: PL/SQL Wrapper utility

Z

ZERO_DIVIDE exception 11.4
zero-length string 2.2.3