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]

RAC (Real Application Clusters) 2nd 3rd 4th

RAISE statement

RAISE_APPLICATION_ERROR procedure 2nd

RAISE_EVENTS column

RANDOM function 2nd

random numbers

     checking for 2nd

     generating 2nd

random partitioning 2nd

RANDOMBYTES function 2nd

RANDOMINTEGER function

RANDOMNUMBER function

range operator (..)

range partitioning 2nd

range, controlling 2nd

RAW datatype

     converting to 2nd

     defined

     DES3GETKEY function

     encrypting 2nd

     generating keys 2nd 3rd

     HASH function

RAWTOHEX function

real numbers

records

     anchoring to cursors

     distributing

     fetching

     identifying repeating

     overview

     pseudo

     table functions and

     time limits for 2nd

REF CURSOR datatype

     bulk fetching

     cursor variables 2nd

     declaring 2nd

     defined

     loops and

     nesting and

     overview

     package specifications and

     partitioned records

     SYS_REFCURSOR weak type

referential integrity constraints 2nd

REFRESH_POLICY procedure 2nd

REMOVE_WINDOW_GROUP_MEMBER procedure

repeat_interval attribute 2nd 3rd

REPEAT_INTERVAL column 2nd 3rd 4th

repeat_interval parameter

     calendar strings

     CREATE_JOB procedure 2nd

     CREATE_SCHEDULE procedure

     CREATE_WINDOW procedure

     functionality 2nd

replication

REQ_START_DATE column 2nd

reserved words

resource allocation plan

Resource Manager feature 2nd 3rd

resource_consumer_group attribute

RESOURCE_CONSUMER_GROUP column 2nd

resource_consumer_group parameter (CREATE_JOB_CLASS)

resource_consumer_plan parameter

resource_plan attribute

RESOURCE_PLAN column 2nd

resource_plan parameter (CREATE_WINDOW)

restartable attribute

result sets

     as collections

     defined structure 2nd 3rd

retention period

RETRY_COUNT column 2nd

RETURN clause

     functions and

     loops and

     pipelined table functions

     REF CURSOR types

     strong types

     weak types

return_date_after parameter (EVALUATE_CALENDAR_STRING)

RETURNING clause

RETURNING INTO clause

RLS (row-level security)

     application contexts

     debugging

     defined

     example

     FGA and

     Oracle features and 2nd

     overview

     policies and

     usage

     VPD and

RMAN incremental backup 2nd

ROLLBACK statement

     autonomous transactions and

     COMMIT statement and

     DML triggers and

     functionality

     overview 2nd

ROLLBACK TO SAVEPOINT statement

rollbacks

     audit entries

     exceptions and

     ORA-01555 error

ROUND function 2nd

rounding errors

ROW_ID column 2nd

%ROWCOUNT attribute

     description 2nd

     explicit cursors

     WHERE clause and

ROWID datatype

rows

     changing access to

     cursor attributes

     exporting

     handler modules

     LIMIT clause

     retrieving multiple

     selective auditing

%ROWTYPE attribute

     cursor variables

     cursor-based records

     EXECUTE IMMEDIATE statement

     record anchoring

     REF CURSOR type

     result sets

     table-based records

ROWTYPE_MISMATCH exception

RUN_COUNT column 2nd 3rd

RUN_DURATION column

RUN_JOB procedure 2nd 3rd

RUNNING_INSTANCE column

runtime engine 2nd 3rd