Oracle PL/SQL Programming: Guide to Oracle8i Features

Team-Fly    

  
Oracle PL/SQL Programming Guide to Oracle 8 i Features

By Steven Feuerstein

Table of Contents

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

NAME_IN program, Oracle Developer's FormsBuilder 

NAMESPACE column,*_CONTEXT data dictionary views 

namespace parameter

    CREATE CONTEXT statment 

    SET_CONTEXT procedure 

NCLOB  [See NLS character large object]

NDS (native dyanmic SQL)

    argument modes, binding 

NDS (native dynamic SQL)  2nd  3rd 

    binding limitations 

    binding versus concatenation 

    DBMS_SQL, compared to 

    duplicate placeholders 

    dynamic PL/SQL 

    error handling 

    exclusive capabilities 

    EXECUTE IMMEDIATE statement 

    FETCH statement 

    generic GROUP BY package 

    generic GROUP BY procedure 

    multirow queries with cursor variables  

    OPEN FOR statement 

    sharing NDS programs with invoker rights 

    USING clause (OPEN FOR statement) 

    utility package 

ndsutil.pkg file 

nesting

    blocks 

    table columns , triggers on  2nd 

    table view columns 

    tables  2nd 

nesttrig.sql file 

NLS character large object 

NLS_CALENDAR attribute, SYS_CONTEXT function 

NLS_CURRENCY attribute, SYS_CONTEXT function 

NLS_DATE_FORMAT attribute, SYS_CONTEXT function 

NLS_DATE_LANGUAGE attribute, SYS_CONTEXT function 

NLS_SORT attribute, SYS_CONTEXT function 

NLS_TERRITORY attribute, SYS_CONTEXT function 

NO_DATA_FOUND error 

NOCOPY parameter mode hint  2nd 

    impact 

    overview 

    parameter aliasing 

    performance gains 

    restrictions 

non-bulk FOR loop 

notification capabilities 

NULL predicates 


Team-Fly    
Top

Категории