|
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W]
methods, types of modes of parameters MULTISET pseudo-function mutual recursion |
|
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W]
named notation NCHAR datatype NCLOB datatype nested collections nested tables initializing 2nd syntax for declaring nesting records NEXT function NLS (national character set) datatypes external procedures and NOCOPY option NOT INSTANTIABLE method modifier NOT NULL constraint %NOTFOUND attribute NULL statements NULLs in PL/SQL numeric datatypes numeric literals NVARCHAR2 datatype |
|
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W]
object types, changing object-oriented features OPEN FOR statement OR REPLACE keyword Oracle object-oriented features and PL/SQL Oracle8i autonomous transactions and 2nd determining purity levels of programs SQL%BULK_ROWCOUNT attribute and Oracle9i CASE expressions CASE statements compiling stored PL/SQL programs datetime interval datatypes 2nd external procedures natively compiling stored programs object types type inheritance upcasting/ OUT parameters overloading programs OVERRIDING method modifier |
|
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W]
packaged functions, calling in SQL packages in PL/SQL PARALLEL_ENABLED keyword parameters default values for external procedures and modes of passing arguments in parameter lists PIPE ROW command PIPELINED keyword PLS_INTEGER datatype positional notation PRAGMA keyword predicates, trigger PRIOR function privileges and stored PL/SQL procedures in PL/SQL propagating exceptions purity levels of programs, determining |
|
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W]
raising exceptions records in PL/SQL recursion, mutual REF operator REF_CURSOR types referencing fields of records REPEAT UNTIL loop emulation reserved words in PL/SQL 2nd RESTRICT_REFERENCES pragma 2nd RETURN keyword ROLLBACK statement %ROWCOUNT attribute %ROWTYPE attribute |
|
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W]
SAVEPOINT statement scalar datatypes scope of exceptions searched CASE expressions searched CASE statements SELECT FOR UPDATE clause sequential control statements SERIALLY_REUSABLE pragma 2nd SERVERERROR event 2nd SET TRANSACTION statement SHUTDOWN event 2nd specification, package SQL statements, calling stored functions from SQL%BULK_ROWCOUNT attribute SQL%FOUND attribute SQL%ISOPEN attribute SQL%NOTFOUND attribute SQL%ROWCOUNT attribute SQLCODE function SQLERRM function STARTUP event 2nd statements in PL/SQL static stored functions, calling from SQL statements stored programs, compiling natively string literals |