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

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