start page | rating of books | rating of authors | reviews | copyrights
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.