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
- %ISOPEN cursor attribute
- %NOTFOUND cursor attribute
- %ROWCOUNT cursor attribute
- %ROWTYPE attribute 5.12.4
- %TYPE attribute 2.3.5
- % 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
- 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
- alias
- 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
- assignment of value
- assignment statement 2.6.1
- syntax diagram 13.3
- associative array 5.2
- See also: collection
- atomic (lexical) unit 2.2
- atomically null collection
- See: null collection
- attribute
- AUTHID property 8.14
- syntax diagram 13.41
- AUTONOMOUS_TRANSACTION pragma 6.7.4
- autonomous routine 6.7
- declaring 6.7.4
- autonomous transaction 6.7
- 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
- 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
- in compound DML trigger 9.3.3.3
C
- cache, function result 8.12
- calculated column
- See: virtual column
- call specification 8.15
- 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
- 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
- See index collection 12.4.1.1
- 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
- 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
- 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
- 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
- CURRVAL pseudocolumn 6.1.2.1
- cursor 6.2
- CURSOR_ALREADY_OPEN exception 11.4
- cursor attribute
- CURSOR expression 6.5
- passing to pipelined table function 12.5.6
- cursor FOR LOOP statement
- cursor number
- cursor parameter 6.2.2.6
- cursor specification 13.30
- cursor variable 6.4
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
- data type conversion 3.1
- data type family 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
- deadlock
- declaration 2.3
- exception raised in 11.8.1
- DEFAULT COLLATION clause 13.20
- 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
- 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
- DML trigger 9.3
- dot notation
- 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
- DUP_VAL_ON_INDEX exception 11.4
- dynamic SQL 7
E
- editioned 14.6
- editioned Abstract Data Type (ADT) 14.6
- element of collection 5
- element specification
- 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
- 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
- exception handler 11.2
- 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
- explicit cursor 6.2.2
- 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
- FETCH FIRST clause 12.4.2.1.2
- FETCH statement
- field of record 5
- FIRST collection method 5.10.5
- FORALL statement 12.4.1
- FOR LOOP statement 4.2.6
- See also: cursor FOR LOOP statement
- 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
- function result cache 8.12
- function specification 13.36
I
- identifier 2.2.2, 2.4
- See also: name
- IDL C
- IF statement 4.1
- imp and triggers 9.14
- implicit cursor 6.2.1
- implicit data type conversion
- 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
- 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
- INSTEAD OF trigger 9.1
- 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
- collections and 5.9.1
- isolation level of transaction 6.7.3
L
- labeled LOOP statement 4.2.3
- LAST collection method 5.10.5
- LEVEL pseudocolumn 6.1.2
- lexical unit 2.2
- library
- 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
- 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
- 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
- multibyte character set
- 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
- 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
- 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
- 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
- SQLCODE for 11.4
- NOCOPY hint 13.35
- 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
- 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
- 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)
- 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
- body of
- 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
- parallel DML
- parameter
- parameter mode 8.7.3
- PARENT correlation name 9.4
- with LONG or LONG RAW column 9.10.2
- parentheses
- 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
- 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
- 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
- stored
- PL/SQL Wrapper utility A.3
- placeholder for bind variable
- 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
- 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
- OBJECT_VALUE 9.4.1
- pseudoinstruction
- See: pragma
- pseudorecord 9.4
- See also: correlation name
- public package item
- publishing events 9.15
- purity rules for subprograms 8.13
Q
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
- 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
- remote name 2.4
- remote public package variable 10.3.1
- remote subprogram
- 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
- bulk SELECT operation and 12.4.2.1.2
- single-row result set and 6.3.1.1
- 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
- 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
- SELECT FOR UPDATE statement 6.6.6.2
- SELECT INTO statement 6.1.1
- See also: query
- selection directive 2.9.1.2
- selector
- 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_EXIT_ON_PACKAGE_STATE_ERROR initialization parameter 10.6
- 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
- short-circuit evaluation
- 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
- 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
- SQL
- 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
- 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
- standalone subprogram 8.2
- STANDARD package
- 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
- STORAGE_ERROR exception 11.4
- recursive invocation and 8.10
- stored PL/SQL unit 1.3.2
- stored subprogram 8.2
- 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
- subprogram invocation
- subprogram parameter 8.7
- subprogram property 8.4
- subquery
- SUBSCRIPT_BEYOND_COUNT exception 11.4
- SUBSCRIPT_OUTSIDE_LIMIT exception 11.4
- subtype 3
- See also: data type
- synonym 2.4
- SYS_INVALID_ROWID exception 11.4
- SYS_REFCURSOR type 6.4.1
- system trigger 9.5
T
- table
- table alias
- table function 12.5.1
- TABLE operator 6.4.6
- TCL statement 6.1.1
- template object 8.14.2
- TIMEOUT_ON_RESOURCE exception 11.4
- timing point
- 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
- Transaction Control Language
- See: TCL statement
- TRANSACTIONS initialization parameter 6.7.5.4
- trigger 9
- 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
- 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
- UPDATING conditional predicate 9.3.1
- UROWID data type 3.1.6
- user-defined exception 11.5
- 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
- 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
- virtual column
- visibility
W
- warning, compile-time 11.1
- weak REF CURSOR type
- WHILE LOOP statement 4.2.7
- syntax diagram 13.68
- white list
- See: ACCESSIBLE BY clause
- whitespace character
- 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