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 procedure: C.2.1. The REGISTER procedure, Oracle PL/SQL Programming
REGISTER procedure (DBMS_ALERT): 3.2.2.1. The DBMS_ALERT.REGISTER procedure, Oracle Built-in Packages
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
  (see also extended ROWIDs; restricted 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
register.sql
  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

Copyright © 2000 O'Reilly & Associates, Inc. All rights reserved.