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.