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

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