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

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