Index

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 | X

Index: D

data block addresses
block numbers, returning
9.1.3.1. The DBMS_ROWID.ROWID_BLOCK_NUMBER function
10.1.2.6. The DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK function
constructing : 10.1.2.16. The DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS function
dropped files and : 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function
file numbers, returning : 10.1.2.7. The DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE function
Data Definition Language statements : (see DDL statements)
Data Manipulation Language statements : (see DML statements)
DATA_BLOCK_ADDRESS_BLOCK function
10.1.1. Getting Started with DBMS_UTILITY
10.1.2.6. The DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK function
DATA_BLOCK_ADDRESS_FILE function
10.1.1. Getting Started with DBMS_UTILITY
10.1.2.7. The DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE function
database events : (see alerts)
database links
advanced replication and : 15.1.2. Granting and Revoking Surrogate SYS Accounts
closing : 11.1.4.1. The DBMS_SESSION.CLOSE_DATABASE_LINK procedure
enhancement : 11.1.5.5. The close_links procedure
deferred transactions and : 17.2.2.1. The DBMS_DEFER.SYS.ADD_DEFAULT_DEST procedure
job execution and : 13.1.2.2. The what parameter
job scheduling and : 13.2.2. Job Execution and the Job Execution Environment
names for
parsing : 10.1.2.18. The DBMS_UTILITY.NAME_TOKENIZE procedure
returning : 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure
database segments, extended ROWID format and : 9.1.2. ROWID Concepts
databases
(see also remote databases)
5.1.4. Propagation Features
shutdown and job queue : 13.2.1.3. JOB_QUEUE_KEEP_CONNECTIONS
space utilization : 12.1. DBMS_SPACE: Obtaining Space Information
version information : 10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure
datatypes
determining (example) : 2.5.4.3. Constructing the SELECT
message structure and : 5.1.1. General Features
numeric values for : 3.1.4.7. The DBMS_PIPE.NEXT_ITEM_TYPE function
DBMS_DEFER_QUERY : 17.4.1.2. DBMS_DEFER_QUERY nonprogram elements
DESCRIBE_COLUMNS : 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure
DESCRIBE_PROCEDURE : 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure
GET_ARG_TYPE : 17.4.1.3. The DBMS_DEFER_QUERY.GET_ARG_TYPE function
UNPACK_MESSAGE : 3.1.4.4. The DBMS_PIPE.UNPACK_MESSAGE procedure
Oracle8
2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure
2.4.1. Some Restrictions
date format (NLS), setting : 11.1.2.3. The DBMS_SESSION.SET_NLS procedure
date-to/from-raw conversions : 9.2.2.1. Conversion and coercion
DATE_ARG procedure : 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure
db package
(see also specific program names)
1.3.5.1. Examples of encapsulation packages
10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function
10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure
db_block_buffers function : 10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function
DB_VERSION procedure
10.1.1. Getting Started with DBMS_UTILITY
10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure
DBA_2PC_PENDING view
4.2.2. Advising Oracle About In-Doubt Transactions
4.2.3.2. The DBMS_TRANSACTION.COMMIT_COMMENT procedure
4.2.3.3. The DBMS_TRANSACTION.COMMIT_FORCE procedure
4.2.4.2. The DBMS_TRANSACTION.ROLLBACK_FORCE procedure
4.2.6.1. The DBMS_TRANSACTION.PURGE_MIXED procedure
4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure
DBA_JOBS view
5.6.2.3. The DBA_JOBS view
13.3.2. Viewing Job Information in the Data Dictionary
DBA_JOBS_RUNNING view : 13.3.2. Viewing Job Information in the Data Dictionary
DBA_KEEPSIZES view : 12.2.4.3. The DBA_KEEPSIZES view
DBA_QUEUE_TABLES view
5.1.8. Data Dictionary Views
5.6.2.1. The DBA_QUEUE_TABLES view
DBA_QUEUES view
5.1.8. Data Dictionary Views
5.6.2.2. The DBA_QUEUES view
DBA_REGISTERED_SNAPSHOTS view : 14.1.6. Registering Snapshots
DBA_REPCOLUMN_GROUP view : 16.1.4. Data Dictionary Views
DBA_REPCONFLICT view : 16.1.4. Data Dictionary Views
DBA_REPGROUPED_COLUMN view : 16.1.4. Data Dictionary Views
DBA_REPPARAMETER_COLUMN view : 16.1.4. Data Dictionary Views
DBA_REPPRIORITY view : 16.1.4. Data Dictionary Views
DBA_REPPRIORITY_GROUP view : 16.1.4. Data Dictionary Views
DBA_REPRESOL_STATS_CONTROL view : 16.1.4. Data Dictionary Views
DBA_REPRESOLUTION view : 16.1.4. Data Dictionary Views
DBA_REPRESOLUTION_METHOD view : 16.1.4. Data Dictionary Views
DBA_REPRESOLUTION_STATISTICS view : 16.1.4. Data Dictionary Views
dblock package
(see also specific program names)
1.3.5.1. Examples of encapsulation packages
4.1.4.1. The dblock package
dblock.sql : 4.1.4.1. The dblock package
DBMS_ALERT package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
3.2. DBMS_ALERT: Broadcasting Alerts to Users
3.2.1.1. DBMS_ALERT programs
creating : 3.2.1. Getting Started with DBMS_ALERT
examples : 3.2.3. DBMS_ALERT Examples
exceptions : 3.2.1.1. DBMS_ALERT programs
multiple consumers and : 5.7.8. Working with Multiple Consumers
Oracle Parallel Server and : 3.2.2.4. The DBMS_ALERT.SET_DEFAULTS procedure
privileges : 3.2.1. Getting Started with DBMS_ALERT
programs contained in : 3.2.1.1. DBMS_ALERT programs
transactional behavior : 3.2.3. DBMS_ALERT Examples
DBMS_APPLICATION_INFO package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
7. Defining an Application Profile
7.1.1. DBMS_APPLICATION_INFO Programs
creating : 7.1. Getting Started with DBMS_APPLICATION_INFO
distinguishing users with : 7.3.8. Session Monitoring and Three-Tier Architectures
encapsulating : 7.3.6. Covering DBMS_APPLICATION_INFO
examples of use : 7.3. DBMS_APPLICATION_INFO Examples
exceptions : 7.1.1. DBMS_APPLICATION_INFO Programs
performance analysis with
7. Defining an Application Profile
7.3. DBMS_APPLICATION_INFO Examples
7.3.7. Monitoring Application SQL Resource Consumption
7.3.8. Session Monitoring and Three-Tier Architectures
privileges : 7.1. Getting Started with DBMS_APPLICATION_INFO
programs contained in : 7.1.1. DBMS_APPLICATION_INFO Programs
V$ elements used : 7.1.2. The V$ Virtual Tables
DBMS_AQ package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
5. Oracle Advanced Queuing
5.4. DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only)
creating : 5.2.1. Installing the Oracle AQ Facility
exceptions
5.3.9. Oracle AQ Exceptions
5.4.2.6. Dequeuing with message grouping
privileges : 5.2.1. Installing the Oracle AQ Facility
programs contained in : 5.4. DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only)
roles : 5.4. DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only)
DBMS_AQADM package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
5. Oracle Advanced Queuing
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)
creating : 5.2.1. Installing the Oracle AQ Facility
exceptions
5.3.9. Oracle AQ Exceptions
5.5.3.1. The DBMS_AQADM.ADD_SUBSCRIBER procedure
privileges : 5.2.1. Installing the Oracle AQ Facility
programs contained in : 5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)
roles : 5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)
subscribers and : 5.5.3. Managing Queue Subscribers
DBMS_CRYPTO_TOOLKIT package : 10.4. DBMS_RANDOM: Generating Random Numbers (Oracle8 Only)
DBMS_DDL package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
10.3. DBMS_DDL: Compiling and Analyzing Objects
10.3.1.1. DBMS_DDL programs
commitment and : 10.3.1. Getting Started with DBMS_DDL
creating : 10.3.1. Getting Started with DBMS_DDL
exceptions : 10.3.1.1. DBMS_DDL programs
privileges : 10.3.1. Getting Started with DBMS_DDL
programs contained in : 10.3.1.1. DBMS_DDL programs
DBMS_DEFER package
(see also deferred transactions; specific program names)
1.2. Built-in Packages Covered in This Book
17.3. DBMS_DEFER: Building Deferred Calls
17.3.1.1. DBMS_DEFER programs
creating : 17.3.1. Getting Started with DBMS_DEFER
exceptions : 17.3.1.2. DBMS_DEFER exceptions
privileges : 17.3. DBMS_DEFER: Building Deferred Calls
programs contained in : 17.3.1.1. DBMS_DEFER programs
DBMS_DEFER_QUERY package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
17.4. DBMS_DEFER_QUERY: Performing Diagnostics and Maintenance
17.4.1.1. DBMS_DEFER_QUERY programs
creating : 17.4.1. Getting Started with DBMS_DEFER_QUERY
exceptions : 17.4.1.1. DBMS_DEFER_QUERY programs
privileges : 17.4.1. Getting Started with DBMS_DEFER_QUERY
programs contained in : 17.4.1.1. DBMS_DEFER_QUERY programs
DBMS_DEFER_SYS package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
17.2. DBMS_DEFER_SYS: Managing Deferred Transactions
17.2.1.1. DBMS_DEFER_SYS programs
creating : 17.2.1. Getting Started with DBMS_DEFER_SYS
exceptions : 17.2.1.2. DBMS_DEFER_SYS exceptions
privileges : 17.2.1. Getting Started with DBMS_DEFER_SYS
programs contained in : 17.2.1.1. DBMS_DEFER_SYS programs
DBMS_DESCRIBE package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
10.2. DBMS_DESCRIBE: Describing PL/SQL Program Headers
10.2.1.1. DBMS_DESCRIBE program
creating : 10.2.1. Getting Started with DBMS_DESCRIBE
example
10.2.3. DBMS_DESCRIBE Example
10.2.2. Explaining DBMS_DESCRIBE Results
exceptions : 10.2.1.4. Exceptions
level, meaning of : 10.2.2.2. The DESCRIBE level
overloading : 10.2.2.3. How overloading is handled
privileges : 10.2.1. Getting Started with DBMS_DESCRIBE
program name syntax : 10.2.2.1. Specifying a program name
programs contained in : 10.2.1.1. DBMS_DESCRIBE program
programs within packages and : 10.2.3.2. Using psdesc.args as a quality assurance tool
quality assurance using psdesc package : 10.2.3.2. Using psdesc.args as a quality assurance tool
DBMS_IJOB package : 13.3.3. DBMS_IJOB: Managing Other Users' Jobs
DBMS_JOB package
(see also job queue; job scheduling; specific program names)
1.2. Built-in Packages Covered in This Book
13. Job Scheduling in the Database
13.1.1. DBMS_JOB Programs
analyzing table space : 13.4.1. Tracking Space in Tablespaces
creating : 13.1. Getting Started with DBMS_ JOB
exceptions : 13.1.1. DBMS_JOB Programs
privileges : 13.1. Getting Started with DBMS_ JOB
programs contained in : 13.1.1. DBMS_JOB Programs
DBMS_LOB package
(see also LOBs; specific program names)
1.2. Built-in Packages Covered in This Book
8. Managing Large Objects
creating : 8.1. Getting Started with DBMS_LOB
examples, introduction to : 8.1.4. About the Examples
exceptions : 8.1.2. DBMS_LOB Exceptions
handling of : 8.1.4. About the Examples
privileges : 8.1. Getting Started with DBMS_LOB
programs contained in : 8.1.1. DBMS_LOB Programs
DBMS_LOCK package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
4.1. DBMS_LOCK: Creating and Managing Resource Locks
4.1.1.1. DBMS_LOCK programs
alert signaling and : 3.2.2.5. The DBMS_ALERT.SIGNAL procedure
creating : 4.1.1. Getting Started with DBMS_LOCK
examples : 4.1.4. DBMS_LOCK Examples
exceptions : 4.1.1.1. DBMS_LOCK programs
privileges : 4.1.1. Getting Started with DBMS_LOCK
programs contained in : 4.1.1.1. DBMS_LOCK programs
serializing locks : 4.1. DBMS_LOCK: Creating and Managing Resource Locks
tips on using : 4.1.3. Tips on Using DBMS_LOCK
DBMS_OFFLINE_OG package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
15.4. DBMS_OFFLINE_OG: Performing Site Instantiation
15.4.1. Getting Started with DBMS_OFFLINE_OG
creating : 15.4.1. Getting Started with DBMS_OFFLINE_OG
exceptions : (see specific program names)
privileges : 15.4.1. Getting Started with DBMS_OFFLINE_OG
programs contained in : 15.4.1. Getting Started with DBMS_OFFLINE_OG
DBMS_OFFLINE_SNAPSHOT package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
14.3. DBMS_OFFLINE_SNAPSHOT: Performing Offline Snapshot Instantiation
14.3.1.1. DBMS_OFFLINE_SNAPSHOT programs
creating : 14.3.1. Getting Started with DBMS_OFFLINE_SNAPSHOT
exceptions : 14.3.1.2. DBMS_OFFLINE_SNAPSHOT exceptions
privileges : 14.3.1. Getting Started with DBMS_OFFLINE_SNAPSHOT
programs contained in : 14.3.1.1. DBMS_OFFLINE_SNAPSHOT programs
DBMS_OUTPUT package
(see also output generation; specific program names)
1.2. Built-in Packages Covered in This Book
6.1. DBMS_OUTPUT: Displaying Output
6.1.1.1. DBMS_OUTPUT programs
buffer size : 6.1.2.1. The DBMS_OUTPUT.ENABLE procedure
concepts : 6.1.1.2. DBMS_OUTPUT concepts
creating : 6.1.1. Getting Started with DBMS_OUTPUT
data structures : 6.1.1.4. DBMS_OUTPUT nonprogram elements
datatypes supported : 6.1.1.2. DBMS_OUTPUT concepts
drawbacks : 6.1.1.5. Drawbacks of DBMS_OUTPUT
encapsulating : 6.1.6.1. Encapsulating DBMS_OUTPUT
example : 6.1.6. DBMS_OUTPUT Examples
exceptions : 6.1.1.3. DBMS_OUTPUT exceptions
unhandled exceptions : 6.1.5. Tips on Using DBMS_OUTPUT
privileges : 6.1.1. Getting Started with DBMS_OUTPUT
programs contained in : 6.1.1.1. DBMS_OUTPUT programs
tips for using : 6.1.5. Tips on Using DBMS_OUTPUT
DBMS_PIPE package
(see also message buffers; messages (pipes); pipes; specific program names)
1.2. Built-in Packages Covered in This Book
3.1. DBMS_PIPE: Communicating Between Sessions
3.1.1.1. DBMS_PIPE programs
applications of : 3.1. DBMS_PIPE: Communicating Between Sessions
creating : 3.1.1. Getting Started with DBMS_PIPE
examples : 3.1.7. DBMS_PIPE Examples
exceptions : 3.1.1.1. DBMS_PIPE programs
external services and : 3.1.7.1. Communicating with the outside world
logging and : 3.1.7.4. Implementing a server program
nontransactional behavior : 3.1.2.2. Nontransactional communications
PL/SQL server implementation using : 3.1.7.4. Implementing a server program
privileges : 3.1.1. Getting Started with DBMS_PIPE
programs contained in : 3.1.1.1. DBMS_PIPE programs
sending/receiving relationship : 3.1.7.3. The dbpipe utility package
tips on using : 3.1.6. Tips on Using DBMS_PIPE
DBMS_RANDOM package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
10.4. DBMS_RANDOM: Generating Random Numbers (Oracle8 Only)
10.4.1. Getting Started with DBMS_RANDOM
creating : 10.4.1. Getting Started with DBMS_RANDOM
exceptions : 10.4.1. Getting Started with DBMS_RANDOM
privileges : 10.4.1. Getting Started with DBMS_RANDOM
programs contained in : 10.4.1. Getting Started with DBMS_RANDOM
DBMS_RECTIFIER_DIFF package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
15.5. DBMS_RECTIFIER_DIFF: Comparing Replicated Tables
15.5.1. Getting Started with DBMS_RECTIFIER_DIFF
creating : 15.5.1. Getting Started with DBMS_RECTIFIER_DIFF
exceptions : (see specific program names)
privileges : 15.5.1. Getting Started with DBMS_RECTIFIER_DIFF
programs contained in : 15.5.1. Getting Started with DBMS_RECTIFIER_DIFF
DBMS_REFRESH package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
14.2. DBMS_REFRESH: Managing Snapshot Groups
14.2.1. Getting Started with DBMS_REFRESH
creating : 14.2.1. Getting Started with DBMS_REFRESH
exceptions : 14.2.1. Getting Started with DBMS_REFRESH
privileges : 14.2.1. Getting Started with DBMS_REFRESH
programs contained in : 14.2.1. Getting Started with DBMS_REFRESH
DBMS_REPCAT package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
14.4. DBMS_REPCAT: Managing Snapshot Replication Groups
15.3.1. Getting Started with DBMS_REPCAT
15.3.1.1. DBMS_REPCAT programs
16. Conflict Resolution
creating
14.4.1. Getting Started with DBMS_REPCAT
15.3.1. Getting Started with DBMS_REPCAT
16.1. Getting Started with DBMS_REPCAT
data dictionary views : 16.1.4. Data Dictionary Views
exceptions
14.4.1.2. DBMS_REPCAT exceptions
15.3.1.2. Exceptions
16.1.2. DBMS-REPCAT Exceptions
privileges
14.4.1. Getting Started with DBMS_REPCAT
15.3.1. Getting Started with DBMS_REPCAT
16.1. Getting Started with DBMS_REPCAT
programs contained in
14.4.1.1. DBMS_REPCAT programs
15.3.1.1. DBMS_REPCAT programs
16.1.1. DBMS_REPCAT Programs
DBMS_REPCAT_ADMIN package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
15.2. DBMS_REPCAT_ADMIN: Setting Up More Administrator Accounts
15.2.1.1. DBMS_REPCAT_ADMIN programs
creating : 15.2.1. Getting Started with DBMS_REPCAT_ADMIN
exceptions : 15.2.1.2. DBMS_REPCAT_ADMIN exceptions
privileges : 15.2.1. Getting Started with DBMS_REPCAT_ADMIN
programs contained in : 15.2.1.1. DBMS_REPCAT_ADMIN programs
DBMS_REPCAT_AUTH package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
15.1.1. Getting Started with DBMS_REPCAT_AUTH
15.1.1.1. DBMS_REPCAT_AUTH programs
creating : 15.1.1. Getting Started with DBMS_REPCAT_AUTH
exceptions : 15.1.1.2. DBMS_REPCAT_AUTH exceptions
privileges : 15.1.1. Getting Started with DBMS_REPCAT_AUTH
programs contained in : 15.1.1.1. DBMS_REPCAT_AUTH programs
DBMS_REPUTIL package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
15.6. DBMS_REPUTIL: Enabling and Disabling Replication
15.6.1. Getting Started with DBMS_REPUTIL
programs contained in : 15.6.1. Getting Started with DBMS_REPUTIL
DBMS_ROWID package
(see also ROWIDs; specific program names)
1.2. Built-in Packages Covered in This Book
9.1. DBMS_ROWID: Working with the ROWID Pseudo-Column (Oracle8 only)
9.1.1.1. DBMS_ROWID programs
creating : 9.1.1. Getting Started with DBMS_ROWID
data structures : 9.1.1.3. DBMS_ROWID nonprogram elements
exceptions : 9.1.1.2. DBMS_ROWID exceptions
privileges : 9.1.1. Getting Started with DBMS_ROWID
programs contained in : 9.1.1.1. DBMS_ROWID programs
DBMS_SESSION package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
11.1. DBMS_SESSION: Managing Session Information
11.1.1.1. DBMS_SESSION programs
creating : 11.1.1. Getting Started with DBMS_SESSION
enhancing : 11.1.5.1. Adding value to DBMS_SESSION
exceptions : 11.1.1.1. DBMS_SESSION programs
privileges : 11.1.1. Getting Started with DBMS_SESSION
program use : 11.1.5. DBMS_SESSION Examples
programs contained in : 11.1.1.1. DBMS_SESSION programs
DBMS_SHARED_POOL package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
12.2. DBMS_SHARED_POOL: Pinning Objects
12.2.1. Getting Started with DBMS_SHARED_POOL
creating : 12.2.1. Getting Started with DBMS_SHARED_POOL
examples : 12.2.4. DBMS_SHARED_POOL Examples
exceptions : 12.2.1. Getting Started with DBMS_SHARED_POOL
privileges : 12.2.1. Getting Started with DBMS_SHARED_POOL
programs contained in : 12.2.1. Getting Started with DBMS_SHARED_POOL
DBMS_SNAPSHOT package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
14.1. DBMS_SNAPSHOT: Managing Snapshots
14.1.1. Getting Started with DBMS_SNAPSHOT
creating : 14.1.1. Getting Started with DBMS_SNAPSHOT
exceptions : 14.1.2. Using the I_AM_A_REFRESH Package State Variable
privileges : 14.1.1. Getting Started with DBMS_SNAPSHOT
programs contained in : 14.1.1. Getting Started with DBMS_SNAPSHOT
DBMS_SPACE package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
12.1. DBMS_SPACE: Obtaining Space Information
12.1.1. Getting Started with DBMS_SPACE
creating : 12.1.1. Getting Started with DBMS_SPACE
encapsulating : 12.1.3. DBMS_SPACE Examples
exceptions : 12.1.1. Getting Started with DBMS_SPACE
privileges : 12.1.1. Getting Started with DBMS_SPACE
programs contained in : 12.1.1. Getting Started with DBMS_SPACE
DBMS_SQL package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
2. Executing Dynamic SQL and PL/SQL
2.2.3. DBMS_SQL Programs
array processing with : 2.5.6. Array Processing with DBMS_SQL
creating : 2.2.1. Creating the DBMS_SQL Package
DDL statement execution
2. Executing Dynamic SQL and PL/SQL
2.4.7. Executing DDL in PL/SQL
binding versus concatenation : 2.3.4. Binding Values into Dynamic SQL
examples : 2.5. DBMS_SQL Examples
array processing : 2.5.6. Array Processing with DBMS_SQL
displaying table contents with Method 4 dynamic SQL : 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL
encapsulating DESCRIBE_COLUMNS : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS
generic drop_object procedure : 2.5.1. A Generic Drop_Object Procedure
generic foreign key lookup : 2.5.2. A Generic Foreign Key Lookup Function
indirect referencing : 2.5.5. Indirect Referencing in PL/SQL
RETURNING clause, use of : 2.5.7. Using the RETURNING Clause in Dynamic SQL
exceptions : 2.2.5. DBMS_SQL Exceptions
nested variable restrictions : 2.4.1. Some Restrictions
objects, restrictions on : 2.4.1. Some Restrictions
Oracle8 datatype restrictions : 2.4.1. Some Restrictions
performance improvement using : 2.4.5. Improving the Performance of Dynamic SQL
privileges
2.2.1. Creating the DBMS_SQL Package
2.4.2. Privileges and Execution Authority with DBMS_SQL
processing flow : 2.3.1. Processing Flow of Dynamic SQL
programs contained in : 2.2.3. DBMS_SQL Programs
SQL statements, language version in parsing : 2.2.6. DBMS_SQL Nonprogram Elements
variable arrays : 2.4.1. Some Restrictions
DBMS_STANDARD package : 1.4.2. The DBMS_STANDARD Package
DBMS_SYSTEM package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
11.2. DBMS_System: Setting Events for Debugging
11.2.1. Getting Started with DBMS_SYSTEM
creating : 11.2.1. Getting Started with DBMS_SYSTEM
encapsulating : 11.2.3. DBMS_SYSTEM Examples
exceptions : 11.2.1. Getting Started with DBMS_SYSTEM
privileges : 11.2.1. Getting Started with DBMS_SYSTEM
programs contained in : 11.2.1. Getting Started with DBMS_SYSTEM
DBMS_TRANSACTION package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
4.2. DBMS_TRANSACTION: Interfacing to SQL Transaction Statements
4.2.1.1. DBMS_TRANSACTION programs
commitment : 4.2.3. Committing Data
creating : 4.2.1. Getting Started with DBMS_TRANSACTION
exceptions in : 4.2.1.2. DBMS_TRANSACTION exceptions
privileges : 4.2.1. Getting Started with DBMS_TRANSACTION
programs contained in : 4.2.1.1. DBMS_TRANSACTION programs
rollback : 4.2.4. Rolling Back Changes
transaction characteristics : 4.2.5. Setting Transaction Characteristics
DBMS_UTILITY package
(see also specific program names)
1.2. Built-in Packages Covered in This Book
10.1. DBMS_UTILITY: Performing Miscellaneous Operations
10.1.1. Getting Started with DBMS_UTILITY
creating : 10.1.1. Getting Started with DBMS_UTILITY
privileges : 10.1.1. Getting Started with DBMS_UTILITY
programs contained in : 10.1.1. Getting Started with DBMS_UTILITY
tables used by : 10.1.1.1. DBMS_UTILITY nonprogram elements
dbmsalrt.sql script
3.2.1. Getting Started with DBMS_ALERT
3.2.3. DBMS_ALERT Examples
dbmsapin.sql script : 7.1. Getting Started with DBMS_APPLICATION_INFO
dbmsdefr.sql script
17.2.1. Getting Started with DBMS_DEFER_SYS
17.3.1. Getting Started with DBMS_DEFER
17.4.1. Getting Started with DBMS_DEFER_QUERY
dbmsdesc.sql script
10.2.1. Getting Started with DBMS_DESCRIBE
10.3.1. Getting Started with DBMS_DDL
dbmsgen.sql script : 15.6.1. Getting Started with DBMS_REPUTIL
dbmsjob.sql script : 13.1. Getting Started with DBMS_ JOB
dbmslob.sql script : 8.1. Getting Started with DBMS_LOB
dbmslock.sql script : 4.1.1. Getting Started with DBMS_LOCK
dbmsoctk.sql script : 10.4.1. Getting Started with DBMS_RANDOM
dbmsofln.sql script
14.3.1. Getting Started with DBMS_OFFLINE_SNAPSHOT
15.4.1. Getting Started with DBMS_OFFLINE_OG
dbmsoutp.sql script : 6.1.1. Getting Started with DBMS_OUTPUT
dbmspipe.sql script : 3.1.1. Getting Started with DBMS_PIPE
dbmspool.sql script : 12.2.1. Getting Started with DBMS_SHARED_POOL
dbmsrand.sql script : 10.4.1. Getting Started with DBMS_RANDOM
dbmsrepc.sql script
14.4.1. Getting Started with DBMS_REPCAT
15.1.1. Getting Started with DBMS_REPCAT_AUTH
15.2.1. Getting Started with DBMS_REPCAT_ADMIN
15.3.1. Getting Started with DBMS_REPCAT
15.5.1. Getting Started with DBMS_RECTIFIER_DIFF
16.1. Getting Started with DBMS_REPCAT
dbmssnap.sql script
14.1.1. Getting Started with DBMS_SNAPSHOT
14.2.1. Getting Started with DBMS_REFRESH
dbmssql.sql script : 2.2.1. Creating the DBMS_SQL Package
dbmsstdx.sql file : 1.4.2. The DBMS_STANDARD Package
dbmsutil.sql script
1.4. Examining Built-in Package Source Code
11.2.1. Getting Started with DBMS_SYSTEM
dbparm package
(see also specific program names)
1.3.5.1. Examples of encapsulation packages
10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function
dbparm.spp : 10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function
dbpipe package
(see also specific program names)
1.3.5.1. Examples of encapsulation packages
3.1.7.3. The dbpipe utility package
dbpipe.sql
3.1.7.3. The dbpipe utility package
3.1.3.1. The DBMS_PIPE.CREATE_PIPE function
3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function
3.1.3.4. The DBMS_PIPE.PURGE procedure
dbstart script : 12.2.4.1. Pinning packages automatically
dbver.spp : 10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure
DDL statements
commitment and : 10.3.1. Getting Started with DBMS_DDL
deferred parsing and : 2.3.4. Binding Values into Dynamic SQL
executing
2. Executing Dynamic SQL and PL/SQL
2.4.7. Executing DDL in PL/SQL
10.1.2.9. The DBMS_UTILITY.EXEC_DDL_STATEMENT procedure
at replicated sites : 15.3.3.4. The DBMS_REPCAT.EXECUTE_DDL procedure
binding versus concatenation : 2.3.4. Binding Values into Dynamic SQL
locking and : 2.4.7. Executing DDL in PL/SQL
privileges and : 2.4.7. Executing DDL in PL/SQL
deadlocks, notification of : 4.1.2.2. The DBMS_LOCK.REQUEST function
debug procedure : 3.1.7.5. The pipesvr package
debugging
(see also tracing; troubleshooting)
2.3.10.3. The DBMS_SQL.LAST_ROW_ID function
DBMS_OUTPUT used for : 6.1. DBMS_OUTPUT: Displaying Output
DBMS_PIPE used for
3.1. DBMS_PIPE: Communicating Between Sessions
3.1.2.2. Nontransactional communications
3.1.7.4. Implementing a server program
last row fetched and : 2.3.10.3. The DBMS_SQL.LAST_ROW_ID function
DEFCALL view : 17.1.2. Data Dictionary Views
defcall.sql : 17.3.2.2. The DBMS_DEFER.CALL procedure
DEFCALLDEST view : 17.1.2. Data Dictionary Views
defcdest.sql : 17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure
DEFDEFAULTDEST view : 17.1.2. Data Dictionary Views
deferred execution : 5. Oracle Advanced Queuing
deferred parsing : 2.3.3.1. The DBMS_SQL.PARSE procedure
DDL statements and : 2.3.4. Binding Values into Dynamic SQL
deferred transactions
(see also RPCs)
17.1.1. About Remote Destinations
17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure
commiting
17.2.4.5. The DBMS_DEFER_SYS.SET_DISABLED procedure
17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure
17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure
data dictionary views for : 17.1.2. Data Dictionary Views
database links and : 17.2.2.1. The DBMS_DEFER.SYS.ADD_DEFAULT_DEST procedure
error handling : 17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure
executing : 17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure
failed transactions
deleting : 17.2.4.1. The DBMS_DEFER_SYS.DELETE_ERROR procedure
executing : 17.2.4.4. The DBMS_DEFER_SYS.EXECUTE_ERROR procedure
named transactions, deleting : 17.2.4.2. The DBMS_DEFER_SYS.DELETE_TRAN procedure
Oracle8 propagation scheduling : 17.2.6. Scheduling Propagation (Oracle8 only)
parameterized RPCs : 17.3.3. Parameterized RPCs
parameterless RPCs : 17.3.2. Basic RPCs
propagation : (see propagating transactions)
rate and volume control : 17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure
replication triggers and : 17. Deferred Transactions and Remote Procedure Calls
roles and : 17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure
scheduling : 17.2.5.3. The DBMS_DEFER_SYS.SCHEDULE_EXECUTION procedure
INIT.ORA and : 17.2.5.1. Scheduling strategies
specifying remote destinations : 17.3.2.1. The DBMS_DEFER.TRANSACTION procedure
stopping execution : 17.2.5.4. The DBMS_DEFER_SYS.UNSCHEDULE_EXECUTION procedure
testing if deferred transactions disabled : 17.2.4.3. The DBMS_DEFER_SYS.DISABLED function
DEFERROR view : 17.1.2. Data Dictionary Views
DEFERRORCOUNT view : 17.1.2. Data Dictionary Views
DEFINE_ARRAY procedure
2.2.3. DBMS_SQL Programs
2.3.5.2. The DBMS_SQL.DEFINE_ARRAY procedure
index-by tables used by : 2.2.6. DBMS_SQL Nonprogram Elements
multiple-row COLUMN_VALUE requires : 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
DEFINE_COLUMN procedure
2.2.3. DBMS_SQL Programs
2.3.5.1. The DBMS_SQL.DEFINE_COLUMN procedure
Method 4 dynamic SQL and : 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL
single-row COLUMN_VALUE requires : 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
tips about : 2.5.4.5. Defining the cursor structure
DEFINE_COLUMN_CHAR procedure : 2.3.5.1. The DBMS_SQL.DEFINE_COLUMN procedure
DEFINE_COLUMN_GROUP procedure
16.1.1. DBMS_REPCAT Programs
16.2.2.1. The DBMS_REPCAT.DEFINE_COLUMN_GROUP procedure
DEFINE_COLUMN_LONG procedure : 2.2.3. DBMS_SQL Programs
DEFINE_COLUMN_RAW procedure : 2.3.5.1. The DBMS_SQL.DEFINE_COLUMN procedure
DEFINE_COLUMN_ROWID procedure : 2.3.5.1. The DBMS_SQL.DEFINE_COLUMN procedure
DEFINE_PRIORITY_GROUP procedure
16.1.1. DBMS_REPCAT Programs
16.3.2.1. The DBMS_REPCAT.DEFINE_PRIORITY_GROUP procedure
DEFINE_SITE_PRIORITY procedure
16.1.1. DBMS_REPCAT Programs
16.4.2.1. The DBMS_REPCAT.DEFINE_SITE_PRIORITY procedure
defsched.sql : 17.2.5.3. The DBMS_DEFER_SYS.SCHEDULE_EXECUTION procedure
DEFSCHEDULE view : 17.1.2. Data Dictionary Views
deftdest.sql : 17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure
DEFTRAN view : 17.1.2. Data Dictionary Views
DEFTRANDEST view : 17.1.2. Data Dictionary Views
delete conflicts
16. Conflict Resolution
16.5.1. About Resolution Methods
DELETE statements, multiple-row deletes
2.5.6.2. Using array processing to delete
2.5.7.2. RETURNING from a multiple-row delete
DELETE_DEFAULT_DEST procedure
17.2.1.1. DBMS_DEFER_SYS programs
17.2.2.2. The DBMS_DEFER.SYS.DELETE_DEFAULT_DEST procedure
DELETE_ERROR procedure
17.2.1.1. DBMS_DEFER_SYS programs
17.2.4.1. The DBMS_DEFER_SYS.DELETE_ERROR procedure
DELETE_OBJECT procedure : 9.2.5.1. The UTL_REF.DELETE_OBJECT procedure
DELETE_TRAN procedure
17.2.1.1. DBMS_DEFER_SYS programs
17.2.4.2. The DBMS_DEFER_SYS.DELETE_TRAN procedure
delret.sp : 2.5.7.2. RETURNING from a multiple-row delete
demohash procedure : 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function
dequeue options record type : 5.3.8. Dequeue Options Record Type
dequeue procedure
5.7.2. Working with Prioritized Queues
5.7.4. Browsing a Queue's Contents
DEQUEUE procedure
5.4. DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only)
5.4.2.1. The DBMS_AQ.DEQUEUE procedure
dequeuing : 5.4.2.1. The DBMS_AQ.DEQUEUE procedure
AQ features for : 5.1.3. Dequeue Features
consistency and : 5.4.2.5. Dequeue navigation
correlation identifiers : 5.3.8. Dequeue Options Record Type
example : 5.7.5. Searching by Correlation Identifier
delaying : 5.3.6. Message Properties Record Type
identifying messages : 5.3.8. Dequeue Options Record Type
locking and : 5.3.8. Dequeue Options Record Type
message grouping and : 5.4.2.6. Dequeuing with message grouping
message retrieved next : 5.3.8. Dequeue Options Record Type
modifying dequeuing properties (example) : 5.4.2.2. Examples
navigation
5.3.8. Dequeue Options Record Type
5.4.2.5. Dequeue navigation
number of attempts : 5.3.6. Message Properties Record Type
processing sequence
5.3.7. Enqueue Options Record Type
5.4.2.4. Dequeue order
search criteria : 5.4.2.3. Dequeue search criteria
transactions and
5.1.3. Dequeue Features
5.3.8. Dequeue Options Record Type
waiting for messages : 5.3.8. Dequeue Options Record Type
DESC_T table
describing columns and : 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure
encapsulating : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS
desccols package
(see also specific program names)
1.3.5.1. Examples of encapsulation packages
2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS
desccols.spp : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS
desccols.tst : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS
DESCRIBE level : 10.2.2.2. The DESCRIBE level
DESCRIBE_COLUMNS procedure
2.2.3. DBMS_SQL Programs
2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure
declarations needed for : 2.2.6. DBMS_SQL Nonprogram Elements
encapsulating : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS
DESCRIBE_PROCEDURE procedure
(see also DBMS_DESCRIBE package)
10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure
desctest package
(see also specific program names)
10.2.3.2. Using psdesc.args as a quality assurance tool
DESTROY procedure
14.2.1. Getting Started with DBMS_REFRESH
14.2.2.2. The DBMS_REFRESH.DESTROY procedure
dicing byte strings : 9.2.2.2. Slicing and dicing
DIFFERENCES procedure : 15.5.2.1. The DBMS_RECTIFIER.DIFFERENCES procedure
directories, aliases for : 8.2.2.1. The DIRECTORY object
DISABLE procedure
6.1.1.1. DBMS_OUTPUT programs
6.1.2.2. The DBMS_OUTPUT.DISABLE procedure
DISABLED function
17.2.1.1. DBMS_DEFER_SYS programs
17.2.4.3. The DBMS_DEFER_SYS.DISABLED function
discrete transactions : 4.2.5.3. The DBMS_TRANSACTION.BEGIN_DISCRETE_TRANSACTION procedure
disk accompanying book : A. What's on the Companion Disk?
displaying output : (see output generation)
distributed databases
in-doubt transactions : (see in-doubt transactions)
releasing locks and : 4.1.2.2. The DBMS_LOCK.REQUEST function
distributed transactions : (see deferred transactions; distributed databases)
DML statements
propagating to remote sites : 15.3.4. Replication Support with DBMS_REPCAT
propagating to replicated tables : 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function
do package : 6.1.6.1. Encapsulating DBMS_OUTPUT
DO_DEFERRED_REPCAT_ADMIN procedure
15.3.1.1. DBMS_REPCAT programs
15.3.6.1. The DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN procedure
dot notation
parsing
2.5.4.3. Constructing the SELECT
10.1.2.18. The DBMS_UTILITY.NAME_TOKENIZE procedure
referencing package elements : 1.3.3. Referencing Built-in Package Elements
DROP_<conflicttype>_RESOLUTION
16.1.1. DBMS_REPCAT Programs
16.5.1.2. The DBMS_REPCAT.DROP_<conflicttype>_RESOLUTION procedure
DROP_COLUMN_GROUP procedure
16.1.1. DBMS_REPCAT Programs
16.2.2.2. The DBMS_REPCAT.DROP_COLUMN_GROUP procedure
DROP_DELETE_RESOLUTION procedure : 16.5.1.2. The DBMS_REPCAT.DROP_<conflicttype>_RESOLUTION procedure
DROP_GROUPED_COLUMN procedure
16.1.1. DBMS_REPCAT Programs
16.2.3.2. The DBMS_REPCAT.DROP_GROUPED_COLUMN procedure
DROP_MASTER_REPGROUP procedure
15.3.1.1. DBMS_REPCAT programs
15.3.2.2. The DBMS_REPCAT.DROP_MASTER_REPGROUP procedure
DROP_MASTER_REPOBJECT procedure
15.3.1.1. DBMS_REPCAT programs
15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure
drop_object procedure : 2.5.1. A Generic Drop_Object Procedure
DROP_PRIORITY procedure
16.1.1. DBMS_REPCAT Programs
16.3.4.1. The DBMS_REPCAT.DROP_PRIORITY procedure
DROP_PRIORITY_<datatype> procedure
16.1.1. DBMS_REPCAT Programs
16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure
DROP_PRIORITY_GROUP procedure
16.1.1. DBMS_REPCAT Programs
16.3.2.2. The DBMS_REPCAT.DROP_PRIORITY_GROUP procedure
DROP_QUEUE procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)
5.5.4.2. The DBMS_AQADM.DROP_QUEUE procedure
DROP_QUEUE_TABLE procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)
5.5.4.3. The DBMS_AQADM.DROP_QUEUE_TABLE procedure
DROP_SITE_PRIORITY procedure
16.1.1. DBMS_REPCAT Programs
16.4.2.2. The DBMS_REPCAT.DROP_SITE_PRIORITY procedure
DROP_SITE_PRIORITY_SITE procedure
16.1.1. DBMS_REPCAT Programs
16.4.3.2. The DBMS_REPCAT.DROP_SITE_PRIORITY_SITE procedure
DROP_SNAPSHOT_REPGROUP procedure
14.4.1.1. DBMS_REPCAT programs
14.4.2.3. The DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP procedure
DROP_SNAPSHOT_REPOBJECT procedure
14.4.1.1. DBMS_REPCAT programs
14.4.3.2. The DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT procedure
drop_student procedure : 5.7.4. Browsing a Queue's Contents
DROP_UNIQUE_RESOLUTION procedure : 16.5.1.2. The DBMS_REPCAT.DROP_<conflicttype>_RESOLUTION procedure
DROP_UPDATE_RESOLUTION procedure : 16.5.1.2. The DBMS_REPCAT.DROP_<conflicttype>_RESOLUTION procedure
dropobj.sp : 2.5.1. A Generic Drop_Object Procedure
dump_long procedure : 2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure
dumplong.sp : 2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure
dynamic SQL : 2. Executing Dynamic SQL and PL/SQL
blocks
binding host variables and : 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure
index-by tables and : 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure
scope of variables : 2.4.8. Executing Dynamic PL/SQL
syntax for : 2.4.8. Executing Dynamic PL/SQL
cursor variables and : 2.4.1. Some Restrictions
DDL statement execution
2. Executing Dynamic SQL and PL/SQL
2.4.7. Executing DDL in PL/SQL
binding versus concatenation : 2.3.4. Binding Values into Dynamic SQL
Method 4 example : 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL
methods for : 2.2.4. Types of Dynamic SQL
processing flow
2.1. Examples of Dynamic SQL
2.3.1. Processing Flow of Dynamic SQL
RETURNING clause in : 2.5.7. Using the RETURNING Clause in Dynamic SQL
tips on using : 2.4. Tips on Using Dynamic SQL
troubleshooting : 2.4.6. Problem-Solving Dynamic SQL Errors
dynconst package : 1.3.5.1. Examples of encapsulation packages
dynconst.spp : 1.3.6.1. Referencing packaged constants and variables
dyndel.sp : 2.5.6.2. Using array processing to delete
dyndel.tst : 2.5.6.2. Using array processing to delete
dynins.sp : 2.5.6.1. Using array processing to insert
dynins.tst : 2.5.6.1. Using array processing to insert
dynplsql.sp : 2.4.8. Executing Dynamic PL/SQL
dynsql package
(see also specific program names)
2.4.6. Problem-Solving Dynamic SQL Errors
dynsql.spp : 2.4.6. Problem-Solving Dynamic SQL Errors
dynsql_value package : 1.3.6.1. Referencing packaged constants and variables
dynupd.sp : 2.5.6.3. Using array processing to update
dynupd.tst : 2.5.6.3. Using array processing to update
dynvar package
(see also specific program names)
2.5.5. Indirect Referencing in PL/SQL
dynvar.spp : 2.5.5. Indirect Referencing in PL/SQL
dynvar.tst : 2.5.5. Indirect Referencing in PL/SQL


Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X
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