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
• • Developer raises ZERO_DIVIDE exception
  • RAISE Nothing but Exceptions
• RAISE_APPLICATION_ERROR procedure
• • Unnamed Developer-Defined Exceptions
  • Client-Server Error Communication
• raising exceptions
• • (see also exceptions)
  • Raising exceptions in nested blocks
  • Raising an Exception
  • RAISE Nothing but Exceptions
• range scheme, FOR loops : The Numeric FOR Loop
• RAW datatype
• • The RAW datatype
  • The HEXTORAW function
• RAWTOHEX function : The RAWTOHEX function
• RDBMS language : Improved Application Portability with PL/SQL
• read consistency, stored functions and : Read Consistency Model Complications
• READ procedure : The READ procedure
• read-committed isolation level : The SET TRANSACTION Statement
• read-only parameters : (see IN mode)
• read-only transactions : The SET TRANSACTION Statement
• READ_ONLY procedure : The READ_ONLY procedure
• READ_WRITE procedure : The READ_WRITE procedure
• readability of code : Improving Readability
• readability, local modules for : Write as Little Code as Possible
• REAL subtype : Numeric Subtypes
• real-time production support : Features of a Real-Time Support Mechanism
• RECEIVE_MESSAGE function : The RECEIVE_MESSAGE function
• records
• • (see also variables)
  • Developer-defined records
  • Write as Little Code as Possible
  • Variables and Program Data
  • Records in PL/SQL
  • accessing data from : Accessing Record-Based Data
  • child : The EXCEPTION_INIT pragma
  • collections as components of : Collections as components of a record
  • comparing : Comparing Two Records
  • compatibility of : Record Types and Record Compatibility
  • corresponding to cursors : Guidelines for Using Records
  • cursor FOR loops : The Cursor FOR Loop Record
  • cursor-based
  • • (see also cursors)
    • Cursor-Based Records
  • declaring
  • • Declaring Records with the %ROWTYPE Attribute
    • Declaring the Record
  • deleting
  • • Clearing the PL/SQL Table
    • The DELETE procedure
  • fetching into : (see FETCH statement)
  • filling : Filling the Rows of a PL/SQL Table
  • index-by tables of : Use Index-By Tables of Records and Objects
  • initializing : Record Initialization
  • locking : SELECT FOR UPDATE in Cursors
  • manual : Manual records
  • naming columns of : Setting the Record's Column Names
  • nested : Nested Records
  • as parameters : Guidelines for Using Records
  • developer-defined : Developer-Defined Records
  • referencing : Referencing a Record and its Fields
  • setting to NULL : Setting records to NULL
  • table-based : Table-Based Records
  • in tables : PL/SQL Table Enhancements in PL/SQL Release 2.3
  • • referencing fields of : Referencing fields of record elements in PL/SQL tables
• recursion, mutual : (see forward declarations)
• recursive object types : Forward type definitions
• recursive processing : Recursive Processing in a SQL Statement
• redundancy
• • avoiding in package bodies : Center All Development Around Packages
  • local modules for : Write as Little Code as Possible
• REF CURSOR type
• • (see also cursor variables)
  • Declaring REF CURSOR Types and Cursor Variables
  • Cursor variable aliases
  • identifying : Identifying the REF CURSOR type
• REF keyword : Adding Complex Data Structures
• reference pointers : (see REFs)
• references to host variables : Minimize references to host variables
• references to objects : (see REFs)
• referencing
• • record fields in tables : Referencing fields of record elements in PL/SQL tables
  • table rows : Referencing and Modifying PL/SQL Table Rows
• REFRESH procedure : The REFRESH procedure
• REFRESH_ALL procedure : The REFRESH_ALL procedure
• REFs (object references)
• • Inheritance
  • Adding Complex Data Structures
  • REFs
  • as collection elements : Collections "In the Database"
  • DEREF operator and : DEREF
  • object views and
  • • Object Views
    • MAKE_REF: Returning a Virtual REF
    • Using REFs with Object Views
  • as operators : REFs
  • as type modifiers : REFs
• REGISTER procedure : The REGISTER procedure
• relational (=) operators : The PL/SQL Character Set
• Release 1.1, PL/SQL
• • PL/SQL Release 1.1
  • Features of the array package
• Release 2.1, PL/SQL : PL/SQL Release 2.1
• • new_add_months function : Customizing the Behavior of ADD_MONTHS
  • overloaded modules : Restrictions on Overloading
• Release 2.2, PL/SQL : PL/SQL Release 2.2
• • cursor variables : Cursor Variables
• Release 2.3, PL/SQL
• • PL/SQL Release 2.3
  • PL/SQL Tables
  • tables : PL/SQL Table Enhancements in PL/SQL Release 2.3
• RELEASE function : The RELEASE function
• releasing record locks : Releasing Locks with COMMIT
• remainder function : The MOD function
• remote dependency
• • Improved remote dependency model
  • External procedures
• remote procedure calls (RPCs) : No Direct Remote Procedure Calls
• remote procedures
• • Default Values and Remote Procedure Calls
  • Remote Procedure Calls
• REMOVE procedure
• • The REMOVE procedure
  • The REMOVE procedure
• REMOVE_PIPE function : The REMOVE_PIPE function
• REMOVEALL procedure : The REMOVEALL procedure
• removing : (see deleting)
• REPEAT UNTIL loop : Emulating a REPEAT UNTIL Loop
• repetitive code
• • (see redundancy)
  • Benefits of Local Modularization
• REPLACE function
• • (see also TRANSLATE function)
  • Function Results with NULL Arguments
  • The REPLACE function
  • The TRANSLATE function
• replacing characters in strings : The TRANSLATE function
• REQUEST function : The REQUEST function
• reserved words
• • Reserved Words
  • Using Case to Aid Readability
• RESET_BUFFER procedure : The RESET_BUFFER procedure
• RESET_PACKAGE procedure : The RESET_PACKAGE procedure
• RESTRICT_REFEFRENCES pragma : Requirements for Stored Functions in SQL
• RESTRICT_REFERENCES pragma : The RESTRICT_REFERENCES Pragma
• • manual application of : Manual Application of Pragmas
• RETURN datatype : The RETURN Datatype
• RETURN statement
• • The Cursor RETURN Clause
  • RETURN statement
  • The RETURN Statement
  • cursor : Declaring Cursors
  • in procedures : RETURN statement in a procedure
  • overloaded functions : Restrictions on Overloading
  • of package cursors : Declaring Package Cursors
  • using single : Use a Single RETURN Statement for Successful Termination
• reusing code : Write as Little Code as Possible
• REVERSE keyword : Rules for Numeric FOR Loops
• rights models : Rights model
• RNDS purity code : The RESTRICT_REFERENCES Pragma
• RNPS purity code : The RESTRICT_REFERENCES Pragma
• ROLLBACK procedure : The ROLLBACK procedure
• ROLLBACK statement
• • The ROLLBACK Statement
  • Releasing Locks with COMMIT
  • ROLLBACK TO statement : The ROLLBACK Statement
• ROLLBACK_FORCE procedure : The ROLLBACK_FORCE procedure
• ROLLBACK_SAVEPOINT procedure : The ROLLBACK_SAVEPOINT procedure
• ROUND function
• • The ROUND function
  • The ROUND function
• rounding dates : The ROUND function
• row numbers, converting expressions to : Automatic Conversion of Row Number Expressions
• %ROWCOUNT cursor attribute : The %ROWCOUNT Attribute
• ROWID datatype : The ROWID datatype
• • converting to/from : The CHARTOROWID function
• ROWID_BLOCK_NUMBER function : The ROWID_BLOCK_NUMBER function
• ROWID_CREATE function : The ROWID_CREATE function
• ROWID_INFO procedure : The ROWID_INFO procedure
• ROWID_OBJECT function : The ROWID_OBJECT function
• ROWID_RELATIVE_FNO function : The ROWID_RELATIVE_FNO function
• ROWID_ROW_NUMBER function : The ROWID_ROW_NUMBER function
• ROWID_TO_ABSOLUTE_FNO function : The ROWID_TO_ABSOLUTE_FNO function
• ROWID_TO_EXTENDED function : The ROWID_TO_EXTENDED function
• ROWID_TO_RESTRICTED function : The ROWID_TO_RESTRICTED function
• ROWID_TYPE function : The ROWID_TYPE function
• ROWID_VERIFY function : The ROWID_VERIFY function
• ROWIDs, DBMS_ROWID package for : DBMS_ROWID (PL/SQL8 Only)
• ROWIDTOCHAR function : The ROWIDTOCHAR function
• rows, table
• • (see also records)
  • Different Types of Records
  • data-smart numbers for : Data-Smart Row Numbers in PL/SQL Tables
  • negative index : Characteristics of PL/SQL Tables
  • objects for : Some Simple Examples
  • referencing and modifying : Referencing and Modifying PL/SQL Table Rows
• %ROWTYPE attribute
• • Synchronize Program and Data Structures
  • Declaring Records with the %ROWTYPE Attribute
  • %TYPE and %ROWTYPE
  • in cursor declarations : (see cursors)
• ROWTYPE_MISMATCH exception : Handling the ROWTYPE_MISMATCH exception
• RPAD function : The RPAD function
• RPCs (remote procedure calls) : Remote Procedure Calls
• RR format model : RR: Changing Millenia
• RTRIM function : The RTRIM function
• run authority
• • (see execute authority)
  • Improved Execution Authority and Transaction Integrity with PL/SQL
• RUN procedure : The RUN procedure