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]

abstract datatypes

accountability 2nd

ACTIVE column 2nd

actual parameters

ACTUAL_DURATION column

ACTUAL_START_DATE column 2nd

ADD_POLICY procedure (DBMS_FGA)

     administering FGA

     bind variables 2nd

     combinations of columns

     description

     DML statements and

     example

     handler modules

     parameters

     specifying audit columns

ADD_POLICY procedure (DBMS_RLS)

     column-sensitive RLS and 2nd 3rd

     dynamic policies

     parameters

     static policies

     update checks

ADD_WINDOW_GROUP_MEMBER procedure 2nd

ADDITIONAL_INFO column 2nd 3rd 4th

ADDRESS column

Advanced Security Option (ASO) 2nd 3rd

AES (Advanced Encryption Standard)

     overview 2nd

     support for 2nd 3rd 4th

     TDE and

     typ parameter and

AES128 encryption algorithm

AES256 encryption algorithm

AFTER LOGON trigger

AL32UTF8 character set

alerts, audit trails and

algorithms

     cryptographic hashing

     encryption 2nd

     matching

ALL_ROWS constant

ALTER ANY JOB system privilege

ALTER INDEX statement

ALTER privileges

ALTER SESSION command

ALTER SYSTEM command

ALTER TABLE command 2nd 3rd

American National Standards Institute (ANSI)

anchored declarations

anonymous blocks

     declaration section

     defined

     exception handling

     overview

     running 2nd

     scheduled processes

ANSI (American National Standards Institute)

AnyData datatype

AnyDataSet datatype

AnyType datatype

API (application programming interface) 2nd

application contexts 2nd 3rd

applications

     bind variables and

     randomizers and

     RLS and 2nd

     static policies and

arrays, collections and 2nd

AS OF clause

AS OF SCN clause

ASCII values 2nd

ASO (Advanced Security Option) 2nd 3rd

assignment operator 2nd

association operator 2nd

associative arrays

     calling

     collections as

     examples 2nd

     NDS support

     repeating records

     table functions and

asterisk (*)

asymmetric encryption 2nd

AT command 2nd

at sign (@)

attributes 2nd

AUD$ database table

AUDIT ANY system privilege

AUDIT statement

AUDIT SYSTEM system privilege

audit trails

     alerts and

     defined

     DML statements

     emails and

     FGA and

     FGA_LOG$ table 2nd 3rd 4th 5th 6th

     protecting

     SELECT statement and

     triggering 2nd 3rd

     writing

audit_column parameter (ADD_POLICY) 2nd 3rd

audit_column_opts parameter (ADD_POLICY) 2nd

audit_condition parameter (ADD_POLICY) 2nd 3rd

AUDIT_SYS_OPERATIONS parameter

AUDIT_TRAIL column 2nd 3rd

audit_trail parameter

     ADD_POLICY procedure

     bind variables 2nd

     DBA_AUDIT_POLICIES view

     enabling

     setting up

auditing

     DBMS_FGA package and

     defined

     differences in database versions

     FGA and

     Oracle techniques

     overview 2nd

     specifying audit columns

     specifying conditions

     user-defined facility

authentication 2nd

AUTHID clause

     functions and

     package body and

     package specifications and

     procedures and

auto_drop attribute

auto_drop parameter (CREATE_JOB) 2nd 3rd 4th

auto_purge procedure

AUTONOMOUS TRANSACTION clause

autonomous transactions

     audit trails and

     DML triggers and

     exception handling and

     overview 2nd

     table functions and