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]

PACKAGE column

packages 2nd

PAD_NONE constant

PAD_PKCS5 constant 2nd

PAD_ZERO constant

padding 2nd

PARALLEL_ENABLE clause 2nd

parallelizing table functions

parameters

     collections as

     column-sensitive RLS and

     cursor 2nd 3rd

     encryption and 2nd 3rd

     functions and

     negative numbers and

     overview

     partitioning records and

     policy functions 2nd

     procedures and 2nd

     SELECT statements as

     table functions and

( ) parentheses

parentheses ( )

parsing

     functionality

     hard 2nd 3rd

     limiting cursor 2nd

     soft

PARTITION BY ANY parameter 2nd

PARTITION BY clause

PARTITION BY HASH parameter 2nd 3rd

PARTITION BY RANGE parameter 2nd 3rd

partitioning

passwords

     cleartext and

     flexibility in changing 2nd

     randomizers and 2nd

     wallet 2nd

patterns, statistical

percent sign (%)

performance

     bind variables

     decryption and

     dynamic policies and

     hash values and

     policy functions and

     static policies and

     table functions and

     TDE and

PF_FUNCTION column 2nd

PF_OWNER column

PF_PACKAGE column 2nd

PF_SCHEMA column 2nd

PGA (Process Global Area) 2nd 3rd

phishing, encryption and

PIPE ROW command 2nd

PIPELINED clause

PIPELINED keyword

pipelining 2nd 3rd 4th

PKCS#5 (Public Key Cryptography System #5) 2nd 3rd

PL/SQL Developer

PL/SQL programming language

     characteristics

     syntax elements

PLS_INTEGER datatype

     associative arrays and

     defined

     FORALL statement and

     typ parameter

pointers

policies

     audit records and

     connection pools

     customizing

     DBMS_FGA package

     DBMS_RLS package

     defined

     disabling

     FGA and 2nd

     filters and 2nd 3rd 4th

     ORA-28102 error

     predicates and

     setting up

policy functions

     application context

     connection pools

     controlling table access

     data dictionary view

     dynamic policies and

     exception handling

     guidelines

     performance and 2nd

     predicates and

     static policies and

POLICY_COLUMN column 2nd

POLICY_COLUMN_OPTIONS column 2nd 3rd

policy_function parameter (ADD_POLICY)

POLICY_GROUP column

POLICY_NAME column 2nd 3rd 4th

policy_name parameter

     ADD_POLICY procedure 2nd

     DISABLE_POLICY procedure

     DROP_POLICY procedure 2nd

     ENABLE_POLICY procedure 2nd

     REFRESH_POLICY procedure

POLICY_TEXT column 2nd

POLICY_TYPE column

policy_type parameter (ADD_POLICY) 2nd

positional notation 2nd

positive numbers

pound sign (#)

PQ (Parallel Query) servers 2nd 3rd

pragma

predicates

     application contexts 2nd

     controlling table access

     data dictionary view

     DML statements and

     dynamic policies and 2nd

     filtering via

     ORA-28113 error

     ORA-28138 error

     RLS example

     static policies and

     update check

PRIOR function

priorities, managing

private key encryption 2nd

privileges

     FGA and

     named schedules and

     ORA-01031 error

     proxy

procedures

     application contexts and

     autonomous transactions and

     defined

     exception handling

     job_actions and

     named blocks and

     overview

     package specifications and

     parameters and

     trusted

Process Global Area (PGA) 2nd 3rd

program data

     datatypes

     declaring

     overview 2nd

program_action attribute

PROGRAM_ACTION column

program_name attribute

PROGRAM_NAME column

program_name parameter (CREATE_JOB) 2nd

program_type attribute

PROGRAM_TYPE column

program_type parameter

programs

     defined

     managing attributes 2nd

     named 2nd

properties

     job classes and 2nd

     managing attributes

proxy privileges

PROXY_SESSIONID column 2nd

public key encryption 2nd

PURGE_LOG job 2nd

PURGE_LOG_PROG program