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
Index: R
- RANDOM function
- random number generation
: 10.4. DBMS_RANDOM: Generating Random Numbers (Oracle8 Only)
- raw data
- (see also UTIL_RAW package)
- 9.2. UTL_RAW: Manipulating Raw Data
- 9.2.3.1. The UTL_RAW.BIT_AND function
- byte string operations : 9.2.2.2. Slicing and dicing
- character set conversions : 9.2.3.9. The UTL_RAW.CONVERT function
- comparing : 9.2.3.7. The UTL_RAW.COMPARE function
- concatenating
- 9.2. UTL_RAW: Manipulating Raw Data
- concepts
: 9.2.2. Raw Data Manipulation Concepts
- copying : 9.2.3.10. The UTL_RAW.COPIES function
- date conversions : 9.2.2.1. Conversion and coercion
- hex conversions : 9.2.2.1. Conversion and coercion
- length of : 9.2.3.11. The UTL_RAW.LENGTH function
- numeric conversions : 9.2.2.1. Conversion and coercion
- overlaying : 9.2.3.12. The UTL_RAW.OVERLAY function
- range of values : 9.2.3.17. The UTL_RAW.XRANGE function
- reversing : 9.2.3.13. The UTL_RAW.REVERSE function
- substring of : 9.2.3.14. The UTL_RAW.SUBSTR function
- translation of byte strings : 9.2.3.15. The UTL_RAW.TRANSLATE function
- transliteration : 9.2.3.16. The UTL_RAW.TRANSLITERATE function
- VARCHAR2 conversions : 9.2.3.6. The UTL_RAW.CAST_TO_VARCHAR2 function
- VARCHAR2 conversions
- copying : 9.2.3.10. The UTL_RAW.COPIES function
- (see also UTIL_RAW package)
- RAW_ARG procedure
: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure
- READ procedure (DBMS_LOB)
- READ_CLIENT_INFO procedure
- READ_EV procedure
: 11.2.2.1. The DBMS_SYSTEM.READ_EV procedure
- READ_MODULE procedure
- READ_ONLY procedure
- READ_WRITE procedure
- readev.sql
: 11.2.2.1. The DBMS_SYSTEM.READ_EV procedure
- RECEIVE_MESSAGE function
- receive_unpack_friend procedure
- receive_unpack_request procedure
- recipient lists : 5.1.5. A Glossary of Terms
- overriding subscriber lists
: 5.1.5. A Glossary of Terms
- table types for : 5.3.5. Recipient and Subscriber List Table Types
- tables for : 5.3.6. Message Properties Record Type
- table types for : 5.3.5. Recipient and Subscriber List Table Types
- overriding subscriber lists
: 5.1.5. A Glossary of Terms
- recipients
: (see consumers)
- recmpile.sp : 10.3.2.1. The DBMS_DDL.ALTER_COMPILE procedure
- recompile procedure : 10.3.2.1. The DBMS_DDL.ALTER_COMPILE procedure
- recovery
- recmpile.sp : 10.3.2.1. The DBMS_DDL.ALTER_COMPILE procedure
- automatic
: 4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure
- raw data and : 9.2. UTL_RAW: Manipulating Raw Data
- automatic
: 4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure
- RECTIFY procedure
- referenceability, altering
: 10.3.4. Setting Referenceability of Tables
- REFRESH procedure (DBMS_REFRESH)
- REFRESH procedure (DBMS_SNAPSHOT)
- REFRESH_SNAPSHOT_REPGROUP procedure
- REGISTER procedure (DBMS_ALERT)
: 3.2.2.1. The DBMS_ALERT.REGISTER procedure
- register.sql
- register_app package
- (see also specific program names)
- 1.3.5.1. Examples of encapsulation packages
- 7.3.1. About the register_app Package
- batch process step registration : 7.3.5. Using the register_app Package
- encapsulating DBMS_APPLICATION_INFO with : 7.3.6. Covering DBMS_APPLICATION_INFO
- 1.3.5.1. Examples of encapsulation packages
- (see also specific program names)
- REGISTER_PROPAGATOR procedure
- REGISTER_SNAPSHOT procedure
- REGISTER_STATISTICS procedure
- regtest.sql
: 7.3.5. Using the register_app Package
- relative file numbers, returning : 9.1.3.5. The DBMS_ROWID.ROWID_RELATIVE_FNO function
- RELEASE function
- relative file numbers, returning : 9.1.3.5. The DBMS_ROWID.ROWID_RELATIVE_FNO function
- reload_TF function
: 12.1.3.1. The segspace package
- RELOCATE_MASTERDEF procedure
- remote databases
- (see also distributed databases)
- 4.2.2. Advising Oracle About In-Doubt Transactions
- propagating messages to : 5.1.4. Propagation Features
- 4.2.2. Advising Oracle About In-Doubt Transactions
- (see also distributed databases)
- remote destinations
- (see also RPCs)
- 17.1.1. About Remote Destinations
- adding default destinations : 17.2.2.1. The DBMS_DEFER.SYS.ADD_DEFAULT_DEST procedure
- data dictionary view for : 17.1.1. About Remote Destinations
- deleting default destinations : 17.2.2.2. The DBMS_DEFER.SYS.DELETE_DEFAULT_DEST procedure
- specifying : 17.3.2.1. The DBMS_DEFER.TRANSACTION procedure
- 17.1.1. About Remote Destinations
- (see also RPCs)
- remote procedure calls
: (see RPCs)
- REMOVE procedure (DBMS_ALERT)
- REMOVE procedure (DBMS_JOB)
- remove_all_jobs procedure
- REMOVE_MASTER_DATABASES procedure
- REMOVE_PIPE function
- REMOVE_SUBSCRIBER procedure
- REMOVEALL procedure (DBMS_ALERT)
- REPCAT_IMPORT_CHECK procedure
- repcatlog queue : 15.3.6. Maintaining the Repcatlog Queue with DBMS_REPCAT
- processing entries
: 15.3.6.1. The DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN procedure
- removing entries : 15.3.6.3. The DBMS_REPCAT.PURGE_MASTER_LOG procedure
- waiting for completion : 15.3.6.2. The DBMS_REPCAT.WAIT_MASTER_LOG procedure
- removing entries : 15.3.6.3. The DBMS_REPCAT.PURGE_MASTER_LOG procedure
- processing entries
: 15.3.6.1. The DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN procedure
- repeatable reads
: 4.2.5.1. The DBMS_TRANSACTION.READ_ONLY procedure
- repgroup.sql : 15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure
- replicated objects
- repgroup.sql : 15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure
- (see also master sites; replication groups)
- 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure
- altering : 15.3.3.5. The DBMS_REPCAT.ALTER_MASTER_REPOBJECT procedure
- comments, adding or changing : 15.3.3.6. The DBMS_REPCAT.COMMENT_ON_REPOBJECT procedure
- dropping : 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure
- packages : 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure
- procedures : 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure
- support generation, priority group creation and : 16.3.2.1. The DBMS_REPCAT.DEFINE_PRIORITY_GROUP procedure
- tables : (see tables, replicated tables)
- triggers : (see replication triggers)
- 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure
- (see also master sites; replication groups)
- replication
- (see also advanced replication)
- 13. Job Scheduling in the Database
- job queue and : 13. Job Scheduling in the Database
- propagating DML : 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function
- raw data and : 9.2. UTL_RAW: Manipulating Raw Data
- RPCs and : 17.1.1. About Remote Destinations
- 13. Job Scheduling in the Database
- (see also advanced replication)
- replication groups
- (see also master sites; replicated objects)
- 15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure
- BEFORE ROW triggers and : 15.3.4. Replication Support with DBMS_REPCAT
- comments, adding or changing : 15.3.2.3. The DBMS_REPCAT.COMMENT_ON_REPGROUP procedure
- creating : 15.3.3.1. The DBMS_REPCAT.CREATE_MASTER_REPOBJECT procedure
- creating objects : 15.3.3.1. The DBMS_REPCAT.CREATE_MASTER_REPOBJECT procedure
- creating replication groups : 15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure
- dropping : 15.3.2.2. The DBMS_REPCAT.DROP_MASTER_REPGROUP procedure
- executing DDL : 15.3.3.4. The DBMS_REPCAT.EXECUTE_DDL procedure
- propagation modes
- 15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure
- altering for current session
: 15.6. DBMS_REPUTIL: Enabling and Disabling Replication
- altering for individual columns : 15.3.8.3. The DBMS_REPCAT.SEND_AND_COMPARE_OLD_VALUES procedure (Oracle8 only)
- altering for replication group : 15.3.8.2. The DBMS_REPCAT.ALTER_MASTER_PROPAGATION procedure
- altering for individual columns : 15.3.8.3. The DBMS_REPCAT.SEND_AND_COMPARE_OLD_VALUES procedure (Oracle8 only)
- altering for current session
: 15.6. DBMS_REPUTIL: Enabling and Disabling Replication
- pseudo-primary keys, designating
: 15.3.3.2. The DBMS_REPCAT.SET_COLUMNS procedure
- quiescing : 15.3.7.1. The DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY procedure
- replication schema groups versus : 15.3.2. Replication Groups with DBMS_REPCAT
- resuming activity : 15.3.7.2. The DBMS_REPCAT.RESUME_MASTER_ACTIVITY procedure
- resynchronizing object identifiers : 15.3.8.1. The DBMS_REPCAT.REPCAT_IMPORT_CHECK procedure
- quiescing : 15.3.7.1. The DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY procedure
- (see also master sites; replicated objects)
- replication packages
- replication queue
: (see repcatlog)
- replication support packages
- replication triggers : 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function
- conflict resolution and
: 14.1.2.2. The DBMS_SNAPSHOT.SET_I_AM_A_REFRESH procedure
- deferred transactions and : 17. Deferred Transactions and Remote Procedure Calls
- dropping replicated objects and : 14.4.3.2. The DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT procedure
- dropping replicated tables and : 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure
- generating
- deferred transactions and : 17. Deferred Transactions and Remote Procedure Calls
- propagation mode alteration and : 15.3.8.2. The DBMS_REPCAT.ALTER_MASTER_PROPAGATION procedure
- conflict resolution and
: 14.1.2.2. The DBMS_SNAPSHOT.SET_I_AM_A_REFRESH procedure
- REPLICATION_OFF procedure
: 15.6.2.1. DBMS_REPUTIL.REPLICATION_OFF procedure
- REPLICATION_ON procedure : 15.6.2.2. DBMS_REPUTIL.REPLICATION_ON procedure
- repobjs.sql : 15.3.3.1. The DBMS_REPCAT.CREATE_MASTER_REPOBJECT procedure
- reports
- REPLICATION_ON procedure : 15.6.2.2. DBMS_REPUTIL.REPLICATION_ON procedure
- DBMS_OUTPUT used for
: 6.1. DBMS_OUTPUT: Displaying Output
- Method 4 dynamic SQL used for : 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL
- DBMS_OUTPUT used for
: 6.1. DBMS_OUTPUT: Displaying Output
- repsites.sql
: 15.3.5.1. The DBMS_REPCAT.ADD_MASTER_DATABASE procedure
- REQUEST function
- reset procedure
- RESET_BUFFER procedure
- 3.1.1.1. DBMS_PIPE programs
- 3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure
- message unpacking/sending and : 3.1.7.2. Exploring DBMS_PIPE
- tips about
- 3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure
- 3.1.1.1. DBMS_PIPE programs
- RESET_PACKAGE procedure
- resource accounting
: (see performance analysis)
- resource management : 11.1.4. Managing Session Resources
- server resources : 12. Managing Server Resources
- restricted ROWIDs
- converting from extended ROWIDs
: 9.1.3.9. The DBMS_ROWID.ROWID_TO_RESTRICTED function
- creating extended ROWIDs from : 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function
- format : 9.1.2. ROWID Concepts
- Oracle versions and : 9. Datatype Packages
- creating extended ROWIDs from : 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function
- converting from extended ROWIDs
: 9.1.3.9. The DBMS_ROWID.ROWID_TO_RESTRICTED function
- RESUME_MASTER_ACTIVITY procedure
- RESUME_SUBSET_OF_MASTERS procedure
- RETURNING clause
- dynamic SQL and
: 2.5.7. Using the RETURNING Clause in Dynamic SQL
- multiple-row delete : 2.5.7.2. RETURNING from a multiple-row delete
- single-row insert : 2.5.7.1. RETURNING from a single-row insert
- multiple-row delete : 2.5.7.2. RETURNING from a multiple-row delete
- dynamic SQL and
: 2.5.7. Using the RETURNING Clause in Dynamic SQL
- RevealNet
: About PL/Vision
- REVERSE function : 9.2.3.13. The UTL_RAW.REVERSE function
- REVOKE_ADMIN_ANY_REPGROUP procedure
- REVERSE function : 9.2.3.13. The UTL_RAW.REVERSE function
- REVOKE_ADMIN_ANY_REPSCHEMA procedure
: 15.2.1.1. DBMS_REPCAT_ADMIN programs
- REVOKE_ADMIN_REPGROUP procedure
- REVOKE_ADMIN_REPSCHEMA procedure
: 15.2.1.1. DBMS_REPCAT_ADMIN programs
- REVOKE_SURROGATE_REPCAT procedure
- roles
- (see also privileges)
- 2.4.2. Privileges and Execution Authority with DBMS_SQL
- advanced queuing and
- 2.4.2. Privileges and Execution Authority with DBMS_SQL
- job execution and
: 13.2.2. Job Execution and the Job Execution Environment
- session roles
- enabling/disabling
: 11.1.2.4. The DBMS_SESSION.SET_ROLE procedure
- testing if enabled : 11.1.3.1. The DBMS_SESSION.IS_ROLE_ENABLED function
- enabling/disabling
: 11.1.2.4. The DBMS_SESSION.SET_ROLE procedure
- (see also privileges)
- rollback : 4.2.4. Rolling Back Changes
- alerts and
: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure
- lock persistence and : 4.1.2.2. The DBMS_LOCK.REQUEST function
- message processing and : 5.1.3. Dequeue Features
- snapshot refreshing and : 14.1.3.1. The DBMS_SNAPSHOT.REFRESH procedure
- lock persistence and : 4.1.2.2. The DBMS_LOCK.REQUEST function
- alerts and
: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure
- ROLLBACK procedure
- ROLLBACK_FORCE procedure
- ROLLBACK_SAVEPOINT procedure
- row numbers, returning
: 9.1.3.6. The DBMS_ROWID.ROWID_ROW_NUMBER function
- rowbyhash function : 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function
- rowbyscan function : 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function
- ROWID_ARG procedure : 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure
- ROWID_BLOCK_NUMBER function : 9.1.3.1. The DBMS_ROWID.ROWID_BLOCK_NUMBER function
- ROWID_CREATE function : 9.1.3.2. The DBMS_ROWID.CREATE_ROWID function
- ROWID_INFO procedure : 9.1.3.3. The DBMS_ROWID.ROWID_INFO procedure
- ROWID_OBJECT function : 9.1.3.4. The DBMS_ROWID.ROWID_OBJECT function
- ROWID_RELATIVE_FNO function : 9.1.3.5. The DBMS_ROWID.ROWID_RELATIVE_FNO function
- ROWID_ROW_NUMBER function : 9.1.3.6. The DBMS_ROWID.ROWID_ROW_NUMBER function
- ROWID_TO_ABSOLUTE_FNO function : 9.1.3.7. The DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO function
- ROWID_TO_EXTENDED function : 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function
- ROWID_TO_RESTRICTED function : 9.1.3.9. The DBMS_ROWID.ROWID_TO_RESTRICTED function
- ROWID_TYPE function : 9.1.3.10. The DBMS_ROWID.ROWID_TYPE function
- ROWID_VERIFY function : 9.1.3.11. The DBMS_ROWID.ROWID_VERIFY function
- ROWIDs
- rowbyhash function : 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function
- (see also extended ROWIDs; restricted ROWIDs)
- 9. Datatype Packages
- 9.1.2. ROWID Concepts
- absolute file numbers, returning : 9.1.3.7. The DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO function
- block numbers, returning : 9.1.3.1. The DBMS_ROWID.ROWID_BLOCK_NUMBER function
- components of, returning : 9.1.3.3. The DBMS_ROWID.ROWID_INFO procedure
- creating : 9.1.3.2. The DBMS_ROWID.CREATE_ROWID function
- datatypes of
- 9. Datatype Packages
- dropped files and
: 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function
- format : 9.1.2. ROWID Concepts
- latest row fetched : 2.3.10.3. The DBMS_SQL.LAST_ROW_ID function
- object numbers and : 9.1.3.4. The DBMS_ROWID.ROWID_OBJECT function
- parsing : 9.1.3.3. The DBMS_ROWID.ROWID_INFO procedure
- relative file numbers, returning : 9.1.3.5. The DBMS_ROWID.ROWID_RELATIVE_FNO function
- returning : 9.1.3.2. The DBMS_ROWID.CREATE_ROWID function
- verifying : 9.1.3.11. The DBMS_ROWID.ROWID_VERIFY function
- format : 9.1.2. ROWID Concepts
- (see also extended ROWIDs; restricted ROWIDs)
- ROWIDTOCHAR function (Oracle7)
: 9.1.2. ROWID Concepts
- rows
- deleting arrays
- deleting objects in
: 9.2.5.1. The UTL_REF.DELETE_OBJECT procedure
- fetching
- 2.3.1. Processing Flow of Dynamic SQL
- 2.3.7. Fetching Rows
- 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
- example : 2.5.4.6. Retrieving and displaying data
- immediate fetching : 2.3.7.2. The DBMS_SQL.EXECUTE_AND_FETCH function
- past last record
- 2.3.7. Fetching Rows
- 2.3.1. Processing Flow of Dynamic SQL
- fetching arrays
- inserting arrays
: 2.5.6.1. Using array processing to insert
- rowid of latest row fetched : 2.3.10.3. The DBMS_SQL.LAST_ROW_ID function
- rows fetched count : 2.3.10.2. The DBMS_SQL.LAST_ROW_COUNT function
- updating arrays : 2.5.6.3. Using array processing to update
- rowid of latest row fetched : 2.3.10.3. The DBMS_SQL.LAST_ROW_ID function
- rows procedure
: 2.5.6.4. Using array processing to fetch
- RPCs
- (see also deferred transactions)
- 17.1.1. About Remote Destinations
- specifying : 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure
- arguments
- obtaining datatypes
: 17.4.1.3. The DBMS_DEFER_QUERY.GET_ARG_TYPE function
- obtaining datatypes and values : 17.4.1.4. The DBMS_DEFER_QUERY.GET_CALL_ARGS procedure
- obtaining values : 17.4.1.5. The DBMS_DEFER_QUERY.GET_<datatype>_ARG function
- obtaining datatypes and values : 17.4.1.4. The DBMS_DEFER_QUERY.GET_CALL_ARGS procedure
- obtaining datatypes
: 17.4.1.3. The DBMS_DEFER_QUERY.GET_ARG_TYPE function
- calling
: 17.3.2.2. The DBMS_DEFER.CALL procedure
- data dictionary views for : 17.1.2. Data Dictionary Views
- destinations for : 17.1.1. About Remote Destinations
- parameterized RPCs : 17.3.3. Parameterized RPCs
- parameterless RPCs : 17.3.2. Basic RPCs
- queuing of (illustration) : 17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure
- replication and : 17.1.1. About Remote Destinations
- data dictionary views for : 17.1.2. Data Dictionary Views
- (see also deferred transactions)
- RUN procedure
- runddl.sp
: 2.4.2.2. The tale of Scott
- runprog.sp : 2.3.8.3. The DBMS_SQL.VARIABLE_VALUE procedure
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
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.