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: A

ABS function : 13.1.1. The ABS function
absolute value : 13.1.1. The ABS function
abstract data types : (see ADTs)
abstraction : 18.1.5.3. Abstraction
access
to compiled code, tuning : 25.2. Tuning Access to Compiled Code
to data, tuning : 25.3. Tuning Access to Your Data
data structure, encapsulating : 1.7.2. Synchronize Program and Data Structures
to SQL, minimizing : 25.3.1. Use Package Data to Minimize SQL Access
ACCESS table, tuning : 25.2.3. Tune ACCESS$ Table to Reduce First Execution Time of Code
actual parameters : 15.6.3. Actual and Formal Parameters
Ada programming language : Preface
ADD_MONTHS function : 12.1.1. The ADD_MONTHS function
customizing : 12.2.1. Customizing the Behavior of ADD_MONTHS
adding collection elements : 19.4.3. Adding and Removing Elements
administration of Oracle databases : About the Contents
administration, Oracle/AQ : C.3.2. DBMS_AQADM (PL/SQL 8 Only)
ADTs (abstract datatypes)
(see also object types)
18.1.4.2. Classification
building : 22.6. Construct Abstract Data Types (ADTs)
advanced queuing : 1.4.7.2. Oracle/AQ, the Advanced Queueing Facility
ADVISE_COMMIT procedure : C.15.1. The ADVISE_COMMIT procedure
ADVISE_NOTHING procedure : C.15.2. The ADVISE_NOTHING procedure
ADVISE_ROLLBACK procedure : C.15.3. The ADVISE_ROLLBACK procedure
aggregate
assignment into rows : 10.6.3. Aggregate Assignment
operations
9.1.3.2. Aggregate operations
9.5.4. Aggregate Assignment
9.6.1.2. Records of the same type
of nested records : 9.7.3. Aggregate Assignments of Nested Records
values, combining with scalars : 17.8.2. Combining Scalar and Aggregate Values
aggregation : 18.1.4.3. Inheritance
alerts : (see DBMS_ALERT package)
algorithms, tuning : 25.4. Tuning Your Algorithms
aliases
column
6.7. Column Aliases in Cursors
9.3.2. Setting the Record's Column Names
directory : 13.2.1. The BFILENAME function
for cursor variables : 6.12.6.3. Cursor variable aliases
alignment of code : (see coding, layout of)
ALLOCATE_UNIQUE procedure : C.7.1. The ALLOCATE_UNIQUE procedure
ALTER SESSION command : 26.1.1. Enabling Program Units for Tracing
ALTER TABLE statement : 20.6. Schema Evolution
ALTER_COMPILE procedure : C.4.1. The ALTER_COMPILE procedure
ALTER_QUEUE procedure : C.3.2.4. The ALTER_QUEUE procedure
ANALYZE statement : 25.1. Analyzing Program Performance
ANALYZE_OBJECT procedure : C.4.2. The ANALYZE_OBJECT procedure
ANALYZE_SCHEMA procedure : C.16.1. The ANALYZE_SCHEMA procedure
anchored datatypes
1.6.1. Anchored declarations
4.5. Anchored Declarations
anchoring to subtypes : 4.6.3. Emulating Constrained Subtypes
angle brackets (>) as label delimiters : 5.2.1. The GOTO Statement
anonymous blocks : 15.3. The Anonymous PL/SQL Block
labels for : 15.3.6. Block Labels
nested : 15.3.4. Nested Blocks
in Oracle Tools : 15.3.3. Anonymous Blocks in the Oracle Tools
APPEND procedure : C.6.1. The APPEND procedure
applications, tuning : 25. Tuning PL/SQL Applications
access to compiled code : 25.2. Tuning Access to Compiled Code
access to data : 25.3. Tuning Access to Your Data
analyzing performance : 25.1. Analyzing Program Performance
optimizing algorithms : 25.4. Tuning Your Algorithms
AQ : (see advanced queuing)
arguments, trapping invalid : 22.2.4.1. Trap invalid argument values
arrays
(see also tables)
1.4.3.4. PL/SQL tables
building with tables : 10.9.4. Building Traditional Arrays with PL/SQL Tables
package for
(see also PSG_array package)
10.9.4.3. Features of the array package
variable arrays : 1.4.7.3. Variable arrays and nested tables
objects for : 18.1.2. Some Simple Examples
variable-size : (see VARRAYs)
ASCII function : 11.1.1. The ASCII function
assertion modules : 22.2.4. Use Assertion Modules to Validate Parameters and Assumptions
assigning objects : 18.4.1.2. Direct assignment
assignment (\:=) operator
2.1. The PL/SQL Character Set
4.4.3. Default Values
9.5. Assigning Values to and from Records
association operator for positional notation (=>) : 2.1. The PL/SQL Character Set
association, object : 18.1.4.3. Inheritance
atomics of PL/SQL language : 2.1. The PL/SQL Character Set
attributes, cursor
6.9. Cursor Attributes
6.12.2. Similarities to Static Cursors
attributes, object : 18.1.1. Terminology
collections as : 19.2.1.2. Collection as an attribute of an object type
dot notation for
18.3.4.1. Dots in data structures
18.3.4.3. Attribute or method?
object equality and : 18.3.6.2. Equality comparisons
authority, execute/run : (see execute authority)


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