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

Index: R

RAISE statement

8.5.1.2. Programmer raises ZERO_DIVIDE exception

8.10. RAISE Nothing but Exceptions

RAISE_APPLICATION_ERROR procedure

8.3.4. Unnamed Programmer-Defined Exceptions

8.7. Client-Server Error Communication

raising exceptions

(see also exceptions)

8.4.1.2. Raising exceptions in nested blocks

8.5. Raising an Exception

8.10. RAISE Nothing but Exceptions

range scheme, FOR loops : 7.3. The Numeric FOR Loop

RAW datatype

4.2.3.4. The RAW datatype

14.2.3. The HEXTORAW function

RAWTOHEX function : 14.2.4. The RAWTOHEX function

RDBMS language : 1.3.1. Improved Application Portability with PL/SQL

read consistency, stored functions and : 17.7.2. Read Consistency Model Complications

READ procedure : C.6.13. The READ procedure

read-committed isolation level : 6.1.4. The SET TRANSACTION Statement

read-only parameters : (see IN mode)

read-only transactions : 6.1.4. The SET TRANSACTION Statement

READ_ONLY procedure : C.15.7. The READ_ONLY procedure

READ_WRITE procedure : C.15.8. The READ_WRITE procedure

readability of code : 15.7.3. Improving Readability

readability, local modules for : 1.7.1. Write as Little Code as Possible

REAL subtype : 4.2.2. Numeric Subtypes

real-time production support : 26.2.1. Features of a Real-Time Support Mechanism

RECEIVE_MESSAGE function : C.10.5. The RECEIVE_MESSAGE function

records

(see also variables)

1.4.3.3. Programmer-defined records

1.7.1. Write as Little Code as Possible

4. Variables and Program Data

9. Records in PL/SQL

accessing data from : 9.1.2. Accessing Record-Based Data

child : 8.3.3.1. The EXCEPTION_INIT pragma

collections as components of : 19.2.2.2. Collections as components of a record

comparing : 9.1.6. Comparing Two Records

compatibility of : 9.6. Record Types and Record Compatibility

corresponding to cursors : 9.1.4. Guidelines for Using Records

cursor FOR loops : 7.4.2. The Cursor FOR Loop Record

cursor-based

(see also cursors)

9.3. Cursor-Based Records

declaring

9.2.1. Declaring Records with the %ROWTYPE Attribute

9.4.2. Declaring the Record

deleting

10.7. Clearing the PL/SQL Table

10.8.2.2. The DELETE procedure

fetching into : (see FETCH statement)

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

index-by tables of : 25.4.8. Use Index-By Tables of Records and Objects

initializing : 9.6.2. Record Initialization

locking : 6.11. SELECT FOR UPDATE in Cursors

manual : 9.6.1.1. Manual records

naming columns of : 9.3.2. Setting the Record's Column Names

nested : 9.7. Nested Records

as parameters : 9.1.4. Guidelines for Using Records

programmer-defined : 9.4. Programmer-Defined Records

referencing : 9.1.5. Referencing a Record and its Fields

setting to NULL : 9.6.1.3. Setting records to NULL

table-based : 9.2. Table-Based Records

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

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

recursion, mutual : (see forward declarations)

recursive object types : 18.3.5.1. Forward type definitions

recursive processing : 17.8.7. Recursive Processing in a SQL Statement

redundancy

avoiding in package bodies : 1.7.3. Center All Development Around Packages

local modules for : 1.7.1. Write as Little Code as Possible

REF CURSOR type

(see also cursor variables)

6.12.3. Declaring REF CURSOR Types and Cursor Variables

6.12.6.3. Cursor variable aliases

identifying : 6.12.7.1. Identifying the REF CURSOR type

REF keyword : 18.2.3. Adding Complex Data Structures

reference pointers : (see REFs)

references to host variables : 25.4.3.2. Minimize references to host variables

references to objects : (see REFs)

referencing

record fields in tables : 10.8.1.1. Referencing fields of record elements in PL/SQL tables

table rows : 10.5. Referencing and Modifying PL/SQL Table Rows

REFRESH procedure : C.13.4. The REFRESH procedure

REFRESH_ALL procedure : C.13.5. The REFRESH_ALL procedure

REFs (object references)

18.1.4.3. Inheritance

18.2.3. Adding Complex Data Structures

18.4.2.2. REFs

as collection elements : 19.2.1. Collections "In the Database"

DEREF operator and : 18.4.2.4. DEREF

object views and

20. Object Views

20.3.3. MAKE_REF: Returning a Virtual REF

20.4.2. Using REFs with Object Views

as operators : 18.4.2.2. REFs

as type modifiers : 18.4.2.2. REFs

REGISTER procedure : C.2.1. The REGISTER procedure

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

Release 1.1, PL/SQL

1.4.8. PL/SQL Release 1.1

10.9.4.3. Features of the array package

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

new_add_months function : 12.2.1. Customizing the Behavior of ADD_MONTHS

overloaded modules : 15.8.4. Restrictions on Overloading

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

cursor variables : 6.12. Cursor Variables

Release 2.3, PL/SQL

1.4.6. PL/SQL Release 2.3

10.1.1. PL/SQL Tables

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

RELEASE function : C.7.3. The RELEASE function

releasing record locks : 6.11.1. Releasing Locks with COMMIT

remainder function : 13.1.13. The MOD function

remote dependency

1.4.6.4. Improved remote dependency model

1.4.7.5. External procedures

remote procedure calls (RPCs) : B.2.3. No Direct Remote Procedure Calls

remote procedures

22.7.5. Default Values and Remote Procedure Calls

23.4. Remote Procedure Calls

REMOVE procedure

C.2.2. The REMOVE procedure

C.5.6. The REMOVE procedure

REMOVE_PIPE function : C.10.6. The REMOVE_PIPE function

REMOVEALL procedure : C.2.3. The REMOVEALL procedure

removing : (see deleting)

REPEAT UNTIL loop : 7.2.2. Emulating a REPEAT UNTIL Loop

repetitive code

(see redundancy)

15.7.1. Benefits of Local Modularization

REPLACE function

(see also TRANSLATE function)

4.3.3. Function Results with NULL Arguments

11.1.10. The REPLACE function

11.1.15. The TRANSLATE function

replacing characters in strings : 11.1.15. The TRANSLATE function

REQUEST function : C.7.4. The REQUEST function

reserved words

2.2.1. Reserved Words

3.1.2. Using Case to Aid Readability

RESET_BUFFER procedure : C.10.7. The RESET_BUFFER procedure

RESET_PACKAGE procedure : C.12.3. The RESET_PACKAGE procedure

RESTRICT_REFEFRENCES pragma : 17.3. Requirements for Stored Functions in SQL

RESTRICT_REFERENCES pragma : 17.5.1. The RESTRICT_REFERENCES Pragma

manual application of : 17.7.1. Manual Application of Pragmas

RETURN datatype : 15.5.2. The RETURN Datatype

RETURN statement

6.4.4. The Cursor RETURN Clause

7.7.2.3. RETURN statement

15.5.8. The RETURN Statement

cursor : 6.4. Declaring Cursors

in procedures : 15.5.8.5. RETURN statement in a procedure

overloaded functions : 15.8.4. Restrictions on Overloading

of package cursors : 16.3.2. Declaring Package Cursors

using single : 22.2.2. Use a Single RETURN Statement for Successful Termination

reusing code : 1.7.1. Write as Little Code as Possible

REVERSE keyword : 7.3.1. Rules for Numeric FOR Loops

rights models : 18.3.7.3. Rights model

RNDS purity code : 17.5.1. The RESTRICT_REFERENCES Pragma

RNPS purity code : 17.5.1. The RESTRICT_REFERENCES Pragma

ROLLBACK procedure : C.15.9. The ROLLBACK procedure

ROLLBACK statement

6.1.2. The ROLLBACK Statement

6.11.1. Releasing Locks with COMMIT

ROLLBACK TO statement : 6.1.2. The ROLLBACK Statement

ROLLBACK_FORCE procedure : C.15.10. The ROLLBACK_FORCE procedure

ROLLBACK_SAVEPOINT procedure : C.15.11. The ROLLBACK_SAVEPOINT procedure

ROUND function

12.1.6. The ROUND function

13.1.15. The ROUND function

rounding dates : 12.1.6. The ROUND function

row numbers, converting expressions to : 10.5.1. Automatic Conversion of Row Number Expressions

%ROWCOUNT cursor attribute : 6.9.3. The %ROWCOUNT Attribute

ROWID datatype : 4.2.3.6. The ROWID datatype

converting to/from : 14.2.1. The CHARTOROWID function

ROWID_BLOCK_NUMBER function : C.11.6. The ROWID_BLOCK_NUMBER function

ROWID_CREATE function : C.11.1. The ROWID_CREATE function

ROWID_INFO procedure : C.11.2. The ROWID_INFO procedure

ROWID_OBJECT function : C.11.4. The ROWID_OBJECT function

ROWID_RELATIVE_FNO function : C.11.5. The ROWID_RELATIVE_FNO function

ROWID_ROW_NUMBER function : C.11.7. The ROWID_ROW_NUMBER function

ROWID_TO_ABSOLUTE_FNO function : C.11.8. The ROWID_TO_ABSOLUTE_FNO function

ROWID_TO_EXTENDED function : C.11.9. The ROWID_TO_EXTENDED function

ROWID_TO_RESTRICTED function : C.11.10. The ROWID_TO_RESTRICTED function

ROWID_TYPE function : C.11.3. The ROWID_TYPE function

ROWID_VERIFY function : C.11.11. The ROWID_VERIFY function

ROWIDs, DBMS_ROWID package for : C.11. DBMS_ROWID (PL/SQL8 Only)

ROWIDTOCHAR function : 14.2.5. The ROWIDTOCHAR function

rows, table

(see also records)

9.1.1. Different Types of Records

data-smart numbers for : 10.9.2. Data-Smart Row Numbers in PL/SQL Tables

negative index : 10.2. Characteristics of PL/SQL Tables

objects for : 18.1.2. Some Simple Examples

referencing and modifying : 10.5. Referencing and Modifying PL/SQL Table Rows

%ROWTYPE attribute

1.7.2. Synchronize Program and Data Structures

9.2.1. Declaring Records with the %ROWTYPE Attribute

15.6.1.1. %TYPE and %ROWTYPE

in cursor declarations : (see cursors)

ROWTYPE_MISMATCH exception : 6.12.5.2. Handling the ROWTYPE_MISMATCH exception

RPAD function : 11.1.11. The RPAD function

RPCs (remote procedure calls) : 23.4. Remote Procedure Calls

RR format model : 14.3.3. RR: Changing Millenia

RTRIM function : 11.1.12. The RTRIM function

run authority

(see execute authority)

1.3.2. Improved Execution Authority and Transaction Integrity with PL/SQL

RUN procedure : C.5.7. The RUN procedure

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.