Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z

# Index: D

dangling REFs : 18.2.3. Adding Complex Data Structures
data
  abstract datatypes : (see ADTs)
  abstraction : 9.1.3.1. Data abstraction
  combining scalars and aggregates : 17.8.2. Combining Scalar and Aggregate Values
  denormalizing with nested records : 9.7.4. Denormalizing Program Data with Nested Records
  errors by implicit cursors : 6.3.2.2. Vulnerability to data errors
  from packages, performance and : 25.4.4. Use Package Data to Avoid Passing "Bulky" Parameter Values
  global
    (see also global variables)
    16.1.4. Object Persistence
    16.5.2. Global Within a Single Oracle Session
    22.5.4. Avoid Global Variables and Data Structures
    private : 16.5.4. Global Private Data
    public : 16.5.3. Global Public Data
  object model and : 18.1.5.4. Combining data with behavior
  package : 16.5. Package Data
  program : (see variables)
  records : (see records)
  tuning access to : 25.3. Tuning Access to Your Data
  verifying : 24.2.7. Test All Assumptions
data abstraction : 18.1.5.3. Abstraction
data dictionary
  external procedure entries : 21.6.1. Data Dictionary
  for managing collections : 19.8.2. Data Dictionary
  object types entries : 18.6.1. Data Dictionary
  object views entries : 20.7.1. Data Dictionary
data structures, synchronizing : 1.7.2. Synchronize Program and Data Structures
databases
  administration of : About the Contents
  communication between sessions : C.10. DBMS_PIPE
  cursor-based access to : 1.4.3.8. Cursor-based access to the database
  events, receiving notification of : C.2. DBMS_ALERT
  locking records : 6.11. SELECT FOR UPDATE in Cursors
  managing code in : 23. Managing Code in the Database
  structure for objects : 18.2.2.2. DDL usage
  synchroniztion with columns : 4.5.1.1. Synchronization with database columns
  triggers : (see triggers)
  tuning of : About the Contents
datatypes : 4.2. Scalar Datatypes
  abstract
    (see abstract datatypes)
    (see ADTs)
  anchored
    1.6.1. Anchored declarations
    4.5. Anchored Declarations
  collections as : 19.2.2. Collections in PL/SQL
  comverting
    external procedures and : 21.4.1. Datatype Conversion
  constrained/unconstrained : 4.4.1. Constrained Declarations
  converting
    performance and : 25.4.7. Avoid Type Conversions When Possible
  converting between
    4.2.8. Conversion Between Datatypes
    14. Conversion Functions
  declaring in tables
    10.4.1. Defining the Table TYPE
    10.8.1. PL/SQL Tables of Records
  external : 21.4.1. Datatype Conversion
  for LOB variables : 1.4.7.6. Large object support
  for LOBs : 4.2.7. LOB Datatypes
  object : (see object types)
  for overloaded modules : 15.8.4. Restrictions on Overloading
  PL/SQL Version 2.0 : B.2.1. No Server-Side PL/SQL Datatypes
  programmer-defined : (see subtypes)
  standardizing with %TYPE : 4.7.8. Use %TYPE to Standardize Nondatabase Declarations
  of stored functions parameters : 17.3. Requirements for Stored Functions in SQL
date
  12. Date Functions
  14.3.5. Building a Date Manager
  changing millenia : 14.3.3. RR: Changing Millenia
  converting strings to/from
    14.1. Conversion Formats
    14.2.6. The TO_CHAR function (date conversion)
    14.2.8. The TO_DATE function
  DATE datatype : 4.2.5. The Date-Time Datatype
  range : 14.3.4. Using TO_CHAR to Create a Date Range
  system : 12.1.7. The SYSDATE function
DATE datatype : 12. Date Functions
days : (see date)
DB2 data source : 4.2.3.1. The CHAR datatype
dbgextp.sql script : 21.6.2. Rules and Warnings About External Procedures
DBMS_AQ package : C.3. Oracle AQ, the Advanced Queueing Facility
DBMS_AQADM package : C.3.2. DBMS_AQADM (PL/SQL 8 Only)
DBMS_DDL package : C.4. DBMS_DDL
DBMS_DESCRIBE package
  pinning in SGA shared pool : 25.2.2.1. Candidates for pinning in the shared pool
DBMS_JOB package
  C.5. DBMS_ JOB
  1.4.5.3. Job scheduling with DBMS_ JOB
DBMS_LOB package : C.6. DBMS_LOB (PL/SQL8 Only)
DBMS_LOCK package : C.7. DBMS_LOCK
DBMS_MAIL package : C.8. DBMS_MAIL
DBMS_OUTPUT package
  C.9. DBMS_OUTPUT
  10.9.3. Displaying a PL/SQL Table
  26.5. Quick-and-Dirty Tracing
  pinning in SGA shared pool : 25.2.2.1. Candidates for pinning in the shared pool
DBMS_PIPE package : C.10. DBMS_PIPE
DBMS_ROWID package : C.11. DBMS_ROWID (PL/SQL8 Only)
DBMS_SESSION package : C.12. DBMS_SESSION
DBMS_SHARED_POOL package : 25.2.2. Pin Critical Code into the SGA
DBMS_SNAPSHOT package : C.13. DBMS_SNAPSHOT
DBMS_SQL package : C.14. DBMS_SQL
  batch processing : 25.3.4. Take Advantage of DBMS_SQL Batch Processing
DBMS_STANDARD package
  pinning in SGA shared pool : 25.2.2.1. Candidates for pinning in the shared pool
DBMS_TRANSACTION package : C.15. DBMS_TRANSACTION
DBMS_UTILITY package : C.16. DBMS_UTILITY
  GET_TIME Function : 25.1.1. Use the DBMS_UTILITY.GET_TIME Function
  pinning in SGA shared pool : 25.2.2.1. Candidates for pinning in the shared pool
DDL (Data Definition Language)
  DBMS_DDL package for : C.4. DBMS_DDL
  object privileges and : 18.3.7.1. DDL
  statements : 1.4.4.2. Support for DDL and dynamic SQL
debugging
  2.5.2. Multiline Comment Syntax
  24. Debugging PL/SQL
  external procedures : 21.6.2. Rules and Warnings About External Procedures
  finding code by line number : 23.6.6. Finding the Code for a Line Number
  messages about, in packages : 24.2.9. Build Debugging Messages into Your Packages
  strategies for : 24.2. Debugging Tips and Strategies
  tracing PL/SQL execution : 26. Tracing PL/SQL Execution
DEC subtype : 4.2.2. Numeric Subtypes
decimal datatypes
  4.2.1.2. Decimal numeric datatypes
  4.2.2. Numeric Subtypes
DECIMAL subtype : 4.2.2. Numeric Subtypes
declarations
  anchored
    1.6.1. Anchored declarations
    4.5. Anchored Declarations
  commenting : 3.6.5. Comment Declaration Statements
  FOR loop indexes : 1.7.5. Structured Code and Other Best Practices
  formatting : 3.1.5. Formatting Your Declarations
  forward : 15.9. Forward Declarations
  in packages
    16.3. The Package Specification
    16.4.1. Declare in Specification or Body
  of record TYPEs : 9.4.1. Declaring Programmer-Defined Record TYPEs
  of records
    9.2.1. Declaring Records with the %ROWTYPE Attribute
    9.4.2. Declaring the Record
  subtype : 4.6.1. Declaring Subtypes
  of tables : 10.4. Declaring a PL/SQL Table
  unconstrained : 15.6.1. Defining the Parameters
  variable : 4.4. Variable Declarations
declaring
  collection datatypes : 19.3. Syntax for Declaring Collection Datatypes
  cursor variables : 6.12.3. Declaring REF CURSOR Types and Cursor Variables
  cursors : 6.4. Declaring Cursors
  exceptions raised in declarations : 8.5.3. Exceptions Raised in a Declaration
  parameters : 21.4.4. Correct Declaration of Properties
DECODE function
  in MAKE_REF funfction : 20.4.2.3. Working around the ORA-22972 problem
DECODE function, replacing with IF : 17.8.4. Replacing DECODEs with IF Statements
default
  constructor method : 18.3.1. About Object Types
  parameter values
    B.2.4. No Default Parameter Values
    15.6.5. Default Values
    22.7.5. Default Values and Remote Procedure Calls
  records : 9.6.2. Record Initialization
  values for variables : 4.4.3. Default Values
DEFAULT keyword : 4.4.3. Default Values
DEFINE_ARRAY program : 25.3.4. Take Advantage of DBMS_SQL Batch Processing
DEFINE_COLUMN procedure : C.14.5. The DEFINE_COLUMN procedure
definer rights model : 18.3.7.3. Rights model
DELETE procedure : 10.8.2.2. The DELETE procedure
  removing collection elements : 19.4.3.2. Removing elements using DELETE
  THE function with : 19.5.1. The THE Pseudo-function
DELETE statement
  (see also DML statements)
  10.3. PL/SQL Tables and DML Statements
  WHERE CURRENT OF clause : 6.11.2. The WHERE CURRENT OF Clause
deleting
  collection elements : 19.4.3. Adding and Removing Elements
  table rows : 10.8.2.2. The DELETE procedure
deleting tables : 10.7. Clearing the PL/SQL Table
denormalizing program data : 9.7.4. Denormalizing Program Data with Nested Records
dependency management : 23.3. Module Validation and Dependency Management
DEQUEUE procedure : C.3.1.2. The DEQUEUE procedure
DEREF function, virtual REFs and : 20.4.2.4. DEREF: Interpreting a virtual REF
DEREF operator : 18.4.2.4. DEREF
desc command (SQL*Plus), objects and : 18.6.2. SQL*Plus "Describe" Command
Developer/2000 : 18.5.5. Implications for Developer/2000
development
  best practices for : 1.7. Best Practices for PL/SQL Excellence
  packages for : 1.7.3. Center All Development Around Packages
  standarizing environment for : 1.7.4. Standardize Your PL/SQL Development Environment
digits, number of : (see precision)
direct field assignment
  9.5. Assigning Values to and from Records
  10.6.1. Direct Assignment
directories, creating : 4.2.7.7. Working with BFILEs
directory aliases, BFILENAME functions and : 13.2.1. The BFILENAME function
DISABLE procedure : C.9.1. The DISABLE procedure
disk accompanying this book : A. What's on the Companion Disk?
disk space : (see memory)
DMBS_ALERT package : C.2. DBMS_ALERT
DML
  encapsulating in object views : 20.2. INSTEAD OF Triggers
  encapsulating in packages : 18.5.4. Approach 4: Use an Object and a PL/SQL Container Package
  object privileges and : 18.3.7.2. DML
DML statements : 1.4.4.2. Support for DDL and dynamic SQL
  and tables : 10.3. PL/SQL Tables and DML Statements
"do nothing" statement : (see NULL statements)
documentation
  with encrypted code : 23.7.3. Impact of Encrypting Code
  of parameters : 22.7.1. Document All Parameters and Their Functions
  of programming process : 24.2.6. Document and Back Up Your Efforts
documentation, inline : (see comments)
dot notation
  B.2.2. No Direct Stored Package Variable References
  9.1.2. Accessing Record-Based Data
  18.3.4. Dot Notation
  with nested records : 9.7.2. Dot Notation with Nested Records
DOUBLE PRECISION subtype : 4.2.2. Numeric Subtypes
DROP command
  20.3.2. DROP: Dropping Views and Triggers
  21.3.3. DROP: Dropping Libraries
  23.5.3. Changing Stored Objects
DROP TYPE statement : 18.3.2. CREATE TYPE and DROP TYPE: Creating and Dropping Types
DROP_QUEUE procdure : C.3.2.5. The DROP_QUEUE procedure
DROP_QUEUE_TABLE procedure : C.3.2.2. The DROP_QUEUE_TABLE procedure
DROP_SNAPSHOT procedure : C.13.1. The DROP_SNAPSHOT procedure
dropping
  libraries : 21.3.3. DROP: Dropping Libraries
  triggers : 20.3.2. DROP: Dropping Views and Triggers
  views : 20.3.2. DROP: Dropping Views and Triggers
dummy programs : 5.2.2.3. Supporting top-down design of modules
DUMP function : 13.3.1. The DUMP function
DUP_VAL_ON_INDEX exception : 8.3.1. Named System Exceptions
dynamic linking : 21.1.2. Architecture
dynamic SQL
  C.14. DBMS_SQL
  1.4.4.2. Support for DDL and dynamic SQL
  6.2.1. Types of Cursors

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z

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