start page | rating of books | rating of authors | reviews | copyrights
Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
Index: R
- %ROWCOUNT attribute
- 6.9.3. The %ROWCOUNT Attribute, Oracle PL/SQL Programming
- 20.1.1.4. Getting back on track, Advanced Oracle PL/SQL Programming with Packages
%ROWTYPE attribute - 2.10.5. Anchoring to Public Variables, Advanced Oracle PL/SQL Programming with Packages
- 1.7.2. Synchronize Program and Data Structures, Oracle PL/SQL Programming
- 9.2.1. Declaring Records with the %ROWTYPE Attribute, Oracle PL/SQL Programming
- 15.6.1.1. %TYPE and %ROWTYPE, Oracle PL/SQL Programming
- in cursor declarations: (see cursors)
RAISE statement - 22.1.5. What About the Reraise Action?, Advanced Oracle PL/SQL Programming with Packages
- 8.5.1.2. Programmer raises ZERO_DIVIDE exception, Oracle PL/SQL Programming
- 8.10. RAISE Nothing but Exceptions, Oracle PL/SQL Programming
RAISE_APPLICATION_ERROR procedure - 8.3.4. Unnamed Programmer-Defined Exceptions , Oracle PL/SQL Programming
- 8.7. Client-Server Error Communication, Oracle PL/SQL Programming
RANDOM function - 10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages
- 10.4.2.3. The DBMS_RANDOM.RANDOM function (Oracle8 only) , Oracle Built-in Packages
RAW datatype - 4.2.3.4. The RAW datatype, Oracle PL/SQL Programming
- 14.2.3. The HEXTORAW function, Oracle PL/SQL Programming
RAWTOHEX function: 14.2.4. The RAWTOHEX function, Oracle PL/SQL Programming RAW_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages RDBMS
- (see also relational database management system)
- 1.3.1. Improved Application Portability with PL/SQL, Oracle PL/SQL Programming
READ COMMITTED isolation level: 2.4.2. Transaction Visibility, Guide to Oracle8i Features READ procedure
- C.6.13. The READ procedure, Oracle PL/SQL Programming
- 8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
- 8.3.2.3. The DBMS_LOB.READ procedure, Oracle Built-in Packages
- SUBSTR versus
- 8.3.2.3. The DBMS_LOB.READ procedure, Oracle Built-in Packages
- 8.3.2.4. The DBMS_LOB.SUBSTR function, Oracle Built-in Packages
READ_CLIENT_INFO procedure - 7.1.1. DBMS_APPLICATION_INFO Programs , Oracle Built-in Packages
- 7.2.1. The DBMS_APPLICATION_INFO.READ_CLIENT_INFO procedure, Oracle Built-in Packages
READ_ERROR exception: 13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages READ_EV procedure: 11.2.2.1. The DBMS_SYSTEM.READ_EV procedure, Oracle Built-in Packages READ_MODULE procedure - 7.1.1. DBMS_APPLICATION_INFO Programs , Oracle Built-in Packages
- 7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure, Oracle Built-in Packages
READ_ONLY procedure - 4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
- 4.2.5.1. The DBMS_TRANSACTION.READ_ONLY procedure, Oracle Built-in Packages
- C.15.7. The READ_ONLY procedure, Oracle PL/SQL Programming
READ_WRITE procedure - 4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
- 4.2.5.2. The DBMS_TRANSACTION.READ_WRITE procedure, Oracle Built-in Packages
- C.15.8. The READ_WRITE procedure, Oracle PL/SQL Programming
REAL subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming RECEIVE_MESSAGE function - 3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
- 3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function, Oracle Built-in Packages
- C.10.5. The RECEIVE_MESSAGE function, Oracle PL/SQL Programming
RECTIFY procedure - 15.5.1. Getting Started with DBMS_RECTIFIER_DIFF, Oracle Built-in Packages
- 15.5.2.2. The DBMS_RECTIFIER_DIFF.RECTIFY procedure, Oracle Built-in Packages
REDIRECT_URL procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications REF CURSOR type - (see also cursor variables)
- 6.12.3. Declaring REF CURSOR Types and Cursor Variables, Oracle PL/SQL Programming
- 6.12.6.3. Cursor variable aliases, Oracle PL/SQL Programming
- identifying: 6.12.7.1. Identifying the REF CURSOR type, Oracle PL/SQL Programming
REF keyword: 18.2.3. Adding Complex Data Structures, Oracle PL/SQL Programming REFRESH procedure: C.13.4. The REFRESH procedure, Oracle PL/SQL Programming REFRESH procedure (DBMS_REFRESH) - 14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages
- 14.2.5. Manually Refreshing Snapshot Groups, Oracle Built-in Packages
REFRESH procedure (DBMS_SNAPSHOT) - 14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
- 14.1.3. Refreshing Snapshots, Oracle Built-in Packages
REFRESH_ALL procedure: C.13.5. The REFRESH_ALL procedure, Oracle PL/SQL Programming REFRESH_POLICY procedure, DBMS_RLS package - 7.3.2. DBMS_RLS Programs, Guide to Oracle8i Features
- 7.3.7. REFRESH_POLICY: Refreshing a Policy, Guide to Oracle8i Features
REFRESH_SNAPSHOT_REPGROUP procedure - 14.4.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
- 14.4.5. Manually Refreshing a Snapshot Replication Group, Oracle Built-in Packages
REFs (object references) - 18.1.4.3. Inheritance , Oracle PL/SQL Programming
- 18.2.3. Adding Complex Data Structures, Oracle PL/SQL Programming
- 18.4.2.2. REFs, Oracle PL/SQL Programming
- DEREF operator and: 18.4.2.4. DEREF, Oracle PL/SQL Programming
- as collection elements: 19.2.1. Collections "In the Database", Oracle PL/SQL Programming
- as operators: 18.4.2.2. REFs, Oracle PL/SQL Programming
- as type modifiers: 18.4.2.2. REFs, Oracle PL/SQL Programming
- object views and
- 20. Object Views, Oracle PL/SQL Programming
- 20.3.3. MAKE_REF: Returning a Virtual REF, Oracle PL/SQL Programming
- 20.4.2. Using REFs with Object Views, Oracle PL/SQL Programming
REFs, native dynamic SQL: 4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features REGISTER 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.