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