start page | rating of books | rating of authors | reviews | copyrights

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Index: R

%ROWCOUNT attribute

6.9.3. The %ROWCOUNT Attribute, Oracle PL/SQL Programming
20.1.1.4. Getting back on track, Advanced Oracle PL/SQL Programming with Packages

%ROWTYPE attribute

2.10.5. Anchoring to Public Variables, Advanced Oracle PL/SQL Programming with Packages
1.7.2. Synchronize Program and Data Structures, Oracle PL/SQL Programming
9.2.1. Declaring Records with the %ROWTYPE Attribute, Oracle PL/SQL Programming
15.6.1.1. %TYPE and %ROWTYPE, Oracle PL/SQL Programming
in cursor declarations: (see cursors)

RAISE statement

22.1.5. What About the Reraise Action?, Advanced Oracle PL/SQL Programming with Packages
8.5.1.2. Programmer raises ZERO_DIVIDE exception, Oracle PL/SQL Programming
8.10. RAISE Nothing but Exceptions, Oracle PL/SQL Programming

RAISE_APPLICATION_ERROR procedure

8.3.4. Unnamed Programmer-Defined Exceptions , Oracle PL/SQL Programming
8.7. Client-Server Error Communication, Oracle PL/SQL Programming

RANDOM function

10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages
10.4.2.3. The DBMS_RANDOM.RANDOM function (Oracle8 only) , Oracle Built-in Packages

RAW datatype

4.2.3.4. The RAW datatype, Oracle PL/SQL Programming
14.2.3. The HEXTORAW function, Oracle PL/SQL Programming

RAWTOHEX function: 14.2.4. The RAWTOHEX function, Oracle PL/SQL Programming

RAW_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages

RDBMS

(see also relational database management system)
1.3.1. Improved Application Portability with PL/SQL, Oracle PL/SQL Programming

READ COMMITTED isolation level: 2.4.2. Transaction Visibility, Guide to Oracle8i Features

READ procedure

C.6.13. The READ procedure, Oracle PL/SQL Programming

8.1.1. DBMS_LOB Programs, Oracle Built-in Packages

8.3.2.3. The DBMS_LOB.READ procedure, Oracle Built-in Packages

SUBSTR versus

8.3.2.3. The DBMS_LOB.READ procedure, Oracle Built-in Packages
8.3.2.4. The DBMS_LOB.SUBSTR function, Oracle Built-in Packages

READ_CLIENT_INFO procedure

7.1.1. DBMS_APPLICATION_INFO Programs , Oracle Built-in Packages
7.2.1. The DBMS_APPLICATION_INFO.READ_CLIENT_INFO procedure, Oracle Built-in Packages

READ_ERROR exception: 13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages

READ_EV procedure: 11.2.2.1. The DBMS_SYSTEM.READ_EV procedure, Oracle Built-in Packages

READ_MODULE procedure

7.1.1. DBMS_APPLICATION_INFO Programs , Oracle Built-in Packages
7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure, Oracle Built-in Packages

READ_ONLY procedure

4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.5.1. The DBMS_TRANSACTION.READ_ONLY procedure, Oracle Built-in Packages
C.15.7. The READ_ONLY procedure, Oracle PL/SQL Programming

READ_WRITE procedure

4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.5.2. The DBMS_TRANSACTION.READ_WRITE procedure, Oracle Built-in Packages
C.15.8. The READ_WRITE procedure, Oracle PL/SQL Programming

REAL subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming

RECEIVE_MESSAGE function

3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function, Oracle Built-in Packages
C.10.5. The RECEIVE_MESSAGE function, Oracle PL/SQL Programming

RECTIFY procedure

15.5.1. Getting Started with DBMS_RECTIFIER_DIFF, Oracle Built-in Packages
15.5.2.2. The DBMS_RECTIFIER_DIFF.RECTIFY procedure, Oracle Built-in Packages

REDIRECT_URL procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications

REF CURSOR type

(see also cursor variables)
6.12.3. Declaring REF CURSOR Types and Cursor Variables, Oracle PL/SQL Programming
6.12.6.3. Cursor variable aliases, Oracle PL/SQL Programming
identifying: 6.12.7.1. Identifying the REF CURSOR type, Oracle PL/SQL Programming

REF keyword: 18.2.3. Adding Complex Data Structures, Oracle PL/SQL Programming

REFRESH procedure: C.13.4. The REFRESH procedure, Oracle PL/SQL Programming

REFRESH procedure (DBMS_REFRESH)

14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages
14.2.5. Manually Refreshing Snapshot Groups, Oracle Built-in Packages

REFRESH procedure (DBMS_SNAPSHOT)

14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
14.1.3. Refreshing Snapshots, Oracle Built-in Packages

REFRESH_ALL procedure: C.13.5. The REFRESH_ALL procedure, Oracle PL/SQL Programming

REFRESH_POLICY procedure, DBMS_RLS package

7.3.2. DBMS_RLS Programs, Guide to Oracle8i Features
7.3.7. REFRESH_POLICY: Refreshing a Policy, Guide to Oracle8i Features

REFRESH_SNAPSHOT_REPGROUP procedure

14.4.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
14.4.5. Manually Refreshing a Snapshot Replication Group, Oracle Built-in Packages

REFs (object references)

18.1.4.3. Inheritance , Oracle PL/SQL Programming

18.2.3. Adding Complex Data Structures, Oracle PL/SQL Programming

18.4.2.2. REFs, Oracle PL/SQL Programming

DEREF operator and: 18.4.2.4. DEREF, Oracle PL/SQL Programming

as collection elements: 19.2.1. Collections "In the Database", Oracle PL/SQL Programming

as operators: 18.4.2.2. REFs, Oracle PL/SQL Programming

as type modifiers: 18.4.2.2. REFs, Oracle PL/SQL Programming

object views and

20. Object Views, Oracle PL/SQL Programming
20.3.3. MAKE_REF: Returning a Virtual REF, Oracle PL/SQL Programming
20.4.2. Using REFs with Object Views, Oracle PL/SQL Programming

REFs, native dynamic SQL: 4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features

REGISTER_PROPAGATOR procedure

17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.6.8. The DBMS_DEFER_SYS.REGISTER_PROPAGATOR procedure (Oracle8 only), Oracle Built-in Packages

REGISTER_SNAPSHOT procedure

14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
14.1.6.1. The DBMS_SNAPSHOT.REGISTER_SNAPSHOT procedure (Oracle 8 only) , Oracle Built-in Packages

REGISTER_STATISTICS procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.6.1.1. The DBMS_REPCAT.REGISTER_STATISTICS procedure, Oracle Built-in Packages

RELEASE function

4.1.1.1. DBMS_LOCK programs, Oracle Built-in Packages
4.1.2.4. The DBMS_LOCK.RELEASE function, Oracle Built-in Packages
C.7.3. The RELEASE function, Oracle PL/SQL Programming

RELOCATE_MASTERDEF procedure

15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.5.4. The DBMS_REPCAT.RELOCATE_MASTERDEF procedure, Oracle Built-in Packages

REMOVE procedure

C.2.2. The REMOVE procedure, Oracle PL/SQL Programming
C.5.6. The REMOVE procedure, Oracle PL/SQL Programming

REMOVE procedure (DBMS_ALERT)

3.2.1.1. DBMS_ALERT programs, Oracle Built-in Packages
3.2.2.2. The DBMS_ALERT.REMOVE procedure, Oracle Built-in Packages

REMOVE procedure (DBMS_JOB)

13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
13.2.7.1. The DBMS_JOB.REMOVE procedure, Oracle Built-in Packages

REMOVE procedure, OWA_COOKIE package: 7.3.1.2. Procedures and functions, Oracle Web Applications

REMOVEALL procedure: C.2.3. The REMOVEALL procedure, Oracle PL/SQL Programming

REMOVEALL procedure (DBMS_ALERT)

3.2.1.1. DBMS_ALERT programs, Oracle Built-in Packages
3.2.2.3. The DBMS_ALERT.REMOVEALL procedure, Oracle Built-in Packages

REMOVE_MASTER_DATABASES procedure

15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.5.2. The DBMS_REPCAT.REMOVE_MASTER_DATABASES procedure, Oracle Built-in Packages

REMOVE_PIPE function

3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function, Oracle Built-in Packages
C.10.6. The REMOVE_PIPE function, Oracle PL/SQL Programming

REMOVE_SUBSCRIBER procedure

5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.3.2. The DBMS_AQADM.REMOVE_SUBSCRIBER procedure, Oracle Built-in Packages

REPAPI (Replication API): 1.3.8.2. EnterpriseSync Lite, Oracle Web Applications

REPCAT_IMPORT_CHECK procedure

15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.8.1. The DBMS_REPCAT.REPCAT_IMPORT_CHECK procedure, Oracle Built-in Packages

REPEAT UNTIL loop: 7.2.2. Emulating a REPEAT UNTIL Loop, Oracle PL/SQL Programming

REPLACE function

(see also TRANSLATE function)
4.3.3. Function Results with NULL Arguments, Oracle PL/SQL Programming
11.1.10. The REPLACE function, Oracle PL/SQL Programming
11.1.15. The TRANSLATE function, Oracle PL/SQL Programming

REPLICATION_OFF procedure: 15.6.2.1. DBMS_REPUTIL.REPLICATION_OFF procedure, Oracle Built-in Packages

REPLICATION_ON procedure: 15.6.2.2. DBMS_REPUTIL.REPLICATION_ON procedure, Oracle Built-in Packages

REQUEST function

4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages
4.1.1.1. DBMS_LOCK programs, Oracle Built-in Packages
C.7.4. The REQUEST function, Oracle PL/SQL Programming

RESET_BUFFER procedure

3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages

3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure, Oracle Built-in Packages

C.10.7. The RESET_BUFFER procedure, Oracle PL/SQL Programming

message unpacking/sending and: 3.1.7.2. Exploring DBMS_PIPE , Oracle Built-in Packages

tips about

3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure, Oracle Built-in Packages
3.1.6.5. Using RESET_BUFFER, Oracle Built-in Packages

RESET_COMPILER_OPTION procedure, DBMS_JAVA package: 9.7. Using DBMS_JAVA and DBMS_JAVA_TEST, Guide to Oracle8i Features

RESET_PACKAGE procedure

11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.4.3. The DBMS_SESSION.RESET_PACKAGE procedure, Oracle Built-in Packages
C.12.3. The RESET_PACKAGE procedure, Oracle PL/SQL Programming

RESTRICT_REFERENCES pragma

17.3. Requirements for Stored Functions in SQL, Oracle PL/SQL Programming
1.6.5.1. RESTRICT_REFERENCES pragma, Advanced Oracle PL/SQL Programming with Packages
10.2.1. RESTRICT_REFERENCES Pragma, Guide to Oracle8i Features
17.5.1. The RESTRICT_REFERENCES Pragma, Oracle PL/SQL Programming
manual application of: 17.7.1. Manual Application of Pragmas, Oracle PL/SQL Programming

RESUME_MASTER_ACTIVITY procedure

15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.7.2. The DBMS_REPCAT.RESUME_MASTER_ACTIVITY procedure, Oracle Built-in Packages

RESUME_SUBSET_OF_MASTERS procedure

15.4.1. Getting Started with DBMS_OFFLINE_OG, Oracle Built-in Packages
15.4.2.5. The DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS procedure, Oracle Built-in Packages

RETURN statement

6.1.2. Functions, Oracle Web Applications
15.5.2. The RETURN Datatype, Oracle PL/SQL Programming
6.4.4. The Cursor RETURN Clause, Oracle PL/SQL Programming
7.7.2.3. RETURN statement, Oracle PL/SQL Programming
15.5.8. The RETURN Statement, Oracle PL/SQL Programming
cursor: 6.4. Declaring Cursors, Oracle PL/SQL Programming
in procedures: 15.5.8.5. RETURN statement in a procedure, Oracle PL/SQL Programming
of package cursors: 16.3.2. Declaring Package Cursors, Oracle PL/SQL Programming
overloaded functions: 15.8.4. Restrictions on Overloading, Oracle PL/SQL Programming
using single: 22.2.2. Use a Single RETURN Statement for Successful Termination, Oracle PL/SQL Programming

RETURNING INTO clause: 5.3. Bulk Querying with the BULK COLLECT Clause, Guide to Oracle8i Features

RETURNING clause

4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features
4.4.3. Argument Modes , Guide to Oracle8i Features
dynamic SQL and: 2.5.7. Using the RETURNING Clause in Dynamic SQL, Oracle Built-in Packages
multiple-row delete: 2.5.7.2. RETURNING from a multiple-row delete, Oracle Built-in Packages
single-row insert: 2.5.7.1. RETURNING from a single-row insert, Oracle Built-in Packages

REVERSE statement

9.2.3.13. The UTL_RAW.REVERSE function, Oracle Built-in Packages
7.3.1. Rules for Numeric FOR Loops, Oracle PL/SQL Programming

REVOKE statement: 7.6.2. System-Level Access Control, Guide to Oracle8i Features

REVOKE_ADMIN_ANY_REPGROUP procedure

15.2.1.1. DBMS_REPCAT_ADMIN programs, Oracle Built-in Packages
15.2.2.4. The DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_REPGROUP procedure, Oracle Built-in Packages

REVOKE_ADMIN_ANY_REPSCHEMA procedure: 15.2.1.1. DBMS_REPCAT_ADMIN programs, Oracle Built-in Packages

REVOKE_ADMIN_REPGROUP procedure

15.2.1.1. DBMS_REPCAT_ADMIN programs, Oracle Built-in Packages
15.2.2.2. The DBMS_REPCAT_ADMIN.REVOKE_ADMIN_REPGROUP procedure, Oracle Built-in Packages

REVOKE_ADMIN_REPSCHEMA procedure: 15.2.1.1. DBMS_REPCAT_ADMIN programs, Oracle Built-in Packages

REVOKE_QUEUE_PRIVILEGE procedure: 7.6.3.2. REVOKE_QUEUE_PRIVILEGE: Revoking queue-level privileges, Guide to Oracle8i Features

REVOKE_SURROGATE_REPCAT procedure

15.1.1.1. DBMS_REPCAT_AUTH programs, Oracle Built-in Packages
15.1.2.2. The DBMS_REPCAT_AUTH.REVOKE_SURROGATE_REPCAT procedure, Oracle Built-in Packages

REVOKE_SYSTEM_PRIVILEGE procedure: 7.6.2.2. REVOKE_SYSTEM_PRIVILEGE: Revoking system-level privileges, Guide to Oracle8i Features

RNDS (reads no database state): 2.4.1. Using Autonomous Transactions from Within SQL, Guide to Oracle8i Features

RNDS purity code

1.6.5.1. RESTRICT_REFERENCES pragma, Advanced Oracle PL/SQL Programming with Packages
1.6.5.2. Asserting the purity level of the initialization section, Advanced Oracle PL/SQL Programming with Packages
17.5.1. The RESTRICT_REFERENCES Pragma, Oracle PL/SQL Programming

RNPS (reads no package state): 7.4. UTL_COLL: Using Collection Locators, Guide to Oracle8i Features

RNPS purity code

1.6.5.1. RESTRICT_REFERENCES pragma, Advanced Oracle PL/SQL Programming with Packages
17.5.1. The RESTRICT_REFERENCES Pragma, Oracle PL/SQL Programming

ROLLBACK procedure

4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.4.1. The DBMS_TRANSACTION.ROLLBACK procedure, Oracle Built-in Packages
C.15.9. The ROLLBACK procedure, Oracle PL/SQL Programming
2.5.2. Using Autonomous Transactions in a Database Trigger, Guide to Oracle8i Features
6.1.2. The ROLLBACK Statement, Oracle PL/SQL Programming
6.11.1. Releasing Locks with COMMIT, Oracle PL/SQL Programming
ROLLBACK TO statement: 6.1.2. The ROLLBACK Statement, Oracle PL/SQL Programming

ROLLBACK_FORCE procedure

4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.4.2. The DBMS_TRANSACTION.ROLLBACK_FORCE procedure, Oracle Built-in Packages
C.15.10. The ROLLBACK_FORCE procedure, Oracle PL/SQL Programming

ROLLBACK_SAVEPOINT procedure

4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.4.4. The DBMS_TRANSACTION.ROLLBACK_SAVEPOINT procedure, Oracle Built-in Packages
C.15.11. The ROLLBACK_SAVEPOINT procedure, Oracle PL/SQL Programming

ROUND function

12.1.6. The ROUND function, Oracle PL/SQL Programming
13.1.15. The ROUND function, Oracle PL/SQL Programming

ROWID datatype

(see also ROWIDs)
converting to/from: 14.2.1. The CHARTOROWID function, Oracle PL/SQL Programming
4.2.3.6. The ROWID datatype, Oracle PL/SQL Programming
4.5. Working with Objects and Collections, Guide to Oracle8i Features

ROWIDTOCHAR function

14.2.5. The ROWIDTOCHAR function, Oracle PL/SQL Programming
in Oracle7: 9.1.2. ROWID Concepts, Oracle Built-in Packages

ROWID_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages

ROWID_BLOCK_NUMBER function

9.1.3.1. The DBMS_ROWID.ROWID_BLOCK_NUMBER function, Oracle Built-in Packages
C.11.6. The ROWID_BLOCK_NUMBER function, Oracle PL/SQL Programming

ROWID_CREATE function

9.1.3.2. The DBMS_ROWID.CREATE_ROWID function, Oracle Built-in Packages
C.11.1. The ROWID_CREATE function, Oracle PL/SQL Programming

ROWID_INFO procedure

9.1.3.3. The DBMS_ROWID.ROWID_INFO procedure, Oracle Built-in Packages
C.11.2. The ROWID_INFO procedure, Oracle PL/SQL Programming

ROWID_OBJECT function

9.1.3.4. The DBMS_ROWID.ROWID_OBJECT function, Oracle Built-in Packages
C.11.4. The ROWID_OBJECT function, Oracle PL/SQL Programming

ROWID_RELATIVE_FNO function

9.1.3.5. The DBMS_ROWID.ROWID_RELATIVE_FNO function, Oracle Built-in Packages
C.11.5. The ROWID_RELATIVE_FNO function , Oracle PL/SQL Programming

ROWID_ROW_NUMBER function

9.1.3.6. The DBMS_ROWID.ROWID_ROW_NUMBER function, Oracle Built-in Packages
C.11.7. The ROWID_ROW_NUMBER function, Oracle PL/SQL Programming

ROWID_TO_ABSOLUTE_FNO function

9.1.3.7. The DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO function, Oracle Built-in Packages
C.11.8. The ROWID_TO_ABSOLUTE_FNO function, Oracle PL/SQL Programming

ROWID_TO_EXTENDED function

9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function, Oracle Built-in Packages
C.11.9. The ROWID_TO_EXTENDED function, Oracle PL/SQL Programming

ROWID_TO_RESTRICTED function

9.1.3.9. The DBMS_ROWID.ROWID_TO_RESTRICTED function, Oracle Built-in Packages
C.11.10. The ROWID_TO_RESTRICTED function, Oracle PL/SQL Programming

ROWID_TYPE function

9.1.3.10. The DBMS_ROWID.ROWID_TYPE function, Oracle Built-in Packages
C.11.3. The ROWID_TYPE function, Oracle PL/SQL Programming

ROWID_VERIFY function

9.1.3.11. The DBMS_ROWID.ROWID_VERIFY function, Oracle Built-in Packages
C.11.11. The ROWID_VERIFY function , Oracle PL/SQL Programming

ROWIDs

9. Datatype Packages, Oracle Built-in Packages

9.1.2. ROWID Concepts, Oracle Built-in Packages

DBMS_ROWID package for: C.11. DBMS_ROWID (PL/SQL8 Only), Oracle PL/SQL Programming

absolute file numbers, returning: 9.1.3.7. The DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO function, Oracle Built-in Packages

block numbers, returning: 9.1.3.1. The DBMS_ROWID.ROWID_BLOCK_NUMBER function, Oracle Built-in Packages

components of, returning: 9.1.3.3. The DBMS_ROWID.ROWID_INFO procedure, Oracle Built-in Packages

creating: 9.1.3.2. The DBMS_ROWID.CREATE_ROWID function, Oracle Built-in Packages

datatypes of

9. Datatype Packages, Oracle Built-in Packages
9.1.3.10. The DBMS_ROWID.ROWID_TYPE function, Oracle Built-in Packages

dropped files and: 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function, Oracle Built-in Packages

format: 9.1.2. ROWID Concepts, Oracle Built-in Packages

latest row fetched: 2.3.10.3. The DBMS_SQL.LAST_ROW_ID function, Oracle Built-in Packages

object numbers and: 9.1.3.4. The DBMS_ROWID.ROWID_OBJECT function, Oracle Built-in Packages

parsing: 9.1.3.3. The DBMS_ROWID.ROWID_INFO procedure, Oracle Built-in Packages

relative file numbers, returning: 9.1.3.5. The DBMS_ROWID.ROWID_RELATIVE_FNO function, Oracle Built-in Packages

returning: 9.1.3.2. The DBMS_ROWID.CREATE_ROWID function, Oracle Built-in Packages

verifying: 9.1.3.11. The DBMS_ROWID.ROWID_VERIFY function, Oracle Built-in Packages

ROWNUM: 5.3.1. Restricting Bulk Collection with ROWNUM , Guide to Oracle8i Features

ROWTYPE_MISMATCH exception: 6.12.5.2. Handling the ROWTYPE_MISMATCH exception, Oracle PL/SQL Programming

RPAD function

3.9. Considering Implementation Options, Advanced Oracle PL/SQL Programming with Packages
11.1.11. The RPAD function, Oracle PL/SQL Programming

RPCs

(see also deferred transactions)

17.1.1. About Remote Destinations, Oracle Built-in Packages

17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages

arguments

obtaining datatypes: 17.4.1.3. The DBMS_DEFER_QUERY.GET_ARG_TYPE function, Oracle Built-in Packages

obtaining datatypes and values: 17.4.1.4. The DBMS_DEFER_QUERY.GET_CALL_ARGS procedure, Oracle Built-in Packages

obtaining values: 17.4.1.5. The DBMS_DEFER_QUERY.GET_<datatype>_ARG function, Oracle Built-in Packages

calling: 17.3.2.2. The DBMS_DEFER.CALL procedure, Oracle Built-in Packages

data dictionary views for: 17.1.2. Data Dictionary Views, Oracle Built-in Packages

destinations for: 17.1.1. About Remote Destinations, Oracle Built-in Packages

parameterized RPCs: 17.3.3. Parameterized RPCs, Oracle Built-in Packages

parameterless RPCs: 17.3.2. Basic RPCs, Oracle Built-in Packages

queuing of (illustration): 17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure, Oracle Built-in Packages

replication and: 17.1.1. About Remote Destinations, Oracle Built-in Packages

RPCs (remote procedure calls): 23.4. Remote Procedure Calls, Oracle PL/SQL Programming

RR format model: 14.3.3. RR: Changing Millenia, Oracle PL/SQL Programming

RTRIM function: 11.1.12. The RTRIM function, Oracle PL/SQL Programming

RUN procedure

13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
13.2.7.3. The DBMS_JOB.RUN procedure, Oracle Built-in Packages
C.5.7. The RUN procedure, Oracle PL/SQL Programming

RealNetworks: 1.3.9.2. Multimedia data, Oracle Web Applications

Record Found? function: 16.2.7. Generating a "Record Found?" Function, Advanced Oracle PL/SQL Programming with Packages

RegExp: 7.2.2.1. Regular expressions, Oracle Web Applications

Release 1.1, PL/SQL

1.4.8. PL/SQL Release 1.1, Oracle PL/SQL Programming
10.9.4.3. Features of the array package, Oracle PL/SQL Programming

Release 2.1, PL/SQL: 1.4.4. PL/SQL Release 2.1, Oracle PL/SQL Programming

new_add_months function: 12.2.1. Customizing the Behavior of ADD_MONTHS, Oracle PL/SQL Programming
overloaded modules: 15.8.4. Restrictions on Overloading, Oracle PL/SQL Programming

Release 2.2, PL/SQL: 1.4.5. PL/SQL Release 2.2, Oracle PL/SQL Programming

cursor variables: 6.12. Cursor Variables, Oracle PL/SQL Programming

Release 2.3, PL/SQL

1.4.6. PL/SQL Release 2.3, Oracle PL/SQL Programming
10.1.1. PL/SQL Tables, Oracle PL/SQL Programming
tables: 10.8. PL/SQL Table Enhancements in PL/SQL Release 2.3, Oracle PL/SQL Programming

RevealNet

About PL/Vision, Oracle Built-in Packages
6.4.2. PL/Formatter, Oracle Web Applications

raise_exception procedure: 22.3.3.5. Responding to the exception action, Advanced Oracle PL/SQL Programming with Packages

raising exceptions

(see also exceptions)
8.4.1.2. Raising exceptions in nested blocks, Oracle PL/SQL Programming
8.5. Raising an Exception, Oracle PL/SQL Programming
8.10. RAISE Nothing but Exceptions, Oracle PL/SQL Programming

random number generation: 10.4. DBMS_RANDOM: Generating Random Numbers (Oracle8 Only), Oracle Built-in Packages

range assertion routines: 6.3.3. Asserting "In Range", Advanced Oracle PL/SQL Programming with Packages

range scheme, FOR loops: 7.3. The Numeric FOR Loop, Oracle PL/SQL Programming

raw data

(see also UTL_RAW package)

9.2. UTL_RAW: Manipulating Raw Data, Oracle Built-in Packages

9.2.3.1. The UTL_RAW.BIT_AND function, Oracle Built-in Packages

VARCHAR2 conversions

9.2.3.6. The UTL_RAW.CAST_TO_VARCHAR2 function, Oracle Built-in Packages
9.2.2.1. Conversion and coercion, Oracle Built-in Packages
9.2.3.5. The UTL_RAW.CAST_TO_RAW function, Oracle Built-in Packages

byte string operations: 9.2.2.2. Slicing and dicing, Oracle Built-in Packages

character set conversions: 9.2.3.9. The UTL_RAW.CONVERT function, Oracle Built-in Packages

comparing: 9.2.3.7. The UTL_RAW.COMPARE function, Oracle Built-in Packages

concatenating

9.2.3.10. The UTL_RAW.COPIES function, Oracle Built-in Packages
9.2.3.8. The UTL_RAW.CONCAT function, Oracle Built-in Packages

concepts: 9.2.2. Raw Data Manipulation Concepts, Oracle Built-in Packages

copying: 9.2.3.10. The UTL_RAW.COPIES function, Oracle Built-in Packages

date conversions: 9.2.2.1. Conversion and coercion, Oracle Built-in Packages

hex conversions: 9.2.2.1. Conversion and coercion, Oracle Built-in Packages

length of: 9.2.3.11. The UTL_RAW.LENGTH function, Oracle Built-in Packages

numeric conversions: 9.2.2.1. Conversion and coercion, Oracle Built-in Packages

overlaying: 9.2.3.12. The UTL_RAW.OVERLAY function, Oracle Built-in Packages

range of values: 9.2.3.17. The UTL_RAW.XRANGE function, Oracle Built-in Packages

reversing: 9.2.3.13. The UTL_RAW.REVERSE function, Oracle Built-in Packages

substring of: 9.2.3.14. The UTL_RAW.SUBSTR function, Oracle Built-in Packages

translation of byte strings: 9.2.3.15. The UTL_RAW.TRANSLATE function, Oracle Built-in Packages

transliteration: 9.2.3.16. The UTL_RAW.TRANSLITERATE function, Oracle Built-in Packages

rb function: 5.10.5. Rolling back on exception, Advanced Oracle PL/SQL Programming with Packages

rb_to procedure

5.17.7. Rolling back in PLVlog, Advanced Oracle PL/SQL Programming with Packages
21.1.5.4. Setting the default "rollback to" behavior, Advanced Oracle PL/SQL Programming with Packages

rb_to_default procedure

5.17.7. Rolling back in PLVlog, Advanced Oracle PL/SQL Programming with Packages
21.1.5.4. Setting the default "rollback to" behavior, Advanced Oracle PL/SQL Programming with Packages

rb_to_last procedure

5.17.7. Rolling back in PLVlog, Advanced Oracle PL/SQL Programming with Packages
5.23.3. Performing rollbacks, Advanced Oracle PL/SQL Programming with Packages
20.2.4. Performing Rollbacks, Advanced Oracle PL/SQL Programming with Packages
21.1.5.4. Setting the default "rollback to" behavior, Advanced Oracle PL/SQL Programming with Packages

rbdef procedure

5.10.5. Rolling back on exception, Advanced Oracle PL/SQL Programming with Packages
22.1.8. Rolling Back When an Exception Occurs, Advanced Oracle PL/SQL Programming with Packages

rblast procedure

5.10.5. Rolling back on exception, Advanced Oracle PL/SQL Programming with Packages
22.1.8. Rolling Back When an Exception Occurs, Advanced Oracle PL/SQL Programming with Packages

read consistency, stored functions and: 17.7.2. Read Consistency Model Complications, Oracle PL/SQL Programming

read-committed isolation level: 6.1.4. The SET TRANSACTION Statement, Oracle PL/SQL Programming

read-only parameters: (see IN mode)

read-only transactions: 6.1.4. The SET TRANSACTION Statement, Oracle PL/SQL Programming

readability of code: 15.7.3. Improving Readability, Oracle PL/SQL Programming

readability, local modules for: 1.7.1. Write as Little Code as Possible, Oracle PL/SQL Programming

readev.sql : 11.2.2.1. The DBMS_SYSTEM.READ_EV procedure, Oracle Built-in Packages

reading

from files

5.11.9. Reading from a file, Advanced Oracle PL/SQL Programming with Packages
13.5. Reading From a File, Advanced Oracle PL/SQL Programming with Packages

from source repository

5.15.7. Reading and writing lines, Advanced Oracle PL/SQL Programming with Packages
12. PLVio: Reading and Writing PL/SQL Source Code, Advanced Oracle PL/SQL Programming with Packages
12.6. Reading From the Source, Advanced Oracle PL/SQL Programming with Packages

log files: 5.17.5. Reading the log , Advanced Oracle PL/SQL Programming with Packages

reads no database state (RNDS) purity level: 2.4.1. Using Autonomous Transactions from Within SQL, Guide to Oracle8i Features

reads no package state (RNPS) purity level: 7.4. UTL_COLL: Using Collection Locators, Guide to Oracle8i Features

real-time production support: 26.2.1. Features of a Real-Time Support Mechanism, Oracle PL/SQL Programming

recNgo procedure

5.10.6. Exception handlers, Advanced Oracle PL/SQL Programming with Packages
22.1.6.2. The high-level handlers, Advanced Oracle PL/SQL Programming with Packages
22.3.4.2. Implementing the high-level handlers, Advanced Oracle PL/SQL Programming with Packages

recNstop procedure

5.10.6. Exception handlers, Advanced Oracle PL/SQL Programming with Packages
22.1.6.2. The high-level handlers, Advanced Oracle PL/SQL Programming with Packages
22.1.9. Halting in PLVexc, Advanced Oracle PL/SQL Programming with Packages

receive_unpack_friend procedure

3.1.4.4. The DBMS_PIPE.UNPACK_MESSAGE procedure, Oracle Built-in Packages
3.1.6.1. Defining message types and encapsulating communications logic, Oracle Built-in Packages

receive_unpack_request procedure

3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function, Oracle Built-in Packages
3.1.7.5. The pipesvr package, Oracle Built-in Packages

recfnd procedure

5.13.10. Miscellaneous code generators, Advanced Oracle PL/SQL Programming with Packages
16.2.7. Generating a "Record Found?" Function, Advanced Oracle PL/SQL Programming with Packages

recipient lists: 5.1.5. A Glossary of Terms, Oracle Built-in Packages

overriding subscriber lists: 5.1.5. A Glossary of Terms, Oracle Built-in Packages
table types for: 5.3.5. Recipient and Subscriber List Table Types, Oracle Built-in Packages
tables for: 5.3.6. Message Properties Record Type, Oracle Built-in Packages

recipients: (see consumers)

recmpile.sp : 10.3.2.1. The DBMS_DDL.ALTER_COMPILE procedure, Oracle Built-in Packages

recompile procedure: 10.3.2.1. The DBMS_DDL.ALTER_COMPILE procedure, Oracle Built-in Packages

recompiling packages: 2.4. Organizing Package Source Code, Advanced Oracle PL/SQL Programming with Packages

record locking: 7.3.2. OWA_OPT_LOCK: Record Locking, Oracle Web Applications

record, EXECUTE IMMEDIATE statement: 4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features

record_exception procedure: 22.3.4.1. Leveraging PLVLog , Advanced Oracle PL/SQL Programming with Packages

recording: (see logging)

recording_exception function: 22.3.3.3. Recording the exception, Advanced Oracle PL/SQL Programming with Packages

records

(see also variables)

1.4.3.3. Programmer-defined records, Oracle PL/SQL Programming

1.7.1. Write as Little Code as Possible, Oracle PL/SQL Programming

4. Variables and Program Data, Oracle PL/SQL Programming

9. Records in PL/SQL, Oracle PL/SQL Programming

accessing data from: 9.1.2. Accessing Record-Based Data, Oracle PL/SQL Programming

as parameters: 9.1.4. Guidelines for Using Records, Oracle PL/SQL Programming

child: 8.3.3.1. The EXCEPTION_INIT pragma, Oracle PL/SQL Programming

collections as components of: 19.2.2.2. Collections as components of a record, Oracle PL/SQL Programming

comparing: 9.1.6. Comparing Two Records, Oracle PL/SQL Programming

compatibility of: 9.6. Record Types and Record Compatibility, Oracle PL/SQL Programming

corresponding to cursors: 9.1.4. Guidelines for Using Records, Oracle PL/SQL Programming

cursor FOR loops: 7.4.2. The Cursor FOR Loop Record, Oracle PL/SQL Programming

cursor-based

(see also cursors)
9.3. Cursor-Based Records, Oracle PL/SQL Programming

declaring

9.2.1. Declaring Records with the %ROWTYPE Attribute, Oracle PL/SQL Programming
9.4.2. Declaring the Record, Oracle PL/SQL Programming

deleting

10.7. Clearing the PL/SQL Table, Oracle PL/SQL Programming
10.8.2.2. The DELETE procedure, Oracle PL/SQL Programming

fetching into: (see FETCH statement)

filling: 10.6. Filling the Rows of a PL/SQL Table, Oracle PL/SQL Programming

in tables: 10.8. PL/SQL Table Enhancements in PL/SQL Release 2.3, Oracle PL/SQL Programming

referencing fields of: 10.8.1.1. Referencing fields of record elements in PL/SQL tables, Oracle PL/SQL Programming

index-by tables of: 25.4.8. Use Index-By Tables of Records and Objects, Oracle PL/SQL Programming

initializing: 9.6.2. Record Initialization, Oracle PL/SQL Programming

locking: 6.11. SELECT FOR UPDATE in Cursors, Oracle PL/SQL Programming

manual: 9.6.1.1. Manual records, Oracle PL/SQL Programming

naming columns of: 9.3.2. Setting the Record's Column Names, Oracle PL/SQL Programming

nested: 9.7. Nested Records, Oracle PL/SQL Programming

programmer-defined: 9.4. Programmer-Defined Records, Oracle PL/SQL Programming

referencing: 9.1.5. Referencing a Record and its Fields, Oracle PL/SQL Programming

setting to NULL: 9.6.1.3. Setting records to NULL, Oracle PL/SQL Programming

table-based: 9.2. Table-Based Records, Oracle PL/SQL Programming

recovery

automatic: 4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure, Oracle Built-in Packages
raw data and: 9.2. UTL_RAW: Manipulating Raw Data, Oracle Built-in Packages

recursion

3.10. Choosing the Best Performer, Advanced Oracle PL/SQL Programming with Packages
mutual: (see forward declarations)

recursive object types: 18.3.5.1. Forward type definitions, Oracle PL/SQL Programming

recursive processing: 17.8.7. Recursive Processing in a SQL Statement, Oracle PL/SQL Programming

redirection: 1.6.4. Working with Large Packages, Advanced Oracle PL/SQL Programming with Packages

redundancy

1.6.1.1. Clean up a bewildering mass of standalone functions and procedures, Advanced Oracle PL/SQL Programming with Packages
1.6.4. Working with Large Packages, Advanced Oracle PL/SQL Programming with Packages
2.11. Simultaneous Construction of Multiple Packages, Advanced Oracle PL/SQL Programming with Packages
3.1. The Basic Problem, Advanced Oracle PL/SQL Programming with Packages
15.4.2.11. Consolidating redundant code, Advanced Oracle PL/SQL Programming with Packages
avoiding in package bodies: 1.7.3. Center All Development Around Packages, Oracle PL/SQL Programming
local modules for: 1.7.1. Write as Little Code as Possible, Oracle PL/SQL Programming
naming: 2.3.2. Avoiding Redundancy, Advanced Oracle PL/SQL Programming with Packages

refall procedure: 18.2.4. Identifying References and Dependencies, Advanced Oracle PL/SQL Programming with Packages

refbi procedure

5.5.2. Identifying references in stored code, Advanced Oracle PL/SQL Programming with Packages
18.2.4. Identifying References and Dependencies, Advanced Oracle PL/SQL Programming with Packages

reference pointers: (see REFs)

referenceability, altering: 10.3.4. Setting Referenceability of Tables, Oracle Built-in Packages

references: (see documentation)

PLVrfrnc table: 18.2.2.2. PLVrfrnc table, Advanced Oracle PL/SQL Programming with Packages
RESTRICT_REFERENCES pragma: 1.6.5.1. RESTRICT_REFERENCES pragma, Advanced Oracle PL/SQL Programming with Packages
identifying: 5.5.2. Identifying references in stored code, Advanced Oracle PL/SQL Programming with Packages
identifying with PLVcat: 18.2.4. Identifying References and Dependencies, Advanced Oracle PL/SQL Programming with Packages
of package elements: 1.4.2. Referencing Package Elements, Advanced Oracle PL/SQL Programming with Packages
to host variables: 25.4.3.2. Minimize references to host variables, Oracle PL/SQL Programming

references to objects: (see REFs)

referencing

record fields in tables: 10.8.1.1. Referencing fields of record elements in PL/SQL tables, Oracle PL/SQL Programming
table rows: 10.5. Referencing and Modifying PL/SQL Table Rows, Oracle PL/SQL Programming

refnonkw procedure

5.5.2. Identifying references in stored code, Advanced Oracle PL/SQL Programming with Packages
18.2.4. Identifying References and Dependencies, Advanced Oracle PL/SQL Programming with Packages

refresh options: 1.3.8.2. EnterpriseSync Lite, Oracle Web Applications

7.3.1. About the register_app Package, Oracle Built-in Packages
7.3.2. The action Procedure, Oracle Built-in Packages
7.3.4. The Information Procedures, Oracle Built-in Packages

register_app package

(see also specific program names)
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
7.3.1. About the register_app Package, Oracle Built-in Packages
batch process step registration: 7.3.5. Using the register_app Package, Oracle Built-in Packages
encapsulating DBMS_APPLICATION_INFO with: 7.3.6. Covering DBMS_APPLICATION_INFO, Oracle Built-in Packages

regtest.sql : 7.3.5. Using the register_app Package, Oracle Built-in Packages

regular expressions: 7.2.2.1. Regular expressions, Oracle Web Applications

relational (=) operators: 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming

relational database management systems (RDBMSs)

1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL), Guide to Oracle8i Features

relative file numbers, returning: 9.1.3.5. The DBMS_ROWID.ROWID_RELATIVE_FNO function, Oracle Built-in Packages

releasing record locks: 6.11.1. Releasing Locks with COMMIT, Oracle PL/SQL Programming

reload_TF function: 12.1.3.1. The segspace package, Oracle Built-in Packages

rem_line_limit procedure

5.15.5. Managing the source WHERE clause, Advanced Oracle PL/SQL Programming with Packages
12.4.4. Cleaning Up the WHERE Clause, Advanced Oracle PL/SQL Programming with Packages

rem_srcwhere procedure

5.15.5. Managing the source WHERE clause, Advanced Oracle PL/SQL Programming with Packages
12.4.4. Cleaning Up the WHERE Clause, Advanced Oracle PL/SQL Programming with Packages

remainder function: 13.1.13. The MOD function, Oracle PL/SQL Programming

remote databases

(see also distributed databases)
4.2.2. Advising Oracle About In-Doubt Transactions, Oracle Built-in Packages
propagating messages to: 5.1.4. Propagation Features, Oracle Built-in Packages

remote dependency

1.4.6.4. Improved remote dependency model, Oracle PL/SQL Programming
1.4.7.5. External procedures, Oracle PL/SQL Programming

remote destinations

(see also RPCs)
17.1.1. About Remote Destinations, Oracle Built-in Packages
adding default destinations: 17.2.2.1. The DBMS_DEFER.SYS.ADD_DEFAULT_DEST procedure, Oracle Built-in Packages
data dictionary view for: 17.1.1. About Remote Destinations, Oracle Built-in Packages
deleting default destinations: 17.2.2.2. The DBMS_DEFER.SYS.DELETE_DEFAULT_DEST procedure, Oracle Built-in Packages
specifying: 17.3.2.1. The DBMS_DEFER.TRANSACTION procedure, Oracle Built-in Packages

remote procedure calls

(see also RPCs)
7.2.3. Controlling Trace File Contents, Guide to Oracle8i Features
B.2.3. No Direct Remote Procedure Calls, Oracle PL/SQL Programming

remote procedures

22.7.5. Default Values and Remote Procedure Calls, Oracle PL/SQL Programming
23.4. Remote Procedure Calls, Oracle PL/SQL Programming

remove_all_jobs procedure

1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
13.3.3. DBMS_IJOB: Managing Other Users' Jobs , Oracle Built-in Packages

removing: (see deleting)

repcatlog queue: 15.3.6. Maintaining the Repcatlog Queue with DBMS_REPCAT, Oracle Built-in Packages

processing entries: 15.3.6.1. The DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN procedure, Oracle Built-in Packages
removing entries: 15.3.6.3. The DBMS_REPCAT.PURGE_MASTER_LOG procedure, Oracle Built-in Packages
waiting for completion: 15.3.6.2. The DBMS_REPCAT.WAIT_MASTER_LOG procedure, Oracle Built-in Packages

repeatable reads: 4.2.5.1. The DBMS_TRANSACTION.READ_ONLY procedure, Oracle Built-in Packages

repeats function: 5.27.2. Setting the repetition value, Advanced Oracle PL/SQL Programming with Packages

repetitive code (see redundancy)

repgroup.sql : 15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure, Oracle Built-in Packages

replaceitem procedure: 5.18.3. Modifying list contents , Advanced Oracle PL/SQL Programming with Packages

replacing characters in strings: 11.1.15. The TRANSLATE function, Oracle PL/SQL Programming

replicated objects

(see also master sites; replication groups)
15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure, Oracle Built-in Packages
altering: 15.3.3.5. The DBMS_REPCAT.ALTER_MASTER_REPOBJECT procedure, Oracle Built-in Packages
comments, adding or changing: 15.3.3.6. The DBMS_REPCAT.COMMENT_ON_REPOBJECT procedure, Oracle Built-in Packages
dropping: 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure, Oracle Built-in Packages
packages: 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages
procedures: 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages
support generation, priority group creation and: 16.3.2.1. The DBMS_REPCAT.DEFINE_PRIORITY_GROUP procedure, Oracle Built-in Packages
tables: (see tables, replicated tables)
triggers: (see replication triggers)

replication

(see also advanced replication)
13. Job Scheduling in the Database, Oracle Built-in Packages
RPCs and: 17.1.1. About Remote Destinations, Oracle Built-in Packages
job queue and: 13. Job Scheduling in the Database, Oracle Built-in Packages
propagating DML: 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function, Oracle Built-in Packages
raw data and: 9.2. UTL_RAW: Manipulating Raw Data, Oracle Built-in Packages

replication groups

(see also master sites; replicated objects)

15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure, Oracle Built-in Packages

BEFORE ROW triggers and: 15.3.4. Replication Support with DBMS_REPCAT, Oracle Built-in Packages

comments, adding or changing: 15.3.2.3. The DBMS_REPCAT.COMMENT_ON_REPGROUP procedure, Oracle Built-in Packages

creating:

15.3.3.1. The DBMS_REPCAT.CREATE_MASTER_REPOBJECT procedure, Oracle Built-in Packages
15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure, Oracle Built-in Packages

creating objects: 15.3.3.1. The DBMS_REPCAT.CREATE_MASTER_REPOBJECT procedure, Oracle Built-in Packages

dropping: 15.3.2.2. The DBMS_REPCAT.DROP_MASTER_REPGROUP procedure, Oracle Built-in Packages

executing DDL: 15.3.3.4. The DBMS_REPCAT.EXECUTE_DDL procedure, Oracle Built-in Packages

propagation modes

altering for current session: 15.6. DBMS_REPUTIL: Enabling and Disabling Replication, Oracle Built-in Packages

altering for individual columns: 15.3.8.3. The DBMS_REPCAT.SEND_AND_COMPARE_OLD_VALUES procedure (Oracle8 only), Oracle Built-in Packages

altering for replication group: 15.3.8.2. The DBMS_REPCAT.ALTER_MASTER_PROPAGATION procedure, Oracle Built-in Packages

pseudo-primary keys, designating: 15.3.3.2. The DBMS_REPCAT.SET_COLUMNS procedure, Oracle Built-in Packages

quiescing: 15.3.7.1. The DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY procedure, Oracle Built-in Packages

replication schema groups versus: 15.3.2. Replication Groups with DBMS_REPCAT, Oracle Built-in Packages

resuming activity: 15.3.7.2. The DBMS_REPCAT.RESUME_MASTER_ACTIVITY procedure, Oracle Built-in Packages

resynchronizing object identifiers: 15.3.8.1. The DBMS_REPCAT.REPCAT_IMPORT_CHECK procedure, Oracle Built-in Packages

replication modes, ESL: 1.3.8.2. EnterpriseSync Lite, Oracle Web Applications

replication packages

(see also replication support packages)
15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages
generating: 15.3.4.2. The DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE procedure, Oracle Built-in Packages

replication queue: (see repcatlog queue)

replication support packages

(see also replication packages)
15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages
15.3.4.2. The DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE procedure, Oracle Built-in Packages
generating: 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages

replication triggers: 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function, Oracle Built-in Packages

conflict resolution and: 14.1.2.2. The DBMS_SNAPSHOT.SET_I_AM_A_REFRESH procedure, Oracle Built-in Packages

deferred transactions and: 17. Deferred Transactions and Remote Procedure Calls, Oracle Built-in Packages

dropping replicated objects and: 14.4.3.2. The DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT procedure, Oracle Built-in Packages

dropping replicated tables and: 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure, Oracle Built-in Packages

generating

15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages
15.3.4.3. The DBMS_REPCAT.GENERATE_REPLICATION_TRIGGER procedure, Oracle Built-in Packages

propagation mode alteration and: 15.3.8.2. The DBMS_REPCAT.ALTER_MASTER_PROPAGATION procedure, Oracle Built-in Packages

repobjs.sql : 15.3.3.1. The DBMS_REPCAT.CREATE_MASTER_REPOBJECT procedure, Oracle Built-in Packages

report wizard, WebDB: 3.1.2.2. Building user interface components , Oracle Web Applications

reports

DBMS_OUTPUT used for: 6.1. DBMS_OUTPUT: Displaying Output, Oracle Built-in Packages
Method 4 dynamic SQL used for: 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL, Oracle Built-in Packages

repos_rectype TYPE: 12.2.2. Database Source or Target, Advanced Oracle PL/SQL Programming with Packages

repository, code: (see PLVio package)

repsites.sql : 15.3.5.1. The DBMS_REPCAT.ADD_MASTER_DATABASE procedure, Oracle Built-in Packages

reraise procedure: 22.1.5. What About the Reraise Action?, Advanced Oracle PL/SQL Programming with Packages

reserved words

2.2. Using Effective Coding Style for Packages, Advanced Oracle PL/SQL Programming with Packages
5.26. PLVtkn: Token Table Interface, Advanced Oracle PL/SQL Programming with Packages
10.2. PLVtkn: Managing PL/SQL Tokens, Advanced Oracle PL/SQL Programming with Packages
2.2.1. Reserved Words, Oracle PL/SQL Programming
3.1.2. Using Case to Aid Readability, Oracle PL/SQL Programming
determining types of: 10.2.2. Determining Token Type, Advanced Oracle PL/SQL Programming with Packages
displaying code by: 15.3.2. Displaying Code by Keyword, Advanced Oracle PL/SQL Programming with Packages
initializing table of: 10.3.3. Initializing a Table of Tokens, Advanced Oracle PL/SQL Programming with Packages

reset procedure

11.1.5.1. Adding value to DBMS_SESSION, Oracle Built-in Packages
11.1.5.7. The reset procedure , Oracle Built-in Packages

reset_savepoints procedure: 5.23.4. Managing savepoints , Advanced Oracle PL/SQL Programming with Packages

resource accounting: (see performance analysis)

resource management: 11.1.4. Managing Session Resources, Oracle Built-in Packages

server resources: 12. Managing Server Resources, Oracle Built-in Packages

resource name, URL: 2.2.5. The Uniform Resource Locator, Oracle Web Applications

resources, web: 2.1. Resources, Oracle Web Applications

rest_of_line function: 5.15.7. Reading and writing lines, Advanced Oracle PL/SQL Programming with Packages

restoresrc procedure: 5.15.8. Saving and restoring repository settings, Advanced Oracle PL/SQL Programming with Packages

restoretrg procedure: 5.15.8. Saving and restoring repository settings, Advanced Oracle PL/SQL Programming with Packages

restoring

PL/SQL objects: 11.3.4. Saving and Restoring the Current Object, Advanced Oracle PL/SQL Programming with Packages

repository settings

12.8. Saving and Restoring Settings, Advanced Oracle PL/SQL Programming with Packages
5.15.8. Saving and restoring repository settings, Advanced Oracle PL/SQL Programming with Packages

restrict procedure: 9.4. The Restriction Toggle, Advanced Oracle PL/SQL Programming with Packages

restricted ROWIDs

Oracle versions and: 9. Datatype Packages, Oracle Built-in Packages
converting from extended ROWIDs: 9.1.3.9. The DBMS_ROWID.ROWID_TO_RESTRICTED function, Oracle Built-in Packages
creating extended ROWIDs from: 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function, Oracle Built-in Packages
format: 9.1.2. ROWID Concepts, Oracle Built-in Packages

restricting function: 9.4. The Restriction Toggle, Advanced Oracle PL/SQL Programming with Packages

restricting use of text: 5.19.1. Restricting use of text, Advanced Oracle PL/SQL Programming with Packages

result sets: 6.2.5. Cursors, Oracle Web Applications

retry counters

1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!), Guide to Oracle8i Features
2.3. When to Use Autonomous Transactions, Guide to Oracle8i Features

reusable application components

1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!), Guide to Oracle8i Features
2.3. When to Use Autonomous Transactions, Guide to Oracle8i Features

reusing code: 1.7.1. Write as Little Code as Possible, Oracle PL/SQL Programming

reusing dynamic SQL cursors: 4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features

rights models: 18.3.7.3. Rights model, Oracle PL/SQL Programming

roles

(see also privileges)

2.4.2. Privileges and Execution Authority with DBMS_SQL, Oracle Built-in Packages

1.3.2. Invoker Rights (Chapter 3, Invoker Rights: Your Schema or Mine? ), Guide to Oracle8i Features

advanced queuing and

5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages
5.4. DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only), Oracle Built-in Packages
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages

job execution and: 13.2.2. Job Execution and the Job Execution Environment, Oracle Built-in Packages

session roles

enabling/disabling: 11.1.2.4. The DBMS_SESSION.SET_ROLE procedure, Oracle Built-in Packages

testing if enabled: 11.1.3.1. The DBMS_SESSION.IS_ROLE_ENABLED function, Oracle Built-in Packages

roles, database

2.5.4. Roles, Oracle Web Applications
3.1.1.2. Administer WebDB and database security, Oracle Web Applications

rollback: 4.2.4. Rolling Back Changes, Oracle Built-in Packages

alerts and: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure, Oracle Built-in Packages
behavior: 21.1.5.4. Setting the default "rollback to" behavior, Advanced Oracle PL/SQL Programming with Packages
lock persistence and: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages
message processing and: 5.1.3. Dequeue Features, Oracle Built-in Packages
snapshot refreshing and: 14.1.3.1. The DBMS_SNAPSHOT.REFRESH procedure, Oracle Built-in Packages

rollback_to procedure

5.23.3. Performing rollbacks, Advanced Oracle PL/SQL Programming with Packages
20.2.4. Performing Rollbacks, Advanced Oracle PL/SQL Programming with Packages

rollbackd

in PLVlog package: 5.17.7. Rolling back in PLVlog, Advanced Oracle PL/SQL Programming with Packages

rollbacks

5.23. PLVrb: Rollback Processing, Advanced Oracle PL/SQL Programming with Packages
20.2. PLVrb: Performing Rollbacks, Advanced Oracle PL/SQL Programming with Packages
1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!), Guide to Oracle8i Features
2.3. When to Use Autonomous Transactions, Guide to Oracle8i Features
PLVlog package and: 21.1.5. Rolling Back with PLVlog, Advanced Oracle PL/SQL Programming with Packages
on errors: 22.1.8. Rolling Back When an Exception Occurs, Advanced Oracle PL/SQL Programming with Packages

rolling_back function

5.17.7. Rolling back in PLVlog, Advanced Oracle PL/SQL Programming with Packages
5.23.1. Controlling rollback activity, Advanced Oracle PL/SQL Programming with Packages
21.1.5.1. Toggling rollback activity, Advanced Oracle PL/SQL Programming with Packages

root privileges, and ports: 2.2.2. The Communication Port, Oracle Web Applications

rounding dates: 12.1.6. The ROUND function, Oracle PL/SQL Programming

row numbers

converting expressions to: 10.5.1. Automatic Conversion of Row Number Expressions, Oracle PL/SQL Programming
returning: 9.1.3.6. The DBMS_ROWID.ROWID_ROW_NUMBER function, Oracle Built-in Packages

row-by-row fetching: 5.5. Analyzing the Impact of Bulk Operations, Guide to Oracle8i Features

row-level security (RLS)

1.3.7. Fine-Grained Access Control (Chapter 8, Deploying Fine-Grained Access Control), Guide to Oracle8i Features
7.3.2. DBMS_RLS Programs, Guide to Oracle8i Features

rowbyhash function: 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function, Oracle Built-in Packages

rowbyscan function: 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function, Oracle Built-in Packages

rows

deleting arrays

2.5.6.2. Using array processing to delete, Oracle Built-in Packages
2.5.7.2. RETURNING from a multiple-row delete, Oracle Built-in Packages

deleting objects in: 9.2.5.1. The UTL_REF.DELETE_OBJECT procedure, Oracle Built-in Packages

fetching

2.3.1. Processing Flow of Dynamic SQL, Oracle Built-in Packages

2.3.7. Fetching Rows, Oracle Built-in Packages

2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure, Oracle Built-in Packages

example: 2.5.4.6. Retrieving and displaying data, Oracle Built-in Packages

immediate fetching: 2.3.7.2. The DBMS_SQL.EXECUTE_AND_FETCH function, Oracle Built-in Packages

past last record

2.3.7.1. The DBMS_SQL.FETCH_ROWS function, Oracle Built-in Packages
2.3.7.2. The DBMS_SQL.EXECUTE_AND_FETCH function, Oracle Built-in Packages

fetching arrays

2.3.7.1. The DBMS_SQL.FETCH_ROWS function, Oracle Built-in Packages
2.3.7.2. The DBMS_SQL.EXECUTE_AND_FETCH function, Oracle Built-in Packages
2.5.6.4. Using array processing to fetch, Oracle Built-in Packages

inserting arrays: 2.5.6.1. Using array processing to insert, Oracle Built-in Packages

rowid of latest row fetched: 2.3.10.3. The DBMS_SQL.LAST_ROW_ID function, Oracle Built-in Packages

rows fetched count: 2.3.10.2. The DBMS_SQL.LAST_ROW_COUNT function, Oracle Built-in Packages

table

(see also records; tables)
9.1.1. Different Types of Records, Oracle PL/SQL Programming
data-smart numbers for: 10.9.2. Data-Smart Row Numbers in PL/SQL Tables, Oracle PL/SQL Programming
negative index: 10.2. Characteristics of PL/SQL Tables, Oracle PL/SQL Programming
objects for: 18.1.2. Some Simple Examples, Oracle PL/SQL Programming
referencing and modifying: 10.5. Referencing and Modifying PL/SQL Table Rows, Oracle PL/SQL Programming

updating arrays: 2.5.6.3. Using array processing to update, Oracle Built-in Packages

rows procedure: 2.5.6.4. Using array processing to fetch, Oracle Built-in Packages

rule-based subscribers: 7.6.4. Improved Publish/Subscribe Support, Guide to Oracle8i Features

rules

FORALL statement: 5.2. Bulk DML with the FORALL Statement, Guide to Oracle8i Features
Java wrappers: 9.8.2. Some Rules for Java Wrappers, Guide to Oracle8i Features
triggers: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features

run authority (see execute authority)

runddl engine: 1.3.2. Invoker Rights, Guide to Oracle8i Features

runddl.sp : 2.4.2.2. The tale of Scott , Oracle Built-in Packages

runprog.sp : 2.3.8.3. The DBMS_SQL.VARIABLE_VALUE procedure, Oracle Built-in Packages

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z