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

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