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 : The ABS function
• absolute value : The ABS function
• abstract data types : (see ADTs)
• abstraction : Abstraction
• access
• • to compiled code, tuning : Tuning Access to Compiled Code
  • to data, tuning : Tuning Access to Your Data
  • data structure, encapsulating : Synchronize Program and Data Structures
  • to SQL, minimizing : Use Package Data to Minimize SQL Access
• ACCESS table, tuning : Tune ACCESS$ Table to Reduce First Execution Time of Code
• actual parameters : Actual and Formal Parameters
• Ada developing language :
• ADD_MONTHS function : The ADD_MONTHS function
• • customizing : Customizing the Behavior of ADD_MONTHS
• adding collection elements : Adding and Removing Elements
• administration of Oracle databases : About the Contents
• administration, Oracle/AQ : DBMS_AQADM (PL/SQL 8 Only)
• ADTs (abstract datatypes)
• • (see also object types)
  • Classification
  • building : Construct Abstract Data Types (ADTs)
• advanced queuing : Oracle/AQ, the Advanced Queueing Facility
• ADVISE_COMMIT procedure : The ADVISE_COMMIT procedure
• ADVISE_NOTHING procedure : The ADVISE_NOTHING procedure
• ADVISE_ROLLBACK procedure : The ADVISE_ROLLBACK procedure
• aggregate
• • assignment into rows : Aggregate Assignment
  • operations
  • • Aggregate operations
    • Aggregate Assignment
    • Records of the same type
    • of nested records : Aggregate Assignments of Nested Records
  • values, combining with scalars : Combining Scalar and Aggregate Values
• aggregation : Inheritance
• alerts : (see DBMS_ALERT package)
• algorithms, tuning : Tuning Your Algorithms
• aliases
• • column
  • • Column Aliases in Cursors
    • Setting the Record's Column Names
  • directory : The BFILENAME function
  • for cursor variables : Cursor variable aliases
• alignment of code : (see coding, layout of)
• ALLOCATE_UNIQUE procedure : The ALLOCATE_UNIQUE procedure
• ALTER SESSION command : Enabling Program Units for Tracing
• ALTER TABLE statement : Schema Evolution
• ALTER_COMPILE procedure : The ALTER_COMPILE procedure
• ALTER_QUEUE procedure : The ALTER_QUEUE procedure
• ANALYZE statement : Analyzing Program Performance
• ANALYZE_OBJECT procedure : The ANALYZE_OBJECT procedure
• ANALYZE_SCHEMA procedure : The ANALYZE_SCHEMA procedure
• anchored datatypes
• • Anchored declarations
  • Anchored Declarations
  • anchoring to subtypes : Emulating Constrained Subtypes
• angle brackets (>) as label delimiters : The GOTO Statement
• anonymous blocks : The Anonymous PL/SQL Block
• • labels for : Block Labels
  • nested : Nested Blocks
  • in Oracle Tools : Anonymous Blocks in the Oracle Tools
• APPEND procedure : The APPEND procedure
• applications, tuning : Tuning PL/SQL Applications
• • access to compiled code : Tuning Access to Compiled Code
  • access to data : Tuning Access to Your Data
  • analyzing performance : Analyzing Program Performance
  • optimizing algorithms : Tuning Your Algorithms
• AQ : (see advanced queuing)
• arguments, trapping invalid : Trap invalid argument values
• arrays
• • (see also tables)
  • PL/SQL tables
  • building with tables : Building Traditional Arrays with PL/SQL Tables
  • package for
  • • (see also PSG_array package)
    • Features of the array package
  • variable arrays : Variable arrays and nested tables
  • • objects for : Some Simple Examples
  • variable-size : (see VARRAYs)
• ASCII function : The ASCII function
• assertion modules : Use Assertion Modules to Validate Parameters and Assumptions
• assigning objects : Direct assignment
• assignment (\:=) operator
• • The PL/SQL Character Set
  • Default Values
  • Assigning Values to and from Records
• association operator for positional notation (=>) : The PL/SQL Character Set
• association, object : Inheritance
• atomics of PL/SQL language : The PL/SQL Character Set
• attributes, cursor
• • Cursor Attributes
  • Similarities to Static Cursors
• attributes, object : Terminology
• • collections as : Collection as an attribute of an object type
  • dot notation for
  • • Dots in data structures
    • Attribute or method?
  • object equality and : Equality comparisons
• authority, execute/run : (see execute authority)