CD Home

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.