Flylib.com

Books Software

 
 
 

Oracle PL/SQL Language Pocket Reference (Pocket Reference (OReilly)) - page 39

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W]

methods in subtypes (Oracle9i) 
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 
     methods in subtypes  
    natively compiling stored programs 
    object types 
    type inheritance 
    upcasting/ downcasting subtypes 
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 cursors  
stored functions, calling from SQL statements 
stored programs, compiling 
    natively 
string literals 
subtypes , constrained/unconstrained