Book HomeBook HomeSearch this book

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


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
The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference