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]

Data Definition Language (DDL)  2nd  3rd 

data dictionary views 

Data Manipulation Language (DML)  2nd 

database administrator (DBA) 

database administrators (DBA) 

database event publication feature 

database logins, tracking 

database-level event triggers  2nd  3rd  4th 

DATABASE_NAME attribute, database-level event  2nd 

datatype mappings, legal 

DBA_CONTEXT data dictionary view 

DBA_ERRORS data dictionary view 

DBA_OBJECTS data dictionary view 

DBA_POLICIES data dictionary view 

DBA_SEGMENTS data dictionary view 

DBMS_AQ package  2nd 

DBMS_AQADM package 

DBMS_INDEXING package 

DBMS_JAVA package  2nd  3rd  4th 

DBMS_JAVA_TEST package  2nd  3rd  4th 

DBMS_LOB package 

DBMS_LOG_MNR package 

DBMS_LOG_MNR_D package 

DBMS_OUTPUT package  2nd 

DBMS_PIPE package  2nd 

DBMS_PROFILER package  2nd 

DBMS_REPAIR package 

DBMS_REPCAT_FLA package 

DBMS_REPCAT_FLA_MAS package 

DBMS_REPCAT_FLA_UTL package 

DBMS_RESOURCE_MANAGER package 

DBMS_RESOURCE_MANAGER_PRIVS package 

DBMS_RLS package  2nd  3rd  4th 

DBMS_RULE package 

DBMS_RULE_ADM package 

DBMS_RULE_EXIMP package 

DBMS_SPACE_ADMIN package 

DBMS_SQL compared to native dynamic SQL 

DBMS_SQL package  2nd  3rd 

DBMS_STATS package 

DBMS_SUMMARY package 

DBMS_TRACE package  2nd  3rd 

DBMS_TTS package 

DBMS_UTILITY package  2nd 

dbmspbp.sql file 

DDL (Data Definition Language)  2nd  3rd 

deadlock example 

DECLARE statement 

deep copies 

define_variable, EXECUTE IMMEDIATE statement 

definer rights models 

DEL column, *_POLICIES data dictionary views 

DELETE statement  2nd  3rd  4th 

deleting files from PL/SQL 

DEQUEUE option, GRANT_QUEUE_PRIVILEGE procedure 

DEQUEUE procedure, DBMS_AQ package 

DEQUEUE_ANY option, GRANT_SYSTEM_PRIVILEGE procedure 

DES_ENCRYPTED_PASSWORD attribute, schema-level event 

DETERMINISTIC keyword  2nd 

DICTIONARY_OBJ_NAME attribute, schema-level events 

DICTIONARY_OBJ_OWNER attribute, schema-level events 

DICTIONARY_OBJ_TYPE attribute, schema-level events 

diffcount.sql file 

directory contents, obtaining 

disk accompanying book 

DML (Data Manipulation Language)  2nd 

DROP JAVA statement 

DROP statement  2nd  3rd 

DROP_POLICY procedure, DBMS_RLS package  2nd 

dropjava utility  2nd 

duplicate placeholders 

duplicate placeholders, native dynamic SQL 

dur parameter, CREATETEMPORARY procedure 

dynamic cursors  

dynamic ids 

dynamic PL/SQL 

dynamic SQL

    blocks

        scope of variables  

    cursors, reusing 

    Method 4 

dynPLSQL program, ndsutil.pkg file 

dynplsql.sp (companion disk) 

dynvar.pkg file 


Team-Fly    
Top

Категории