Index

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

Index: R

RAISE statement : 22.1.5. What About the Reraise Action?

raise_exception procedure : 22.3.3.5. Responding to the exception action

range assertion routines : 6.3.3. Asserting "In Range"

rb function : 5.10.5. Rolling back on exception

rb_to procedure

5.17.7. Rolling back in PLVlog
21.1.5.4. Setting the default "rollback to" behavior

rb_to_default procedure

5.17.7. Rolling back in PLVlog
21.1.5.4. Setting the default "rollback to" behavior

rb_to_last procedure

5.17.7. Rolling back in PLVlog
5.23.3. Performing rollbacks
20.2.4. Performing Rollbacks
21.1.5.4. Setting the default "rollback to" behavior

rbdef procedure

5.10.5. Rolling back on exception
22.1.8. Rolling Back When an Exception Occurs

rblast procedure

5.10.5. Rolling back on exception
22.1.8. Rolling Back When an Exception Occurs

READ_ERROR exception : 13.1.4. Handling UTL_FILE Errors

reading

from files

13.5. Reading From a File
5.11.9. Reading from a file

from source repository

5.15.7. Reading and writing lines
12. PLVio: Reading and Writing PL/SQL Source Code
12.6. Reading From the Source

log files : 5.17.5. Reading the log

recfnd procedure

5.13.10. Miscellaneous code generators
16.2.7. Generating a "Record Found?" Function

recNgo procedure

5.10.6. Exception handlers
22.1.6.2. The high-level handlers
22.3.4.2. Implementing the high-level handlers

recNstop procedure

5.10.6. Exception handlers
22.1.6.2. The high-level handlers
22.1.9. Halting in PLVexc

recompiling packages : 2.4. Organizing Package Source Code

Record Found? function : 16.2.7. Generating a "Record Found?" Function

record_exception procedure : 22.3.4.1. Leveraging PLVLog

recording : (see logging)

recording_exception function : 22.3.3.3. Recording the exception

recursion : 3.10. Choosing the Best Performer

redirection : 1.6.4. Working with Large Packages

redundancy

1.6.1.1. Clean up a bewildering mass of standalone functions and procedures
1.6.4. Working with Large Packages
2.11. Simultaneous Construction of Multiple Packages
3.1. The Basic Problem
15.4.2.11. Consolidating redundant code
naming : 2.3.2. Avoiding Redundancy

refall procedure : 18.2.4. Identifying References and Dependencies

refbi procedure

5.5.2. Identifying references in stored code
18.2.4. Identifying References and Dependencies

references : (see documentation)

identifying : 5.5.2. Identifying references in stored code
identifying with PLVcat : 18.2.4. Identifying References and Dependencies
of package elements : 1.4.2. Referencing Package Elements
PLVrfrnc table : 18.2.2.2. PLVrfrnc table
RESTRICT_REFERENCES pragma : 1.6.5.1. RESTRICT_REFERENCES pragma

refnonkw procedure

5.5.2. Identifying references in stored code
18.2.4. Identifying References and Dependencies

rem_line_limit procedure

5.15.5. Managing the source WHERE clause
12.4.4. Cleaning Up the WHERE Clause

rem_srcwhere procedure

5.15.5. Managing the source WHERE clause
12.4.4. Cleaning Up the WHERE Clause

repeats function : 5.27.2. Setting the repetition value

replaceitem procedure : 5.18.3. Modifying list contents

repos_rectype TYPE : 12.2.2. Database Source or Target

repository, code : (see PLVio package)

reraise procedure : 22.1.5. What About the Reraise Action?

reserved words

2.2. Using Effective Coding Style for Packages
5.26. PLVtkn: Token Table Interface
10.2. PLVtkn: Managing PL/SQL Tokens
determining types of : 10.2.2. Determining Token Type
displaying code by : 15.3.2. Displaying Code by Keyword
initializing table of : 10.3.3. Initializing a Table of Tokens

reset_savepoints procedure : 5.23.4. Managing savepoints

rest_of_line function : 5.15.7. Reading and writing lines

restoresrc procedure : 5.15.8. Saving and restoring repository settings

restoretrg procedure : 5.15.8. Saving and restoring repository settings

restoring

PL/SQL objects : 11.3.4. Saving and Restoring the Current Object

repository settings

12.8. Saving and Restoring Settings
5.15.8. Saving and restoring repository settings

restrict procedure : 9.4. The Restriction Toggle

RESTRICT_REFERENCES pragma : 1.6.5.1. RESTRICT_REFERENCES pragma

restricting function : 9.4. The Restriction Toggle

restricting use of text : 5.19.1. Restricting use of text

reusing code

(see flexibility, code)
1.2.1. The Iceberg Approach to Coding
4.1.1. The Benefits of PL/Vision

RNDS purity code

1.6.5.1. RESTRICT_REFERENCES pragma
1.6.5.2. Asserting the purity level of the initialization section

RNPS purity code : 1.6.5.1. RESTRICT_REFERENCES pragma

rollback behavior : 21.1.5.4. Setting the default "rollback to" behavior

rollback_to procedure

5.23.3. Performing rollbacks
20.2.4. Performing Rollbacks

rollbacks

5.23. PLVrb: Rollback Processing

20.2. PLVrb: Performing Rollbacks

on errors : 22.1.8. Rolling Back When an Exception Occurs

PLVlog package and

21.1.5. Rolling Back with PLVlog
5.17.7. Rolling back in PLVlog

rolling_back function

5.17.7. Rolling back in PLVlog
5.23.1. Controlling rollback activity
21.1.5.1. Toggling rollback activity

%ROWCOUNT attribute : 20.1.1.4. Getting back on track

rows, table : (see tables)

%ROWTYPE attribute : 2.10.5. Anchoring to Public Variables

RPAD function : 3.9. Considering Implementation Options

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