Index

Book HomeBook HomeSearch this book

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

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference