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 : C.10.3. The PACK_MESSAGE procedure
package variables, stored functions and : 17.4. Restrictions on PL/SQL Functions in SQL
packages
  1.4.3.10. Modular construction
  1.6.8. Packages
  16. Packages
  Booch diagram : 16.2.4. Public and Private Package Elements
  built-in
    1.4.3.6. Built-in packages
    1.6.3. Built-in packages
  built-in, reference on : C. Built-In Packages
  cursors in : 6.4.4. The Cursor RETURN Clause
  data structures in : 16.5. Package Data
  debugging messages in : 24.2.9. Build Debugging Messages into Your Packages
  declaring cursors in : 16.3.2. Declaring Package Cursors
  developing around : 1.7.3. Center All Development Around Packages
  documenting : 3.7. Documenting the Entire Package
  encapsulating data structure access : 1.7.2. Synchronize Program and Data Structures
  of exceptions only : 16.3.1.1. A package of exceptions
  formatting : 3.5. Formatting Packages
  functions in, calling : 17.5. Calling Packaged Functions in SQL
  granting execute authority to : 23.2.1. Execute Authority on Stored Objects
  initialization section
    purity level assertions in : 17.5.2. Asserting Purity Level with Package Initialization Section
  initializing : 16.6. Package Initialization
  of magic values only : 16.3.1.2. A package of magic values
  minimizing interdependencies : 25.2.4. Creating Packages with Minimal Interdependencies
  modifying persistent objects : 18.5.4. Approach 4: Use an Object and a PL/SQL Container Package
  naming : 22.1.3. Name Packages and Their Elements to Reflect the Packaged Structure
  numbers-to-words : 17.8.7. Recursive Processing in a SQL Statement
  pinning into SGA shared pool : 25.2.2. Pin Critical Code into the SGA
  public versus private elements : 16.2.4. Public and Private Package Elements
  purity level of : 17.5.1. The RESTRICT_REFERENCES Pragma
  referencing elements of : 23.1.4. Key Concepts for Program Execution
  rights models : 18.3.7.3. Rights model
  specification
    16.2.1. The Specification
    16.3. The Package Specification
  STANDARD : 8.3.1. Named System Exceptions
  storing spefifications for : 1.7.3. Center All Development Around Packages
  synchronizing body and specification : 16.4.2. Synchronize Body with Package
  toggles in : 1.7.3. Center All Development Around Packages
  variables in : B.2.2. No Direct Stored Package Variable References
    reducing memory usage of : 25.2.5. Reducing Memory Usage of Package Variables
padding strings
  11.1.11. The RPAD function
  11.1.8. The LPAD function
parameters : 15.6. Parameters
  accepted in PARAMETERS clause : 21.4.3. Properties
  actual versus formal : 15.6.3. Actual and Formal Parameters
  Boolean : 22.7.2. Use Self-Identifying Parameters (Avoid Boolean Values)
  case consistency of : 22.7.4. Ensure Case Consistency of Parameters
  declaring : 21.4.4. Correct Declaration of Properties
  default values of
    B.2.4. No Default Parameter Values
    15.6.5. Default Values
    22.7.5. Default Values and Remote Procedure Calls
  design tips for : 22.7. Tips for Parameter Design
  documenting : 22.7.1. Document All Parameters and Their Functions
  IN mode : 15.6.2.1. IN mode
  IN OUT mode
    15.6.2.3. The IN OUT mode
    22.7.3. Assign Values to All OUT and IN OUT Parameters
  increasing number of : 22.5.3. Use Parameters Liberally
  mapping for external procedures : 21.4. Mapping Parameters
  module, collections as : 19.2.2.3. Collections as module parameters
  modules without : 22.4. Be Wary of Modules Without Any Parameters
  naming : 22.1.2. Develop Consistent Naming Conventions for Your Formal Parameters
  OUT mode
    15.6.2.2. OUT mode
    22.7.3. Assign Values to All OUT and IN OUT Parameters
  for overloaded modules : 15.8.4. Restrictions on Overloading
  package data and : 25.4.4. Use Package Data to Avoid Passing "Bulky" Parameter Values
  passing by reference : 21.4.2. More Syntax: The PARAMETERS Clause
  tables as : 10.5.4. Passing PL/SQL Tables as Parameters
  validating with assertion modules : 22.2.4. Use Assertion Modules to Validate Parameters and Assumptions
PARAMETERS clause : 21.4.1. Datatype Conversion
  declaring parameters : 21.4.4. Correct Declaration of Properties
  parameters possible in : 21.4.3. Properties
parameters, cursor : 6.10. Cursor Parameters
parent block : (see nested blocks)
PARSE procedure : C.14.15. The PARSE procedure
parsing SQL statements : 6.2.2. Cursor Operations
parsing strings : 11.2.1. Parsing a Name
part-of relationship : 18.1.4.3. Inheritance
partitioned tables, ROWID datatype for : 4.2.3.6. The ROWID datatype
partitioning table to store array : 10.9.4.2. Partitioning a PL/SQL table to store an array
passing
  collection arguments : 19.8.3. Call by Reference or Call by Value
  parameters by reference : 21.4.2. More Syntax: The PARAMETERS Clause
performance
  analyzing : 25.1. Analyzing Program Performance
  implicit cursors and : 6.3.2.1. Inefficiencies of implicit cursors
  implicit data conversions and : 4.2.8.3. Drawbacks of implicit conversions
  local variables and : 25.4.3. Rely on Local Variables to Improve Performance
  package data and : 25.4.4. Use Package Data to Avoid Passing "Bulky" Parameter Values
  stored functions and : 17.1. Looking at the Problem
  time, using progress box : 22.6.3. Progress Box as ADT
persistence
  encapsulation and : 18.2.2.2. DDL usage
  REFs and : 18.2.3. Adding Complex Data Structures
persistent objects
  modifying : 18.5. Modifying Persistent Objects
  referring to : 18.4.2. OID, VALUE, REF, and DEREF
PGA (Program Global Area) : 25.3.1. Use Package Data to Minimize SQL Access
phonetic string comparisons : 11.1.13. The SOUNDEX function
pinning packages into SGA shared pool : 25.2.2. Pin Critical Code into the SGA
pipes : (see DBMS_PIPE package)
PL/SQL
  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
  best practices : 1.7. Best Practices for PL/SQL Excellence
  blocks : (see modules)
  C interface, datatypes and : 21.4.1. Datatype Conversion
  and client-server architecture : 1.1. What Is PL/SQL?
  collections in : 19.2.2.1. Collection variables
  datatype subtypes in : 4.6.1. Declaring Subtypes
  debugging : (see debugging)
  definition of : 1.1. What Is PL/SQL?
  exceptions : (see exceptions)
  for I/O-intensive SQL : 25.3.6. 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) : 19.7. Example: PL/SQL-to-Server Integration
  language
    coding : (see coding)
    structure of : 2.7. Block Structure
  language of : 2.1. The PL/SQL Character Set
  lexical units of : 2.1. The PL/SQL Character Set
  literals : (see literals)
  loops : (see loops)
  memory-based code architecture : 23.1.3. Memory-Based Architecture of PL/SQL Code
  modules : 2.7. Block Structure
  objects : (see objects)
  origins of : 1.3. The Origins of PL/SQL
  packages : (see packages)
  Programming Companion Utilities Guide : A. What's on the Companion Disk?
  Release 1.1 : 10.9.4.3. Features of the array package
  Release 2.2 : 6.12. Cursor Variables
  Release 2.3
    6.12. Cursor Variables
    10.1.1. PL/SQL Tables
    10.8. PL/SQL Table Enhancements in PL/SQL Release 2.3
  tracing execution : 26. Tracing PL/SQL Execution
  variables : (see variables)
  version 8 enhancements : 25.5. Overview of PL/SQL8 Enhancements
  versions of : 1.4. PL/SQL Versions
    Release 2.1 : 15.8.4. Restrictions on Overloading
    Version 1.1 : B. Calling Stored Procedures from PL/SQL Version 1.1
    Version 2 : 15.6.1.1. %TYPE and %ROWTYPE
    Version 2.0
      B.1. Using Stubs to Talk to Server-Side PL/SQL
      1.4.3. PL/SQL Version 2.0
      23.4. Remote Procedure Calls
    working with multiple : 1.4.1. Working with Multiple Versions of PL/SQL
  wrapper : 1.4.5.1. The PL/SQL wrapper
PL/SQL tables : (see index-by tables)
PLS-00452 error : 17.5.1.1. Pragma violation errors
PLS_INTEGER data type : 25.4.5. Use PLS_INTEGER for All Integer Operations
PLS_INTEGER datatype : 4.2.1.3. The PLS_INTEGER datatype
pointers to objects : (see references to objects)
polymorphism : 18.1.4.4. Polymorphism
PORT_STRING function : C.16.10. The PORT_STRING function
portability : 1.3.1. Improved Application Portability with PL/SQL
POSITIVE datatype : 4.2.1.1. Binary integer datatypes
Post-Query trigger : 6.3.2.1. Inefficiencies of implicit cursors
POWER function : 13.1.14. The POWER function
PRAGMA keyword : 2.6. The PRAGMA Keyword
pragmas
  EXCEPTION_INIT : 8.3.3.1. The EXCEPTION_INIT pragma
  RESTRICT_REFEFRENCES : 17.3. Requirements for Stored Functions in SQL
  RESTRICT_REFERENCES
    17.5.1. The RESTRICT_REFERENCES Pragma
    17.7.1. Manual Application of Pragmas
precedence, identifiers in cursors : 6.4.3. Identifier Precedence in a Cursor
precision : 4.2.1.2. Decimal numeric datatypes
predefined system exceptions : 8.3.1. Named System Exceptions
PRIOR function
  10.8.2.7. The PRIOR function
  19.6.7. PRIOR(i), NEXT(i)
private
  elements, package
    16.2.2. The Body
    16.2.4. Public and Private Package Elements
  global data : 16.5.4. Global Private Data
privileges
  collections : 19.8.1. Privileges
  of objects : 18.3.7. Privileges
procedural code, avoiding : 25.3.5. Avoid Procedural Code When Possible
procedures
  (see also functions; modules)
  1.4.3.10. Modular construction
  15. Procedures and Functions
  15.4. Procedures
  22.1.1. Make Sure the Module Name Explains the Module
  changing trigger code to : 25.3.7. Keep Database Triggers Small
  for collections : 19.6. Collection Built-Ins
  external
    (see external procedures)
    1.4.7.5. External procedures
  headers of : 15.4.2. Procedure Header
  IN OUT parameters in : 22.2.1.2. Switch to a procedure with IN OUT parameters
  local : 15.7. Local Modules
  parameters of : 15.6. Parameters
  records as parameters : 9.1.4. Guidelines for Using Records
  remote
    22.7.5. Default Values and Remote Procedure Calls
    23.4. Remote Procedure Calls
  RETURN statements in : 15.5.8.5. RETURN statement in a procedure
  shared : 23.1.1. Executing Procedures
  stored, from PL/SQL Version 1.1 : B. Calling Stored Procedures from PL/SQL Version 1.1
  synonyms for : 23.2.2. Creating Synonyms for Stored Objects
  tables as parameters for : 10.5.4. Passing PL/SQL Tables as Parameters
production support : 26.2. Tracing for Production Support
Program Global Area (PGA) : 25.3.1. Use Package Data to Minimize SQL Access
PROGRAM_ERROR exception : 8.3.1. Named System Exceptions
programmer-defined
  exceptions
    8.3.2. Named Programmer-Defined Exceptions
    8.3.4. Unnamed Programmer-Defined Exceptions
    scope of : 8.4.1.1. Scope of programmer-defined exception
  records
    1.4.3.3. Programmer-defined records
    9.4. Programmer-Defined Records
  subtypes : 1.4.4.4. Programmer-defined subtypes
programmer-defined datatypes : (see subtypes)
programmer-defined PL/SQL functions : (see stored functions, PL/SQL)
programming : (see coding)
Programming Companion Utilities Guide : A. What's on the Companion Disk?
programs
  analyzing performance of : 25.1. Analyzing Program Performance
  enabling tracing of : 26.1.1. Enabling Program Units for Tracing
  pinning into SGA shared pool : 25.2.2. Pin Critical Code into the SGA
  shared, executing : 23.1. Executing Stored Code
  testing : 24.2.5. Change and Test One Area of Code at a Time
progress boxes : 22.6.3. Progress Box as ADT
progress package : 22.6.4.1. The progress package specification
propagation of exceptions : 8.4.2. Propagation of an Exception
properties, object : (see attributes, object)
privileges, object views : 20.7.2. Privileges
pseudoinstructions : 2.6. The PRAGMA Keyword
public
  elements, package
    16.2.1. The Specification
    16.2.4. Public and Private Package Elements
  global data : 16.5.3. Global Public Data
PURGE procedure : C.10.4. The PURGE procedure
PURGE_LOG procedure : C.13.3. The PURGE_LOG procedure
PURGE_LOST_DB procedure : C.15.16. The PURGE_LOST_DB procedure
PURGE_MIXED procedure : C.15.15. The PURGE_MIXED procedure
purity levels, packages : 17.5.1. The RESTRICT_REFERENCES Pragma
PUT procedure : C.17.1.8. The PUT procedure
PUT_LINE function : 23.1.2. Executing Functions
PUT_LINE procedure
  C.9.7. The PUT_LINE procedure
  C.17.1.10. The PUT_LINE procedure
PUTF procedure : C.17.1.9. The PUTF procedure

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

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