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

• PACK_MESSAGE procedure : The PACK_MESSAGE procedure
• package variables, stored functions and : Restrictions on PL/SQL Functions in SQL
• packages
• • Modular construction
  • Packages
  • Packages
  • Booch diagram : Public and Private Package Elements
  • built-in
  • • Built-in packages
    • Built-in packages
  • built-in, reference on : Built-In Packages
  • cursors in : The Cursor RETURN Clause
  • data structures in : Package Data
  • debugging messages in : Build Debugging Messages into Your Packages
  • declaring cursors in : Declaring Package Cursors
  • developing around : Center All Development Around Packages
  • documenting : Documenting the Entire Package
  • encapsulating data structure access : Synchronize Program and Data Structures
  • of exceptions only : package of exceptions
  • formatting : Formatting Packages
  • functions in, calling : Calling Packaged Functions in SQL
  • granting execute authority to : Execute Authority on Stored Objects
  • initialization section
  • • purity level assertions in : Asserting Purity Level with Package Initialization Section
  • initializing : Package Initialization
  • of magic values only : package of magic values
  • minimizing interdependencies : Creating Packages with Minimal Interdependencies
  • modifying persistent objects : Approach 4: Use an Object and a PL/SQL Container Package
  • naming : Name Packages and Their Elements to Reflect the Packaged Structure
  • numbers-to-words : Recursive Processing in a SQL Statement
  • pinning into SGA shared pool : Pin Critical Code into the SGA
  • public versus private elements : Public and Private Package Elements
  • purity level of : The RESTRICT_REFERENCES Pragma
  • referencing elements of : Key Concepts for Program Execution
  • rights models : Rights model
  • specification
  • • The Specification
    • The Package Specification
  • STANDARD : Named System Exceptions
  • storing spefifications for : Center All Development Around Packages
  • synchronizing body and specification : Synchronize Body with Package
  • toggles in : Center All Development Around Packages
  • variables in : No Direct Stored Package Variable References
  • • reducing memory usage of : Reducing Memory Usage of Package Variables
• padding strings
• • The RPAD function
  • The LPAD function
• parameters : Parameters
• • accepted in PARAMETERS clause : Properties
  • actual versus formal : Actual and Formal Parameters
  • Boolean : Use Self-Identifying Parameters (Avoid Boolean Values)
  • case consistency of : Ensure Case Consistency of Parameters
  • declaring : Correct Declaration of Properties
  • default values of
  • • No Default Parameter Values
    • Default Values
    • Default Values and Remote Procedure Calls
  • design tips for : Tips for Parameter Design
  • documenting : Document All Parameters and Their Functions
  • IN mode : IN mode
  • IN OUT mode
  • • The IN OUT mode
    • Assign Values to All OUT and IN OUT Parameters
  • increasing number of : Use Parameters Liberally
  • mapping for external procedures : Mapping Parameters
  • module, collections as : Collections as module parameters
  • modules without : Be Wary of Modules Without Any Parameters
  • naming : Develop Consistent Naming Conventions for Your Formal Parameters
  • OUT mode
  • • OUT mode
    • Assign Values to All OUT and IN OUT Parameters
  • for overloaded modules : Restrictions on Overloading
  • package data and : Use Package Data to Avoid Passing "Bulky" Parameter Values
  • passing by reference : More Syntax: The PARAMETERS Clause
  • tables as : Passing PL/SQL Tables as Parameters
  • validating with assertion modules : Use Assertion Modules to Validate Parameters and Assumptions
• PARAMETERS clause : Datatype Conversion
• • declaring parameters : Correct Declaration of Properties
  • parameters possible in : Properties
• parameters, cursor : Cursor Parameters
• parent block : (see nested blocks)
• PARSE procedure : The PARSE procedure
• parsing SQL statements : Cursor Operations
• parsing strings : Parsing a Name
• part-of relationship : Inheritance
• partitioned tables, ROWID datatype for : The ROWID datatype
• partitioning table to store array : Partitioning a PL/SQL table to store an array
• passing
• • collection arguments : Call by Reference or Call by Value
  • parameters by reference : More Syntax: The PARAMETERS Clause
• performance
• • analyzing : Analyzing Program Performance
  • implicit cursors and : Inefficiencies of implicit cursors
  • implicit data conversions and : Drawbacks of implicit conversions
  • local variables and : Rely on Local Variables to Improve Performance
  • package data and : Use Package Data to Avoid Passing "Bulky" Parameter Values
  • stored functions and : Looking at the Problem
  • time, using progress box : Progress Box as ADT
• persistence
• • encapsulation and : DDL usage
  • REFs and : Adding Complex Data Structures
• persistent objects
• • modifying : Modifying Persistent Objects
  • referring to : OID, VALUE, REF, and DEREF
• PGA (Program Global Area) : Use Package Data to Minimize SQL Access
• phonetic string comparisons : The SOUNDEX function
• pinning packages into SGA shared pool : Pin Critical Code into the SGA
• pipes : (see DBMS_PIPE package)
• PL/SQL
• • 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
  • best practices : Best Practices for PL/SQL Excellence
  • blocks : (see modules)
  • C interface, datatypes and : Datatype Conversion
  • and client-server architecture : What Is PL/SQL?
  • collections in : Collection variables
  • datatype subtypes in : Declaring Subtypes
  • debugging : (see debugging)
  • definition of : What Is PL/SQL?
  • exceptions : (see exceptions)
  • for I/O-intensive SQL : Use PL/SQL to Improve Performance of IO-Intensive SQL
  • functions in SQL : (see stored functions, PL/SQL)
  • identifiers : (see identifiers)
  • integration with server (example) : Example: PL/SQL-to-Server Integration
  • language
  • • coding : (see coding)
    • structure of : Block Structure
  • language of : The PL/SQL Character Set
  • lexical units of : The PL/SQL Character Set
  • literals : (see literals)
  • loops : (see loops)
  • memory-based code architecture : Memory-Based Architecture of PL/SQL Code
  • modules : Block Structure
  • objects : (see objects)
  • origins of : The Origins of PL/SQL
  • packages : (see packages)
  • Developing Companion Utilities Guide : What's on the Companion Disk?
  • Release 1.1 : Features of the array package
  • Release 2.2 : Cursor Variables
  • Release 2.3
  • • Cursor Variables
    • PL/SQL Tables
    • PL/SQL Table Enhancements in PL/SQL Release 2.3
  • tracing execution : Tracing PL/SQL Execution
  • variables : (see variables)
  • version 8 enhancements : Overview of PL/SQL8 Enhancements
  • versions of : PL/SQL Versions
  • • Release 2.1 : Restrictions on Overloading
    • Version 1.1 : Calling Stored Procedures from PL/SQL Version 1.1
    • Version 2 : %TYPE and %ROWTYPE
    • Version 2.0
    • • Using Stubs to Talk to Server-Side PL/SQL
      • PL/SQL Version 2.0
      • Remote Procedure Calls
    • working with multiple : Working with Multiple Versions of PL/SQL
  • wrapper : The PL/SQL wrapper
• PL/SQL tables : (see index-by tables)
• PLS-00452 error : Pragma violation errors
• PLS_INTEGER data type : Use PLS_INTEGER for All Integer Operations
• PLS_INTEGER datatype : The PLS_INTEGER datatype
• pointers to objects : (see references to objects)
• polymorphism : Polymorphism
• PORT_STRING function : The PORT_STRING function
• portability : Improved Application Portability with PL/SQL
• POSITIVE datatype : Binary integer datatypes
• Post-Query trigger : Inefficiencies of implicit cursors
• POWER function : The POWER function
• PRAGMA keyword : The PRAGMA Keyword
• pragmas
• • EXCEPTION_INIT : The EXCEPTION_INIT pragma
  • RESTRICT_REFEFRENCES : Requirements for Stored Functions in SQL
  • RESTRICT_REFERENCES
  • • The RESTRICT_REFERENCES Pragma
    • Manual Application of Pragmas
• precedence, identifiers in cursors : Identifier Precedence in a Cursor
• precision : Decimal numeric datatypes
• predefined system exceptions : Named System Exceptions
• PRIOR function
• • The PRIOR function
  • PRIOR(i), NEXT(i)
• private
• • elements, package
  • • The Body
    • Public and Private Package Elements
  • global data : Global Private Data
• privileges
• • collections : Privileges
  • of objects : Privileges
• procedural code, avoiding : Avoid Procedural Code When Possible
• procedures
• • (see also functions; modules)
  • Modular construction
  • Procedures and Functions
  • Procedures
  • Make Sure the Module Name Explains the Module
  • changing trigger code to : Keep Database Triggers Small
  • for collections : Collection Built-Ins
  • external
  • • (see external procedures)
    • External procedures
  • headers of : Procedure Header
  • IN OUT parameters in : Switch to a procedure with IN OUT parameters
  • local : Local Modules
  • parameters of : Parameters
  • records as parameters : Guidelines for Using Records
  • remote
  • • Default Values and Remote Procedure Calls
    • Remote Procedure Calls
  • RETURN statements in : RETURN statement in a procedure
  • shared : Executing Procedures
  • stored, from PL/SQL Version 1.1 : Calling Stored Procedures from PL/SQL Version 1.1
  • synonyms for : Creating Synonyms for Stored Objects
  • tables as parameters for : Passing PL/SQL Tables as Parameters
• production support : Tracing for Production Support
• Program Global Area (PGA) : Use Package Data to Minimize SQL Access
• PROGRAM_ERROR exception : Named System Exceptions
• developer-defined
• • exceptions
  • • Named Developer-Defined Exceptions
    • Unnamed Developer-Defined Exceptions
    • scope of : Scope of developer-defined exception
  • records
  • • Developer-defined records
    • Developer-Defined Records
  • subtypes : Developer-defined subtypes
• developer-defined datatypes : (see subtypes)
• developer-defined PL/SQL functions : (see stored functions, PL/SQL)
• developing : (see coding)
• Developing Companion Utilities Guide : What's on the Companion Disk?
• programs
• • analyzing performance of : Analyzing Program Performance
  • enabling tracing of : Enabling Program Units for Tracing
  • pinning into SGA shared pool : Pin Critical Code into the SGA
  • shared, executing : Executing Stored Code
  • testing : Change and Test One Area of Code at a Time
• progress boxes : Progress Box as ADT
• progress package : The progress package specification
• propagation of exceptions : Propagation of an Exception
• properties, object : (see attributes, object)
• privileges, object views : Privileges
• pseudoinstructions : The PRAGMA Keyword
• public
• • elements, package
  • • The Specification
    • Public and Private Package Elements
  • global data : Global Public Data
• PURGE procedure : The PURGE procedure
• PURGE_LOG procedure : The PURGE_LOG procedure
• PURGE_LOST_DB procedure : The PURGE_LOST_DB procedure
• PURGE_MIXED procedure : The PURGE_MIXED procedure
• purity levels, packages : The RESTRICT_REFERENCES Pragma
• PUT procedure : The PUT procedure
• PUT_LINE function : Executing Functions
• PUT_LINE procedure
• • The PUT_LINE procedure
  • The PUT_LINE procedure
• PUTF procedure : The PUTF procedure