Oracle PL(s)SQL For DBAs
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] daisy-chaining 2nd data binary changing cryptographic hashing decrypting 2nd 3rd 4th dynamic access encrypting 2nd representative data dictionary views auditing and 2nd 3rd 4th RLS and VPD and data warehouses 2nd databases administering auditing version differences key management nested tables and PL/SQL programs and program data and randomizers scheduling jobs within transactions and Transparent Data Encryption datatypes abstract anchoring declarations and functions and 2nd interpreting errors naming NDS support pipelined table functions REF cursor and standardizing names types of DATE datatype dates BULK COLLECT clause datatypes passing DB_USER column 2nd 3rd DBA_AUDIT_POLICIES view 2nd 3rd DBA_AUDIT_TRAIL view DBA_COMMON_AUDIT_TRAIL view DBA_ENCRYPTED_COLUMNS view DBA_FGA_AUDIT_TRAIL view auditing and bind variables columns 2nd 3rd 4th FGA_LOG$ table and 2nd timestamps and DBA_POLICIES view 2nd DBA_SCHEDULER_JOB_CLASSES view 2nd 3rd DBA_SCHEDULER_JOB_LOG view 2nd 3rd DBA_SCHEDULER_JOB_RUN_DETAILS view 2nd DBA_SCHEDULER_JOBS view columns overview 2nd querying RUN_JOB procedure schedule ownership DBA_SCHEDULER_PROGRAMS view DBA_SCHEDULER_RUNNING_JOBS view DBA_SCHEDULER_SCHEDULES view DBA_SCHEDULER_WINDOW_DETAILS view 2nd DBA_SCHEDULER_WINDOW_GROUPS view DBA_SCHEDULER_WINDOW_LOG view DBA_SCHEDULER_WINDOWS view 2nd DBA_SCHEDULER_WINGROUP_MEMBERS view DBMS_CRYPTO package components decrypting data 2nd differences from DBMS_OBFUSCATION_TOOLKIT 2nd 3rd encrypting data hashing algorithms 2nd Oracle Database 10g padding random keys recommendations 2nd releases and support for DBMS_FGA package audit conditions auditing statements bind variables 2nd components creating policies EXECUTE privilege 2nd functionality procedures DBMS_FLASHBACK package DBMS_JOB package DBMS_OBFUSCATION_TOOLKIT package components differences from DBMS_CRYPTO 2nd 3rd 4th encrypting data hashing function overview releases and support for DBMS_OUTPUT package DBMS_RANDOM package functions INITIALIZE procedure NORMAL function RANDOM function 2nd SEED function STRING function 2nd 3rd 4th VALUE function 2nd 3rd DBMS_REDEFINITION package DBMS_RESOURCE_MANAGER package DBMS_RLS package ALL_ROWS constant components dropping policies EXECUTE privilege 2nd new policy types update checks DBMS_SCHEDULER package calendar strings components creating programs creating windows end dates for windows EXECUTE privilege job classes log levels supported managing attributes managing jobs overview 2nd 3rd pruning job logs windows and DBMS_SESSION package 2nd 3rd DBMS_SQL package 2nd DBMS_TRACE package DBMS_UTILITY package 2nd DBMS_XMLGEN package DDL (Data Definition Language) statements commits and DDL triggers and 2nd debugging Decision Support Systems declaration section autonomous transactions and defined example explicit cursors 2nd 3rd package body and purpose declarations cursor variables explicit cursors functions and package body and procedures and program data and records 2nd REF CURSOR types 2nd DECLARE keyword DECRYPT program 2nd decrypted_data parameter (DES3DECRYPT) decrypted_string parameter (DES3DECRYPT) decryption building tool of data 2nd 3rd 4th packages and DEFAULT keyword DEFAULT_JOB_CLASS job class 2nd definer rights model 2nd DEL column 2nd 3rd 4th DELETE procedure DELETE statement auditing and 2nd 3rd controlling table access 2nd DML triggers EXECUTE IMMEDIATE statement explicit cursors FORALL statement and functionality implicit cursors pseudo-records and RETURNING clause savepoints and syntax triggers and 2nd DELETING function delimiters as lexical units comment block 2nd label semicolons DES (Data Encryption Standard) DBMS_CRYPTO and 2nd ENCRYPT function Oracle9i Database overview DES3 (Triple DES) encryption ENCRYPT function example functionality functions for multi-pass encryption Oracle9i database DES3_CBC_PKCS5 constant DES3DECRYPT function DES3ENCRYPT function example 2nd initialization vector inputs to overview RAW datatype and Triple DES and 2nd DES3ENCRYPT procedure DES3GETKEY function 2nd 3rd DES3GETKEY procedure DES_CBC_PKCS5 constant DESENCRYPT function DESGETKEY program DETERMINISTIC clause Direct Path Export Direct Path Insert DISABLE procedure 2nd 3rd DISABLE_POLICY procedure 2nd DML statements auditing and 2nd 3rd 4th 5th controlling table access cursor attributes 2nd exception handling EXECUTE IMMEDIATE statement FORALL statement and implicit cursors listed predicates and savepoints and SYS user and table functions and DML triggers 2nd dollar sign ($) dot notation 2nd DROP TRIGGER statement DROP_JOB procedure 2nd DROP_JOB_CLASS procedure DROP_POLICY procedure DBMS_FGA package 2nd DBMS_RLS package 2nd DROP_SCHEDULE procedure DROP_WINDOW procedure 2nd DROP_WINDOW_GROUP procedure dst parameter DECRYPT program ENCRYPT program duration attribute DURATION column 2nd DURATION datatype duration parameter CREATE_WINDOW procedure forcing windows OPEN_WINDOW procedure dynamic PL/SQL 2nd dynamic policies defining example overview static versus static_policy parameter and dynamic SQL |
Категории