CD Home

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Index: P

PACKAGE column
*_CONTEXT data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
*_POLICIES data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
PACK_MESSAGE procedure
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure, Oracle Built-in Packages
C.10.3. The PACK_MESSAGE procedure, Oracle PL/SQL Programming
sending/receiving relationship and: 3.1.7.3. The dbpipe utility package, Oracle Built-in Packages
PACK_MESSAGE_RAW procedure
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.4.2. The DBMS_PIPE.PACK_MESSAGE_RAW procedure, Oracle Built-in Packages
PACK_MESSAGE_ROWID procedure
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.4.3. The DBMS_PIPE.PACK_MESSAGE_ROWID procedure, Oracle Built-in Packages
PARALLEL_ENABLE keyword
1.3.9. Miscellaneous New Features and Performance Improvements (Chapter 10, More Goodies for Oracle8i PL/SQL Developers), Guide to Oracle8i Features
10.2.2.3. PARALLEL_ENABLE functions , Guide to Oracle8i Features
PARAMETERS clause: 21.4.1. Datatype Conversion, Oracle PL/SQL Programming
declaring parameters: 21.4.4. Correct Declaration of Properties, Oracle PL/SQL Programming
parameters possible in: 21.4.3. Properties, Oracle PL/SQL Programming
PARSE procedure
19.5.6.1. Open and parse, Advanced Oracle PL/SQL Programming with Packages
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.3.1. The DBMS_SQL.PARSE procedure, Oracle Built-in Packages
C.14.15. The PARSE procedure, Oracle PL/SQL Programming
DBMS_SQL package: 3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
encapsulating for error handling: 2.4.6. Problem-Solving Dynamic SQL Errors, Oracle Built-in Packages
SQL language version: 2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages
PDAs (Personal Data Assistants): 1.1. The Internet Grows Up, Oracle Web Applications
PF_OWNER column, *_POLICIES data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
PGA (Program Global Area): 25.3.1. Use Package Data to Minimize SQL Access, Oracle PL/SQL Programming
PL/Formatter
6.4. PL/SQL Tools, Oracle Web Applications
6.4.2. PL/Formatter, Oracle Web Applications
PL/SQL
2.4.8. Executing Dynamic PL/SQL, Oracle Built-in Packages
1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
6. PL/SQL, Oracle Web Applications
C interface, datatypes and: 21.4.1. Datatype Conversion, Oracle PL/SQL Programming
Programming Companion Utilities Guide: A. What's on the Companion Disk?, Oracle PL/SQL Programming
Release 1.1: 10.9.4.3. Features of the array package, Oracle PL/SQL Programming
Release 2.2: 6.12. Cursor Variables, Oracle PL/SQL Programming
Release 2.3
6.12. Cursor Variables, Oracle PL/SQL Programming
10.1.1. PL/SQL Tables, Oracle PL/SQL Programming
10.8. PL/SQL Table Enhancements in PL/SQL Release 2.3, Oracle PL/SQL Programming
and client-server architecture: 1.1. What Is PL/SQL?, Oracle PL/SQL Programming
applications, tuning: 25. Tuning PL/SQL Applications, Oracle PL/SQL Programming
access to compiled code: 25.2. Tuning Access to Compiled Code, Oracle PL/SQL Programming
access to data: 25.3. Tuning Access to Your Data, Oracle PL/SQL Programming
analyzing performance: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming
optimizing algorithms: 25.4. Tuning Your Algorithms, Oracle PL/SQL Programming
arrays: 6.2.6. Index-by Tables (Arrays), Oracle Web Applications
best practices: 1.7. Best Practices for PL/SQL Excellence, Oracle PL/SQL Programming
blocks
(see also modules)
syntax for: 2.4.8. Executing Dynamic PL/SQL, Oracle Built-in Packages
call stack: 21.2.2. Accessing the PL/SQL Call Stack, Advanced Oracle PL/SQL Programming with Packages
call, WebDB dashboard: 3.1.3.1. User-uploaded content, Oracle Web Applications
code, parsing: 10.3.2. Parsing PL/SQL Code, Advanced Oracle PL/SQL Programming with Packages
collections in: 19.2.2.1. Collection variables, Oracle PL/SQL Programming
comments: 6.2.1. Comments, Oracle Web Applications
conditionals: 6.2.3. Conditionals, Oracle Web Applications
connections and: 2.4.7. Executing DDL in PL/SQL, Oracle Built-in Packages
cursors: 6.2.5. Cursors, Oracle Web Applications
datatype subtypes in: 4.6.1. Declaring Subtypes, Oracle PL/SQL Programming
debugging: (see debugging)
debugging stored code: 6.1. DBMS_OUTPUT: Displaying Output, Oracle Built-in Packages
declaration section: 6.1. Structured Programming in PL/SQL , Oracle Web Applications
declarative programming: 19.2. Declarative Programming in PL/SQL, Advanced Oracle PL/SQL Programming with Packages
definition of: 1.1. What Is PL/SQL?, Oracle PL/SQL Programming
dynamic code: 19.5.5. Executing Dynamic PL/SQL Code, Advanced Oracle PL/SQL Programming with Packages
dynamic execution of: 2. Executing Dynamic SQL and PL/SQL, Oracle Built-in Packages
exception section: 6.1.1. Procedures, Oracle Web Applications
exceptions: (see exceptions)
executable section: 6.1. Structured Programming in PL/SQL , Oracle Web Applications
for I/O-intensive SQL: 25.3.6. Use PL/SQL to Improve Performance of IO-Intensive SQL, Oracle PL/SQL Programming
functions: 6.1.2. Functions, Oracle Web Applications
functions in SQL: (see stored functions, PL/SQL)
gateway: 3.2.1. The PL/SQL Gateway, Oracle Web Applications
gateways
2.3.2. The PL/SQL Gateway, Oracle Web Applications
2.4. Database Integration, Oracle Web Applications
header section: 6.1. Structured Programming in PL/SQL , Oracle Web Applications
identifiers: (see identifiers)
integration with server (example): 19.7. Example: PL/SQL-to-Server Integration, Oracle PL/SQL Programming
language
coding: (see coding)
structure of: 2.7. Block Structure, Oracle PL/SQL Programming
language of: 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
lexical units of: 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
literals: (see literals)
location transparency: 2.5.3.2. Object privileges, Oracle Web Applications
loops
(see also loops)
6.2.4. Loops, Oracle Web Applications
memory-based code architecture: 23.1.3. Memory-Based Architecture of PL/SQL Code , Oracle PL/SQL Programming
modes: 6.1.3. Parameters, Oracle Web Applications
modules: 2.7. Block Structure, Oracle PL/SQL Programming
objects
11. PLVobj: A Packaged Interface to ALL_OBJECTS, Advanced Oracle PL/SQL Programming with Packages
(see also objects)
origins of: 1.3. The Origins of PL/SQL, Oracle PL/SQL Programming
overloading: 6.1.5. Overloading, Oracle Web Applications
packages
(see also packages)
6.3. Packages, Oracle Web Applications
8.1.4. Use PL/SQL Packages, Oracle Web Applications
parameters: 6.1.3. Parameters, Oracle Web Applications
performance and: 19.5.5.3. The overhead of dynamic PL/SQL, Advanced Oracle PL/SQL Programming with Packages
permissions: 6.1.6. Permissions, Oracle Web Applications
procedures: 6.1.1. Procedures, Oracle Web Applications
reasons for using: 1.4.2.2. Why PL/SQL?, Oracle Web Applications
reserved words: 5.26. PLVtkn: Token Table Interface, Advanced Oracle PL/SQL Programming with Packages
server, DBMS_PIPE implementation of: 3.1.7.4. Implementing a server program, Oracle Built-in Packages
source code repositories: 12. PLVio: Reading and Writing PL/SQL Source Code, Advanced Oracle PL/SQL Programming with Packages
structured programming: 6.1. Structured Programming in PL/SQL , Oracle Web Applications
tables: (see index-by tables)
text processing: 7.2. Text Processing, Oracle Web Applications
tokens: (see reserved words)
toolkit: 7. The PL/SQL Toolkit, Oracle Web Applications
tools: 6.4. PL/SQL Tools, Oracle Web Applications
tracing execution: 26. Tracing PL/SQL Execution, Oracle PL/SQL Programming
variables
(see also variables)
6.2.2. Variables, Oracle Web Applications
version 8 enhancements: 25.5. Overview of PL/SQL8 Enhancements, Oracle PL/SQL Programming
versions of: 1.4. PL/SQL Versions, Oracle PL/SQL Programming
Release 2.1: 15.8.4. Restrictions on Overloading, Oracle PL/SQL Programming
Version 1.1: B. Calling Stored Procedures from PL/SQL Version 1.1, Oracle PL/SQL Programming
Version 2: 15.6.1.1. %TYPE and %ROWTYPE, Oracle PL/SQL Programming
Version 2.0
B.1. Using Stubs to Talk to Server-Side PL/SQL, Oracle PL/SQL Programming
1.4.3. PL/SQL Version 2.0, Oracle PL/SQL Programming
23.4. Remote Procedure Calls, Oracle PL/SQL Programming
working with multiple: 1.4.1. Working with Multiple Versions of PL/SQL, Oracle PL/SQL Programming
wrapper: 1.4.5.1. The PL/SQL wrapper, Oracle PL/SQL Programming
PL/SQL 8.1
BULK COLLECT clause: 5.3. Bulk Querying with the BULK COLLECT Clause, Guide to Oracle8i Features
FORALL statement: 5.2. Bulk DML with the FORALL Statement, Guide to Oracle8i Features
Java and
1.2. And Then There's Java, Guide to Oracle8i Features
1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL), Guide to Oracle8i Features
bulk operations, impact of: 5.5. Analyzing the Impact of Bulk Operations, Guide to Oracle8i Features
context-switching problem scenarios: 5.1. Context-Switching Problem Scenarios, Guide to Oracle8i Features
cursor attributes: 5.4. Using Cursor Attributes, Guide to Oracle8i Features
introduction: 5. Bulking Up with PL/SQL 8.1, Guide to Oracle8i Features
trace versus PL/SQL profiler: 7.2. DBMS_TRACE: Providing a PL/SQL Trace Facility, Guide to Oracle8i Features
wrappers, building: 9.3.4. Building a PL/SQL Wrapper, Guide to Oracle8i Features
PL/Vision
About PL/Vision, Oracle Built-in Packages
4.1. What Is PL/Vision?, Advanced Oracle PL/SQL Programming with Packages
PLVgen and: 16.4.6. Leveraging PL/Vision in PLVgen, Advanced Oracle PL/SQL Programming with Packages
PLVmsg with: 9.5.1. Using PLVmsg in PL/Vision , Advanced Oracle PL/SQL Programming with Packages
bindobj procedure in: 11.5.3. Using bindobj in PL/Vision, Advanced Oracle PL/SQL Programming with Packages
cataloging: 18.2.3.4. Cataloguing PL/Vision, Advanced Oracle PL/SQL Programming with Packages
enhancing PLVexc with: 22.3.4. Revamping the PLVexc Package, Advanced Oracle PL/SQL Programming with Packages
installing: 4.3. Installation Instructions, Advanced Oracle PL/SQL Programming with Packages
logging: (see logging)
loopexec procedure in: 11.7.4. Applying loopexec in PL/Vision, Advanced Oracle PL/SQL Programming with Packages
packages of
4.2. PL/Vision Package Bundles, Advanced Oracle PL/SQL Programming with Packages
4.3.5. Creating the PL/Vision Packages, Advanced Oracle PL/SQL Programming with Packages
5. PL/Vision Package Specifications, Advanced Oracle PL/SQL Programming with Packages
sharing among users: 4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
tracing: (see tracing)
PL/Vision Lite
4.2. PL/Vision Package Bundles, Advanced Oracle PL/SQL Programming with Packages
2.4.6. Problem-Solving Dynamic SQL Errors, Oracle Built-in Packages
PLEdit: 6.4. PL/SQL Tools, Oracle Web Applications
PLS-00452 error: 17.5.1.1. Pragma violation errors, Oracle PL/SQL Programming
PLSQL_TRACE_VERSION procedure, DBMS_TRACE package: 7.2.2. DBMS_TRACE Programs , Guide to Oracle8i Features
PLSXML utilities and demos: 9.6. PLSXML Utilities and Demos, Oracle Web Applications
PLS_INTEGER datatype
25.4.5. Use PLS_INTEGER for All Integer Operations, Oracle PL/SQL Programming
PLS_INTEGER datatype: 4.2.1.3. The PLS_INTEGER datatype, Oracle PL/SQL Programming
PLV package: 4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
constants and functions: 6. PLV: Top-Level Constants and Functions , Advanced Oracle PL/SQL Programming with Packages
PLV_token table: 10.2.1. Keeping Track of PL/SQL Keywords, Advanced Oracle PL/SQL Programming with Packages
PLVcase package
4.2.2. Developer Utilities, Advanced Oracle PL/SQL Programming with Packages
5.4. PLVcase: PL/SQL Code Conversion, Advanced Oracle PL/SQL Programming with Packages
18.1. PLVcase: Converting the Case of PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages
PLVcat package
4.2.2. Developer Utilities, Advanced Oracle PL/SQL Programming with Packages
5.5. PLVcat: PL/SQL Code Cataloguing, Advanced Oracle PL/SQL Programming with Packages
10.3.1. Selecting Token Types for Parsing, Advanced Oracle PL/SQL Programming with Packages
18.2. PLVcat: Cataloguing PL/SQL Source Code, Advanced Oracle PL/SQL Programming with Packages
references and dependencies: 18.2.4. Identifying References and Dependencies, Advanced Oracle PL/SQL Programming with Packages
PLVchar package: 4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
PLVchr package: 5.6. PLVchr: Operations on Single Characters, Advanced Oracle PL/SQL Programming with Packages
PLVcmt package
4.2.3. Plug-and-Play Components, Advanced Oracle PL/SQL Programming with Packages
5.7. PLVcmt: Commit Processing, Advanced Oracle PL/SQL Programming with Packages
20.1. PLVcmt: Enhancing Commit Processing, Advanced Oracle PL/SQL Programming with Packages
21.1.2.1. Using put_line, Advanced Oracle PL/SQL Programming with Packages
PLVctlg table: 18.2.2. The PLVcat Database Tables, Advanced Oracle PL/SQL Programming with Packages
PLVddd package
4.2.2. Developer Utilities, Advanced Oracle PL/SQL Programming with Packages
5.8. PLVddd: DDL Syntax Dump, Advanced Oracle PL/SQL Programming with Packages
PLVdyn package
About PL/Vision, Oracle Built-in Packages
2.7. Building Windows Into Your Packages, Advanced Oracle PL/SQL Programming with Packages
4.2.3. Plug-and-Play Components, Advanced Oracle PL/SQL Programming with Packages
4.4.1. Special Handling for PLVdyn, Advanced Oracle PL/SQL Programming with Packages
5.9. PLVdyn: Dynamic SQL Operations, Advanced Oracle PL/SQL Programming with Packages
19.4. PLVdyn: A Code Layer over DBMS_SQL, Advanced Oracle PL/SQL Programming with Packages
compiling code with: 19.4.1.7. Compiling source code with PLVdyn, Advanced Oracle PL/SQL Programming with Packages
displaying table contents: 19.5.7. Displaying a Table, Advanced Oracle PL/SQL Programming with Packages
schemas and: 19.5.10. Executing PLVdyn in Different Schemas, Advanced Oracle PL/SQL Programming with Packages
PLVdyn1 package: 4.2.3. Plug-and-Play Components, Advanced Oracle PL/SQL Programming with Packages
PLVexc package
4.2.3. Plug-and-Play Components, Advanced Oracle PL/SQL Programming with Packages
5.10. PLVexc: Exception Handling, Advanced Oracle PL/SQL Programming with Packages
16.3.5. Using the PLVexc Exception Handler, Advanced Oracle PL/SQL Programming with Packages
19.1. About Plug-and-Play, Advanced Oracle PL/SQL Programming with Packages
21.1.2.1. Using put_line, Advanced Oracle PL/SQL Programming with Packages
22. Exception Handling, Advanced Oracle PL/SQL Programming with Packages
PLVlog package and: 22.3.4.1. Leveraging PLVLog , Advanced Oracle PL/SQL Programming with Packages
PLVmsg with: 9.5. Integrating PLVmsg with Error Handling, Advanced Oracle PL/SQL Programming with Packages
PLVtrc package and: 22.1.6.5. Integrating PLVexc with PLVtrc , Advanced Oracle PL/SQL Programming with Packages
enhancing with PL/Vision: 22.3.4. Revamping the PLVexc Package, Advanced Oracle PL/SQL Programming with Packages
PLVfile package
About PL/Vision, Oracle Built-in Packages
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.11. PLVfile: Operating System I/O Manager, Advanced Oracle PL/SQL Programming with Packages
13. PLVfile: Reading and Writing Operating System Files, Advanced Oracle PL/SQL Programming with Packages
PLVfk package
4.2.3. Plug-and-Play Components, Advanced Oracle PL/SQL Programming with Packages
5.12. PLVfk: Foreign Key Interface, Advanced Oracle PL/SQL Programming with Packages
19.6. PLVfk: Generic Foreign Key Lookups, Advanced Oracle PL/SQL Programming with Packages
PLVgen package
2.2. Using Effective Coding Style for Packages, Advanced Oracle PL/SQL Programming with Packages
2.6.2. Toggles for Code Generation, Advanced Oracle PL/SQL Programming with Packages
4.2.2. Developer Utilities, Advanced Oracle PL/SQL Programming with Packages
5.13. PLVgen: PL/SQL Code Generator, Advanced Oracle PL/SQL Programming with Packages
16. PLVgen: Generating PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages
overloading in: 16.4.4. Overloading in PLVgen, Advanced Oracle PL/SQL Programming with Packages
PLVhlp package
4.2.2. Developer Utilities, Advanced Oracle PL/SQL Programming with Packages
4.4. Installing Online Help for PL/Vision, Advanced Oracle PL/SQL Programming with Packages
5.1. Common Package Elements, Advanced Oracle PL/SQL Programming with Packages
4.5. Using Online Help, Advanced Oracle PL/SQL Programming with Packages
5.14. PLVhlp: Online Help Architechture, Advanced Oracle PL/SQL Programming with Packages
12.1. Why PLVio?, Advanced Oracle PL/SQL Programming with Packages
16.2.5.1. Generating help text stubs, Advanced Oracle PL/SQL Programming with Packages
17. PLVhlp: Online Help for PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages
PLVio package
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.15. PLVio: Input/Output Processing, Advanced Oracle PL/SQL Programming with Packages
12. PLVio: Reading and Writing PL/SQL Source Code, Advanced Oracle PL/SQL Programming with Packages
PLVhlp package and: 17.5.5. Constructing an Online Help Package, Advanced Oracle PL/SQL Programming with Packages
PLVlex package
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.16. PLVlex: Lexical Analysis, Advanced Oracle PL/SQL Programming with Packages
PLVlog package
2.6.3. Changing Package Behavior Without Changing the Application, Advanced Oracle PL/SQL Programming with Packages
4.2.3. Plug-and-Play Components, Advanced Oracle PL/SQL Programming with Packages
5.17. PLVlog: Logging Facility, Advanced Oracle PL/SQL Programming with Packages
21.1. PLVlog: Logging Activity in PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages
PLVexc package and
22.1.7.1. Logging errors, Advanced Oracle PL/SQL Programming with Packages
22.3.4.1. Leveraging PLVLog , Advanced Oracle PL/SQL Programming with Packages
rollbacks: 21.1.5. Rolling Back with PLVlog, Advanced Oracle PL/SQL Programming with Packages
PLVlst package
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.18. PLVlst: List Manager, Advanced Oracle PL/SQL Programming with Packages
PLVmsg package
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.19. PLVmsg: Message Handling, Advanced Oracle PL/SQL Programming with Packages
9. PLVmsg: Single-Sourcing PL/SQL Message Text, Advanced Oracle PL/SQL Programming with Packages
22.1.6.4. Defining error messages with PLVmsg, Advanced Oracle PL/SQL Programming with Packages
PLVobj package
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.20. PLVobj: Object Interface, Advanced Oracle PL/SQL Programming with Packages
11. PLVobj: A Packaged Interface to ALL_OBJECTS, Advanced Oracle PL/SQL Programming with Packages
PLVprs package
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.21. PLVprs: String Parsing, Advanced Oracle PL/SQL Programming with Packages
10.1. PLVprs: Useful String Parsing Extensions, Advanced Oracle PL/SQL Programming with Packages
PLVrb package
10.3. PLVprsps: Parsing PL/SQL Strings, Advanced Oracle PL/SQL Programming with Packages
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
4.2.3. Plug-and-Play Components, Advanced Oracle PL/SQL Programming with Packages
5.23. PLVrb: Rollback Processing, Advanced Oracle PL/SQL Programming with Packages
20.2. PLVrb: Performing Rollbacks, Advanced Oracle PL/SQL Programming with Packages
PLVrfrnc table: 18.2.4.1. Examining the references, Advanced Oracle PL/SQL Programming with Packages
PLVstk package
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.24. PLVstk: Stack Manager, Advanced Oracle PL/SQL Programming with Packages
PLVtab package
2.6. Building Flexibility Into Your Packages, Advanced Oracle PL/SQL Programming with Packages
2.8.1.1. Supporting many data combinations, Advanced Oracle PL/SQL Programming with Packages
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.25. PLVtab: Table Interface, Advanced Oracle PL/SQL Programming with Packages
8. PLVtab: Easy Access to PL/SQL Tables, Advanced Oracle PL/SQL Programming with Packages
PLVtkn package
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.26. PLVtkn: Token Table Interface, Advanced Oracle PL/SQL Programming with Packages
10.2. PLVtkn: Managing PL/SQL Tokens, Advanced Oracle PL/SQL Programming with Packages
PLVtmr package
4.2.2. Developer Utilities, Advanced Oracle PL/SQL Programming with Packages
5.27. PLVtmr: Program Performance Analyzer, Advanced Oracle PL/SQL Programming with Packages
14. PLVtmr: Analyzing Program Performance, Advanced Oracle PL/SQL Programming with Packages
16.2.9. Generating a Timer Script, Advanced Oracle PL/SQL Programming with Packages
18.2.3.3. Examining the catalogue, Advanced Oracle PL/SQL Programming with Packages
19.5.5.3. The overhead of dynamic PL/SQL, Advanced Oracle PL/SQL Programming with Packages
PLVtrc package
4.2.3. Plug-and-Play Components, Advanced Oracle PL/SQL Programming with Packages
5.28. PLVtrc: Trace Facility, Advanced Oracle PL/SQL Programming with Packages
16.3.4. Using the Program Trace , Advanced Oracle PL/SQL Programming with Packages
21.2. PLVtrc: Tracing Execution of PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages
PLVexc package and: 22.1.6.5. Integrating PLVexc with PLVtrc , Advanced Oracle PL/SQL Programming with Packages
PLVvu package
4.2.2. Developer Utilities, Advanced Oracle PL/SQL Programming with Packages
5.29. PLVvu: Code and Error Viewing , Advanced Oracle PL/SQL Programming with Packages
15. PLVvu: Viewing Source Code and Compile Errors, Advanced Oracle PL/SQL Programming with Packages
17.2. Current Sources of Information, Advanced Oracle PL/SQL Programming with Packages
POLICY_NAME column, *_POLICIES data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
POP3: 1.3.1. The Internet File System, Oracle Web Applications
PORT_STRING function
10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.19. The DBMS_UTILITY.PORT_STRING function, Oracle Built-in Packages
C.16.10. The PORT_STRING function, Oracle PL/SQL Programming
POSITIVE datatype: 4.2.1.1. Binary integer datatypes, Oracle PL/SQL Programming
POWER function: 13.1.14. The POWER function, Oracle PL/SQL Programming
PRAGMA declaration
2.4. Rules and Restrictions, Guide to Oracle8i Features
2.2. Defining Autonomous Transactions, Guide to Oracle8i Features
2.6. The PRAGMA Keyword, Oracle PL/SQL Programming
PRINT function, HTF package: 7.1.3. HTF: Parsing HTML, Oracle Web Applications
PRINT function, HTP package: 7.1.1. HTP: Generating HTML, Oracle Web Applications
PRINT_CGI_ENV procedure: 7.4.1.2. Querying the environment, Oracle Web Applications
PRINT_MULTI, OWA_TEXT package: 7.2.1.2. Procedures, Oracle Web Applications
PRINT_ROW_LIST, OWA_TEXT package: 7.2.1.2. Procedures, Oracle Web Applications
PRIOR function
10.8.2.7. The PRIOR function, Oracle PL/SQL Programming
19.6.7. PRIOR(i), NEXT(i), Oracle PL/SQL Programming
PROGRAM_ERROR exception: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming
PUBLIC: 4.6.1. Sharing NDS Programs with Invoker Rights, Guide to Oracle8i Features
PURGE procedure: C.10.4. The PURGE procedure, Oracle PL/SQL Programming
PURGE procedure (DBMS_DEFER_SYS)
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.6.2. The DBMS_DEFER_SYS.PURGE function (Oracle8 only), Oracle Built-in Packages
PURGE procedure (DBMS_PIPE)
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.3.4. The DBMS_PIPE.PURGE procedure, Oracle Built-in Packages
PURGE_LOG procedure
14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
14.1.4. Purging the Snapshot Log, Oracle Built-in Packages
C.13.3. The PURGE_LOG procedure, Oracle PL/SQL Programming
PURGE_LOST_DB procedure: C.15.16. The PURGE_LOST_DB procedure , Oracle PL/SQL Programming
PURGE_LOST_DB_ENTRY procedure
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure, Oracle Built-in Packages
PURGE_MASTER_LOG procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.6.3. The DBMS_REPCAT.PURGE_MASTER_LOG procedure, Oracle Built-in Packages
PURGE_MIXED procedure
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.6.1. The DBMS_TRANSACTION.PURGE_MIXED procedure, Oracle Built-in Packages
C.15.15. The PURGE_MIXED procedure, Oracle PL/SQL Programming
PURGE_STATISTICS procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.6.1.3. The DBMS_REPCAT.PURGE_STATISTICS procedure, Oracle Built-in Packages
PUSH function
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.6.3. The DBMS_DEFER_SYS.PUSH function, Oracle Built-in Packages
PUT procedure: C.17.1.8. The PUT procedure, Oracle PL/SQL Programming
PUT procedure (DBMS_OUTPUT)
6.1.1.1. DBMS_OUTPUT programs, Oracle Built-in Packages
6.1.3.1. The DBMS_OUTPUT.PUT procedure, Oracle Built-in Packages
PUT procedure (UTL_FILE)
6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
6.2.4.1. The UTL_FILE.PUT procedure, Oracle Built-in Packages
PUTF procedure: C.17.1.9. The PUTF procedure, Oracle PL/SQL Programming
PUTF procedure (UTL_FILE)
6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
6.2.4.4. The UTL_FILE.PUTF procedure, Oracle Built-in Packages
PUT_LINE function
7. p: A Powerful Substitute for DBMS_OUTPUT, Advanced Oracle PL/SQL Programming with Packages
23.1.2. Executing Functions, Oracle PL/SQL Programming
PUT_LINE package
(see also p package)
5.2. p: a DBMS_OUTPUT Substitute, Advanced Oracle PL/SQL Programming with Packages
PUT_LINE procedure
2.8.1.1. Supporting many data combinations, Advanced Oracle PL/SQL Programming with Packages
C.9.7. The PUT_LINE procedure, Oracle PL/SQL Programming
C.17.1.10. The PUT_LINE procedure, Oracle PL/SQL Programming
PUT_LINE procedure (DBMS_OUTPUT)
6.2. Database-Level Event Triggers, Guide to Oracle8i Features
9.3.3. Compiling and Loading into Oracle, Guide to Oracle8i Features
6.1.1.1. DBMS_OUTPUT programs, Oracle Built-in Packages
6.1.3.2. The DBMS_OUTPUT.PUT_LINE procedure, Oracle Built-in Packages
PUT_LINE procedure (UTL_FILE)
6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
6.2.4.3. The UTL_FILE.PUT_LINE procedure, Oracle Built-in Packages
PalmPilots: 1.1. The Internet Grows Up, Oracle Web Applications
Perl: 2.1. Resources, Oracle Web Applications
Personal Data Assistants (PDAs): 1.1. The Internet Grows Up, Oracle Web Applications
Post-Query trigger: 6.3.2.1. Inefficiencies of implicit cursors, Oracle PL/SQL Programming
PowerPoint: 1.3.9.1. Text data, Oracle Web Applications
Procedural Language: 6. PL/SQL, Oracle Web Applications
Program Global Area (PGA): 25.3.1. Use Package Data to Minimize SQL Access, Oracle PL/SQL Programming
Programming Companion Utilities Guide: A. What's on the Companion Disk?, Oracle PL/SQL Programming
p package
2.8.1.1. Supporting many data combinations, Advanced Oracle PL/SQL Programming with Packages
4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
5.2. p: a DBMS_OUTPUT Substitute, Advanced Oracle PL/SQL Programming with Packages
7. p: A Powerful Substitute for DBMS_OUTPUT, Advanced Oracle PL/SQL Programming with Packages
l: (see l procedure)
output from: 7.4. Controlling Output from p, Advanced Oracle PL/SQL Programming with Packages
p package (PL/Vision)
6.1.6.1. Encapsulating DBMS_OUTPUT, Oracle Built-in Packages
About PL/Vision, Oracle Built-in Packages
pack_from_tbl procedure: 3.1.7.3. The dbpipe utility package, Oracle Built-in Packages
pack_send_friend procedure
3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure, Oracle Built-in Packages
3.1.6.1. Defining message types and encapsulating communications logic, Oracle Built-in Packages
pack_send_request procedure
3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure, Oracle Built-in Packages
3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function, Oracle Built-in Packages
3.1.7.5. The pipesvr package, Oracle Built-in Packages
pack_send_status procedure: 3.1.7.5. The pipesvr package, Oracle Built-in Packages
package body, definition: 1.3.1. What Is a Package?, Oracle Built-in Packages
package libraries: 1.5.2. Prebuilt Packages, Advanced Oracle PL/SQL Programming with Packages
package names, returning: 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages
package specification, definition: 1.3.1. What Is a Package?, Oracle Built-in Packages
package variables, stored functions and: 17.4. Restrictions on PL/SQL Functions in SQL, Oracle PL/SQL Programming
package wizard, WebDB: 3.1.2.1. Building database objects, Oracle Web Applications
package-defined exceptions
1.3.4. Exception Handling and Built-in Packages, Oracle Built-in Packages
1.3.4.2. Package-defined exception, Oracle Built-in Packages
package-named system exceptions
1.3.4. Exception Handling and Built-in Packages, Oracle Built-in Packages
1.3.4.1. Package-named system exception, Oracle Built-in Packages
package-specific exceptions
1.3.4. Exception Handling and Built-in Packages, Oracle Built-in Packages
1.3.4.4. Package-specific exception, Oracle Built-in Packages
Oracle Developer/2000 and: 1.3.6.2. Handling exceptions in Oracle Developer/2000 Release 1, Oracle Built-in Packages
packages
(see also modularizing, under specific package name, built-in packages)
A.1.6. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.1. What Is a PL/SQL Package?, Advanced Oracle PL/SQL Programming with Packages
2.9. Modularizing for Maintainable Packages, Advanced Oracle PL/SQL Programming with Packages
5.13.6. Generating a package, Advanced Oracle PL/SQL Programming with Packages
1.3.1. What Is a Package?, Oracle Built-in Packages
1.4.3.10. Modular construction, Oracle PL/SQL Programming
1.6.8. Packages, Oracle PL/SQL Programming
16. Packages, Oracle PL/SQL Programming
6.3. Packages, Oracle Web Applications
Booch diagram: 16.2.4. Public and Private Package Elements, Oracle PL/SQL Programming
PL/SQL: 19.2. Declarative Programming in PL/SQL, Advanced Oracle PL/SQL Programming with Packages
PLVctlg table: 18.2.2.1. PLVctlg table, Advanced Oracle PL/SQL Programming with Packages
STANDARD: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming
access to elements: 1.4.4. Access to Package Elements, Advanced Oracle PL/SQL Programming with Packages
building: 1.6. Building Packages, Advanced Oracle PL/SQL Programming with Packages
built-in
A.2.6. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.4.3.6. Built-in packages, Oracle PL/SQL Programming
1.6.3. Built-in packages, Oracle PL/SQL Programming
reference on: C. Built-In Packages, Oracle PL/SQL Programming
codependency: 2.4.1. Creating Codependent Packages, Advanced Oracle PL/SQL Programming with Packages
controlling use of elements: 1.3.2. Controlling Access with Packages, Oracle Built-in Packages
cursors in: 6.4.4. The Cursor RETURN Clause, Oracle PL/SQL Programming
data structures in: 16.5. Package Data, Oracle PL/SQL Programming
debugging messages in: 24.2.9. Build Debugging Messages into Your Packages, Oracle PL/SQL Programming
declaring cursors in: 16.3.2. Declaring Package Cursors, Oracle PL/SQL Programming
description: 1.3.1. What Is a Package?, Oracle Built-in Packages
developing around: 1.7.3. Center All Development Around Packages, Oracle PL/SQL Programming
documenting: 3.7. Documenting the Entire Package, Oracle PL/SQL Programming
dot notation for referencing elements: 1.3.3. Referencing Built-in Package Elements, Oracle Built-in Packages
effective coding of: 2. Best Practices for Packages, Advanced Oracle PL/SQL Programming with Packages
encapsulating data structure access: 1.7.2. Synchronize Program and Data Structures, Oracle PL/SQL Programming
exception handling, identifying cause of: 1.3.4.5. Same exception, different causes, Oracle Built-in Packages
exception section: 1.6.3.2. The exception section, Advanced Oracle PL/SQL Programming with Packages
flexibility: 2.6. Building Flexibility Into Your Packages, Advanced Oracle PL/SQL Programming with Packages
formatting: 3.5. Formatting Packages, Oracle PL/SQL Programming
functions in, calling: 17.5. Calling Packaged Functions in SQL, Oracle PL/SQL Programming
generating: 16.2.1. Generating a Package, Advanced Oracle PL/SQL Programming with Packages
granting execute authority to: 23.2.1. Execute Authority on Stored Objects, Oracle PL/SQL Programming
help: (see documentation)
hiding elements of
1.3.1. Enforced Information Hiding, Advanced Oracle PL/SQL Programming with Packages
2.7. Building Windows Into Your Packages, Advanced Oracle PL/SQL Programming with Packages
2.10. Hiding Package Data, Advanced Oracle PL/SQL Programming with Packages
in PL/Vision
4.2. PL/Vision Package Bundles, Advanced Oracle PL/SQL Programming with Packages
4.3.5. Creating the PL/Vision Packages, Advanced Oracle PL/SQL Programming with Packages
5. PL/Vision Package Specifications, Advanced Oracle PL/SQL Programming with Packages
initializing
1.6.3. The Initialization Section, Advanced Oracle PL/SQL Programming with Packages
1.6.5.2. Asserting the purity level of the initialization section, Advanced Oracle PL/SQL Programming with Packages
16.6. Package Initialization, Oracle PL/SQL Programming
purity level assertions in: 17.5.2. Asserting Purity Level with Package Initialization Section, Oracle PL/SQL Programming
interface
2.5. Constructing the Optimal Interface to Your Package, Advanced Oracle PL/SQL Programming with Packages
2.10.3. Simplifying Package Interfaces, Advanced Oracle PL/SQL Programming with Packages
layering: 2.9. Modularizing for Maintainable Packages, Advanced Oracle PL/SQL Programming with Packages
memory architecture: 1.4.3. The Memory-Resident Architecture of Packages, Advanced Oracle PL/SQL Programming with Packages
memory requirements: 4.3.2. Storage Requirements, Advanced Oracle PL/SQL Programming with Packages
minimizing interdependencies: 25.2.4. Creating Packages with Minimal Interdependencies, Oracle PL/SQL Programming
modifying persistent objects: 18.5.4. Approach 4: Use an Object and a PL/SQL Container Package, Oracle PL/SQL Programming
multiple, constructing: 2.11. Simultaneous Construction of Multiple Packages, Advanced Oracle PL/SQL Programming with Packages
naming
2.3. Selecting Package Names, Advanced Oracle PL/SQL Programming with Packages
22.1.3. Name Packages and Their Elements to Reflect the Packaged Structure, Oracle PL/SQL Programming
numbers-to-words: 17.8.7. Recursive Processing in a SQL Statement, Oracle PL/SQL Programming
of exceptions only: 16.3.1.1. A package of exceptions, Oracle PL/SQL Programming
of magic values only: 16.3.1.2. A package of magic values, Oracle PL/SQL Programming
online help: (see PLVhlp package)
ordering elements of: 2.2.1. Choosing the Order of Elements, Advanced Oracle PL/SQL Programming with Packages
package body
1.6. Building Packages, Advanced Oracle PL/SQL Programming with Packages
1.6.2. The Package Body, Advanced Oracle PL/SQL Programming with Packages
package specification
1.4.1. The Package Specification, Advanced Oracle PL/SQL Programming with Packages
1.6. Building Packages, Advanced Oracle PL/SQL Programming with Packages
pinning
(see also shared pool)
into SGA shared pool: 25.2.2. Pin Critical Code into the SGA, Oracle PL/SQL Programming
public versus private elements: 16.2.4. Public and Private Package Elements, Oracle PL/SQL Programming
purity level of: 17.5.1. The RESTRICT_REFERENCES Pragma, Oracle PL/SQL Programming
recompiling
2.4. Organizing Package Source Code, Advanced Oracle PL/SQL Programming with Packages
10.3.2. Compiling PL/SQL Objects, Oracle Built-in Packages
referencing elements of
1.4.2. Referencing Package Elements, Advanced Oracle PL/SQL Programming with Packages
1.3.3. Referencing Built-in Package Elements, Oracle Built-in Packages
23.1.4. Key Concepts for Program Execution, Oracle PL/SQL Programming
refresh state: 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function, Oracle Built-in Packages
replicated packages: 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages
resetting state: 11.1.4.3. The DBMS_SESSION.RESET_PACKAGE procedure, Oracle Built-in Packages
rights models: 18.3.7.3. Rights model, Oracle PL/SQL Programming
specification
16.2.1. The Specification, Oracle PL/SQL Programming
16.3. The Package Specification, Oracle PL/SQL Programming
storing spefifications for: 1.7.3. Center All Development Around Packages, Oracle PL/SQL Programming
synchronizing body and specification: 16.4.2. Synchronize Body with Package, Oracle PL/SQL Programming
synonyms for: 4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
toggles in: 1.7.3. Center All Development Around Packages, Oracle PL/SQL Programming
variable persistence: 6.3.6. Variable Persistence Throughout a Session, Oracle Web Applications
variables in: B.2.2. No Direct Stored Package Variable References, Oracle PL/SQL Programming
reducing memory usage of: 25.2.5. Reducing Memory Usage of Package Variables, Oracle PL/SQL Programming
windows in: 2.7. Building Windows Into Your Packages, Advanced Oracle PL/SQL Programming with Packages
working with large: 1.6.4. Working with Large Packages, Advanced Oracle PL/SQL Programming with Packages
padding strings
11.1.11. The RPAD function, Oracle PL/SQL Programming
11.1.8. The LPAD function, Oracle PL/SQL Programming
page size
17.4.2. Setting the Page Size, Advanced Oracle PL/SQL Programming with Packages
17.5.6.4. Maintaining the current page variables, Advanced Oracle PL/SQL Programming with Packages
online help: 5.14.2. Setting the page size, Advanced Oracle PL/SQL Programming with Packages
pagesize function: 17.4.2. Setting the Page Size, Advanced Oracle PL/SQL Programming with Packages
paragraphs
5.21.2. Wrapping long strings into paragraphs , Advanced Oracle PL/SQL Programming with Packages
10.1.4. Wrapping Strings into Paragraphs, Advanced Oracle PL/SQL Programming with Packages
parallel server mode, testing for: 10.1.2.15. The DBMS_UTILITY.IS_PARALLEL_SERVER function, Oracle Built-in Packages
parallelization of programs: 1.5.1.1. Leveraging builtin packages, Advanced Oracle PL/SQL Programming with Packages
parameter arrays: 2.4.3.3. Parameter arrays, Oracle Web Applications
parameter list: 16.2.2.2. A procedure with parameter list and executable code, Advanced Oracle PL/SQL Programming with Packages
parameter name, PL/SQL: 6.1.3. Parameters, Oracle Web Applications
parameters
(see also initialization parameters)
10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function , Oracle Built-in Packages
15.6. Parameters, Oracle PL/SQL Programming
ANY parameters: 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4), Oracle Built-in Packages
Boolean: 22.7.2. Use Self-Identifying Parameters (Avoid Boolean Values), Oracle PL/SQL Programming
IN OUT mode
15.6.2.3. The IN OUT mode, Oracle PL/SQL Programming
22.7.3. Assign Values to All OUT and IN OUT Parameters, Oracle PL/SQL Programming
IN mode: 15.6.2.1. IN mode, Oracle PL/SQL Programming
OUT mode
15.6.2.2. OUT mode, Oracle PL/SQL Programming
22.7.3. Assign Values to All OUT and IN OUT Parameters, Oracle PL/SQL Programming
accepted in PARAMETERS clause: 21.4.3. Properties, Oracle PL/SQL Programming
actual versus formal: 15.6.3. Actual and Formal Parameters, Oracle PL/SQL Programming
case consistency of: 22.7.4. Ensure Case Consistency of Parameters, Oracle PL/SQL Programming
cursor: 6.10. Cursor Parameters, Oracle PL/SQL Programming
declaring: 21.4.4. Correct Declaration of Properties, Oracle PL/SQL Programming
default values of
B.2.4. No Default Parameter Values, Oracle PL/SQL Programming
15.6.5. Default Values, Oracle PL/SQL Programming
22.7.5. Default Values and Remote Procedure Calls, Oracle PL/SQL Programming
describing: 10.2. DBMS_DESCRIBE: Describing PL/SQL Program Headers, Oracle Built-in Packages
design tips for: 22.7. Tips for Parameter Design, Oracle PL/SQL Programming
documenting: 22.7.1. Document All Parameters and Their Functions, Oracle PL/SQL Programming
for overloaded modules: 15.8.4. Restrictions on Overloading, Oracle PL/SQL Programming
increasing number of: 22.5.3. Use Parameters Liberally , Oracle PL/SQL Programming
mapping for external procedures: 21.4. Mapping Parameters, Oracle PL/SQL Programming
module, collections as: 19.2.2.3. Collections as module parameters, Oracle PL/SQL Programming
modules without: 22.4. Be Wary of Modules Without Any Parameters , Oracle PL/SQL Programming
naming: 22.1.2. Develop Consistent Naming Conventions for Your Formal Parameters , Oracle PL/SQL Programming
optional: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
package data and: 25.4.4. Use Package Data to Avoid Passing "Bulky" Parameter Values, Oracle PL/SQL Programming
passing: 4.2.2. Parameter Passing, Oracle Web Applications
passing by reference: 21.4.2. More Syntax: The PARAMETERS Clause, Oracle PL/SQL Programming
PL/SQL: 6.1.3. Parameters, Oracle Web Applications
tables as: 10.5.4. Passing PL/SQL Tables as Parameters, Oracle PL/SQL Programming
validating with assertion modules: 22.2.4. Use Assertion Modules to Validate Parameters and Assumptions, Oracle PL/SQL Programming
parent block: (see nested blocks)
parse procedure: 2.4.6. Problem-Solving Dynamic SQL Errors, Oracle Built-in Packages
parse tree: 1.6.4. Working with Large Packages, Advanced Oracle PL/SQL Programming with Packages
parse_delete procedure
5.9.3. Bundled, low-level operations, Advanced Oracle PL/SQL Programming with Packages
19.5.6.3. Parse for delete, Advanced Oracle PL/SQL Programming with Packages
parse_long_one procedure: 2.3.3.2. Parsing very long SQL statements, Oracle Built-in Packages
parse_name procedure
5.11.13. Miscellaneous operations, Advanced Oracle PL/SQL Programming with Packages
13.2.3. Parsing the File Name, Advanced Oracle PL/SQL Programming with Packages
parsing
PL/SQL code: 10.3.2. Parsing PL/SQL Code, Advanced Oracle PL/SQL Programming with Packages
code: 5.22. PLVprsps: PL/SQL Source Code Parsing, Advanced Oracle PL/SQL Programming with Packages
delimiter, defining: 10.1.2. Customizing the Delimiter Set, Advanced Oracle PL/SQL Programming with Packages
file name: 13.2.3. Parsing the File Name, Advanced Oracle PL/SQL Programming with Packages
HTML: 7.1.3. HTF: Parsing HTML, Oracle Web Applications
program names: 11.3.2. Converting the Program Name, Advanced Oracle PL/SQL Programming with Packages
SQL statements
(see also deferred parsing; SQL statements, parsing)
6.2.2. Cursor Operations, Oracle PL/SQL Programming
strings
5.16. PLVlex: Lexical Analysis, Advanced Oracle PL/SQL Programming with Packages
5.21. PLVprs: String Parsing, Advanced Oracle PL/SQL Programming with Packages
11.2.1. Parsing a Name, Oracle PL/SQL Programming
10. PLVprs, PLVtkn, and PLVprsps: Parsing Strings, Advanced Oracle PL/SQL Programming with Packages
parslong.sp : 2.3.3.2. Parsing very long SQL statements, Oracle Built-in Packages
part-of relationship: 18.1.4.3. Inheritance , Oracle PL/SQL Programming
partial installation: 4.4.4. A Warning About Partial Installation , Advanced Oracle PL/SQL Programming with Packages
partitioned objects, analyzing: 10.1.2.3. The DBMS_UTILITY.ANALYZE_PART_OBJECT procedure (Oracle8 Only), Oracle Built-in Packages
partitioned tables
ROWID datatype for: 4.2.3.6. The ROWID datatype, Oracle PL/SQL Programming
to store array: 10.9.4.2. Partitioning a PL/SQL table to store an array, Oracle PL/SQL Programming
passing
collection arguments: 19.8.3. Call by Reference or Call by Value, Oracle PL/SQL Programming
parameters by reference: 21.4.2. More Syntax: The PARAMETERS Clause, Oracle PL/SQL Programming
path function: 6.2.6.4. Adding support for paths, Oracle Built-in Packages
path, URL: 2.2.5. The Uniform Resource Locator, Oracle Web Applications
pathnames, UTL_FILE enhancement: 6.2.6.4. Adding support for paths, Oracle Built-in Packages
pause procedure
5.3.6. Miscellaneous programs, Advanced Oracle PL/SQL Programming with Packages
6.4.4. Pausing Your Program, Advanced Oracle PL/SQL Programming with Packages
pausing help text: (see more procedure)
pausing programs
5.3.6. Miscellaneous programs, Advanced Oracle PL/SQL Programming with Packages
A.2.6. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
6.4.4. Pausing Your Program, Advanced Oracle PL/SQL Programming with Packages
payload: (see messages (AQ); queues)
payload types: 5.3.3. Queue Type Names, Oracle Built-in Packages
pcex1.sql : 12.1.2.1. The DBMS_SPACE.FREE_BLOCKS procedure, Oracle Built-in Packages
peek procedure: 3.1.7.3. The dbpipe utility package, Oracle Built-in Packages
peers: (see master sites)
percent (multiple-character substitution): 5.7.5.1. Wildcarded correlation identifiers, Oracle Built-in Packages
perform_commit procedure
5.7.3. Performing commits, Advanced Oracle PL/SQL Programming with Packages
20.1.2. The COMMIT Substitute, Advanced Oracle PL/SQL Programming with Packages
perform_rollback function
5.23.3. Performing rollbacks, Advanced Oracle PL/SQL Programming with Packages
20.2.4. Performing Rollbacks, Advanced Oracle PL/SQL Programming with Packages
performance
A.2.6. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.3.6. Performance Improvement, Advanced Oracle PL/SQL Programming with Packages
3.10. Choosing the Best Performer, Advanced Oracle PL/SQL Programming with Packages
5.27.6. Calibration and timing scripts, Advanced Oracle PL/SQL Programming with Packages
14. PLVtmr: Analyzing Program Performance, Advanced Oracle PL/SQL Programming with Packages
DBMS_SQL used for improving: 2.4.5. Improving the Performance of Dynamic SQL, Oracle Built-in Packages
analyzing: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming
array fetching and: 2.5.6.4. Using array processing to fetch, Oracle Built-in Packages
dynamic PL/SQL: 19.5.5.3. The overhead of dynamic PL/SQL, Advanced Oracle PL/SQL Programming with Packages
implicit cursors and: 6.3.2.1. Inefficiencies of implicit cursors, Oracle PL/SQL Programming
implicit data conversions and: 4.2.8.3. Drawbacks of implicit conversions, Oracle PL/SQL Programming
local variables and: 25.4.3. Rely on Local Variables to Improve Performance, Oracle PL/SQL Programming
package data and: 25.4.4. Use Package Data to Avoid Passing "Bulky" Parameter Values, Oracle PL/SQL Programming
package size: 1.6.4. Working with Large Packages, Advanced Oracle PL/SQL Programming with Packages
session identifiers and: 11.1.5.4. The sid function, Oracle Built-in Packages
stored functions and: 17.1. Looking at the Problem, Oracle PL/SQL Programming
performance analysis
(see also statistics)
7. Defining an Application Profile, Oracle Built-in Packages
DBMS_APPLICATION_INFO used for
7. Defining an Application Profile, Oracle Built-in Packages
7.3. DBMS_APPLICATION_INFO Examples , Oracle Built-in Packages
7.3.7. Monitoring Application SQL Resource Consumption, Oracle Built-in Packages
7.3.8. Session Monitoring and Three-Tier Architectures, Oracle Built-in Packages
hashing (example): 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function, Oracle Built-in Packages
storing information for (example): 7.3.3. The set_stats Procedure, Oracle Built-in Packages
performance time, using progress box: 22.6.3. Progress Box as ADT, Oracle PL/SQL Programming
permissions
(see also access)
permissions, PL/SQL: 6.1.6. Permissions, Oracle Web Applications
persistence
1.3.4. Object Persistence, Advanced Oracle PL/SQL Programming with Packages
1.6.1.3. Need global data structures for your PL/SQL programs, Advanced Oracle PL/SQL Programming with Packages
REFs and: 18.2.3. Adding Complex Data Structures, Oracle PL/SQL Programming
encapsulation and: 18.2.2.2. DDL usage , Oracle PL/SQL Programming
persistent LOBs: 7.5.2. DBMS_LOB: Working with Temporary LOBs, Guide to Oracle8i Features
persistent objects
modifying: 18.5. Modifying Persistent Objects, Oracle PL/SQL Programming
referring to: 18.4.2. OID, VALUE, REF, and DEREF, Oracle PL/SQL Programming
perspectives, WebDB: 3.1.3.2. Managing content, Oracle Web Applications
pessimistic locking: 7.3.2. OWA_OPT_LOCK: Record Locking, Oracle Web Applications
phonetic string comparisons: 11.1.13. The SOUNDEX function, Oracle PL/SQL Programming
physical directories, WebDB: 3.2.3.2. Virtual directory mappings, Oracle Web Applications
pinning
(see also shared pool)
code into memory: 1.4.3.1. Managing packages in shared memory, Advanced Oracle PL/SQL Programming with Packages 25.2.2. Pin Critical Code into the SGA, Oracle PL/SQL Programming
packages on database startup: 6.2.1.1. Pinning packages on database startup, Guide to Oracle8i Features
pipe1 procedure: 3.1.7.2. Exploring DBMS_PIPE , Oracle Built-in Packages
pipe1.sql : 3.1.7.2. Exploring DBMS_PIPE , Oracle Built-in Packages
pipe2.sql : 3.1.7.2. Exploring DBMS_PIPE , Oracle Built-in Packages
pipenames: 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function, Oracle Built-in Packages
pipes
(see also DBMS_PIPE package; message buffers; messages (pipes)
3.1. DBMS_PIPE: Communicating Between Sessions , Oracle Built-in Packages
6.2.1.3. Trapping system errors, Guide to Oracle8i Features
advanced queuing versus: 3.1.2.3. Pipe communications logic, Oracle Built-in Packages
creating
3.1.3.1. The DBMS_PIPE.CREATE_PIPE function, Oracle Built-in Packages
3.1.3.4. The DBMS_PIPE.PURGE procedure, Oracle Built-in Packages
3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function, Oracle Built-in Packages
RECEIVE_MESSAGE and: 3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function, Oracle Built-in Packages
SEND_MESSAGE and: 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function, Oracle Built-in Packages
encapsulating pack/send and receive/unpack: 3.1.7.5. The pipesvr package, Oracle Built-in Packages
implementation of: 3.1.2. How Database Pipes Work, Oracle Built-in Packages
job queue and: 13. Job Scheduling in the Database, Oracle Built-in Packages
memory for
allocating: 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function, Oracle Built-in Packages
freeing
3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function, Oracle Built-in Packages
3.1.3.4. The DBMS_PIPE.PURGE procedure, Oracle Built-in Packages
tips about: 3.1.6.6. Sizing and removing pipes for good memory management, Oracle Built-in Packages
names for: 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function, Oracle Built-in Packages
packing/unpacking relationship: 3.1.7.2. Exploring DBMS_PIPE , Oracle Built-in Packages
purging: 3.1.3.4. The DBMS_PIPE.PURGE procedure, Oracle Built-in Packages
removing: 3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function, Oracle Built-in Packages
separating messages for specific recipients: 3.1.6.2. Separating messages, Oracle Built-in Packages
timeouts
3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function, Oracle Built-in Packages
3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function, Oracle Built-in Packages
3.1.6.4. Paying attention to timeouts, Oracle Built-in Packages
unique session names, returning: 3.1.3.5. The DBMS_PIPE.UNIQUE_SESSION_NAME function, Oracle Built-in Packages
utility package: 3.1.7.3. The dbpipe utility package, Oracle Built-in Packages
pipesvr package
(see also specific program names)
3.1.7.5. The pipesvr package, Oracle Built-in Packages
pipesvr.sql
3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure, Oracle Built-in Packages
3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function, Oracle Built-in Packages
3.1.7.5. The pipesvr package, Oracle Built-in Packages
pipex1.sql
3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure, Oracle Built-in Packages
3.1.6.1. Defining message types and encapsulating communications logic, Oracle Built-in Packages
pipex2.sql : 3.1.4.7. The DBMS_PIPE.NEXT_ITEM_TYPE function, Oracle Built-in Packages
pkg procedure
5.13.6. Generating a package, Advanced Oracle PL/SQL Programming with Packages
16.2.1. Generating a Package, Advanced Oracle PL/SQL Programming with Packages
pky procedure: 5.8.3. Dumping the DDL, Advanced Oracle PL/SQL Programming with Packages
pl procedure: 6.1.6.1. Encapsulating DBMS_OUTPUT, Oracle Built-in Packages
pl/sql_statement, trigger syntax: 6.3. Schema-Level Event Triggers, Guide to Oracle8i Features
place_bid procedure: 3.2.3.5. The auction package, Oracle Built-in Packages
placeholder function: 5.9.7. Miscellaneous programs, Advanced Oracle PL/SQL Programming with Packages
placeholders: (see host variables)
plsql procedure
5.8.3. Dumping the DDL, Advanced Oracle PL/SQL Programming with Packages
5.9.6. Executing dynamic PL/SQL, Advanced Oracle PL/SQL Programming with Packages
19.5.5. Executing Dynamic PL/SQL Code, Advanced Oracle PL/SQL Programming with Packages
plsql_block function
5.9.7. Miscellaneous programs, Advanced Oracle PL/SQL Programming with Packages
19.5.5.1. Implementation of PLVdyn.plsql, Advanced Oracle PL/SQL Programming with Packages
plsql_delimiters constant
5.21.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
10.1.2. Customizing the Delimiter Set, Advanced Oracle PL/SQL Programming with Packages
plsql_identifier variable
5.3.2. Anchoring datatypes, Advanced Oracle PL/SQL Programming with Packages
6.5. The Predefined Datatypes, Advanced Oracle PL/SQL Programming with Packages
19.5.5.2. Scope of a dynamic PL/SQL block, Advanced Oracle PL/SQL Programming with Packages
plsql_package parameter, CREAT _CONTEXT statement: 8.2. CREATE CONTEXT: Creating Contexts, Guide to Oracle8i Features
plsql_profiler_data table: 7.1.2. Installing DBMS_PROFILER, Guide to Oracle8i Features
plsql_profiler_runs table: 7.1.2. Installing DBMS_PROFILER, Guide to Oracle8i Features
plsql_profiler_units table: 7.1.2. Installing DBMS_PROFILER, Guide to Oracle8i Features
plsql_string procedure
5.22.3. Parsing PL/SQL source code, Advanced Oracle PL/SQL Programming with Packages
10.3.2.1. plsql_string procedure, Advanced Oracle PL/SQL Programming with Packages
plsqlarray.sp : 2.5.6.5. Using array processing in dynamic PL/SQL , Oracle Built-in Packages
plug-and-play packages
4.2.3. Plug-and-Play Components, Advanced Oracle PL/SQL Programming with Packages
19. PLVdyn and PLVfk: Dynamic SQL and PL/SQL, Advanced Oracle PL/SQL Programming with Packages
plvcat.sql script: 18.2.3.4. Cataloguing PL/Vision, Advanced Oracle PL/SQL Programming with Packages
plvgrant.sql script : 4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
plvins23.sql script : 4.3.5. Creating the PL/Vision Packages, Advanced Oracle PL/SQL Programming with Packages
plvinst.sql script: 4.3.5. Creating the PL/Vision Packages, Advanced Oracle PL/SQL Programming with Packages
plvpsyn.sql script: 4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
pointers to objects: (see REFs)
policy_function parameter, ADD_POLICY procedure: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features
policy_name parameter, ADD_POLICY procedure: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features
polymorphism: 18.1.4.4. Polymorphism , Oracle PL/SQL Programming
pop procedure
5.24.3. Modifying stack contents, Advanced Oracle PL/SQL Programming with Packages
5.7.3. Building a Stack with AQ Using Sequence Deviation, Oracle Built-in Packages
port: 2.2.5. The Uniform Resource Locator, Oracle Web Applications
portability: 1.3.1. Improved Application Portability with PL/SQL, Oracle PL/SQL Programming
positional notation: 6.1.4.1. Positional notation, Oracle Web Applications
post-insert savepoint: 21.1.5.7. Setting the post-insert savepoint, Advanced Oracle PL/SQL Programming with Packages
pragmas
1.6.5.1. RESTRICT_REFERENCES pragma, Advanced Oracle PL/SQL Programming with Packages
2.2. Defining Autonomous Transactions, Guide to Oracle8i Features
2.4. Rules and Restrictions, Guide to Oracle8i Features
EXCEPTION_INIT
5.10.2. Package-based exceptions, Advanced Oracle PL/SQL Programming with Packages
8.3.3.1. The EXCEPTION_INIT pragma, Oracle PL/SQL Programming
packaged programs and: 1.3.7. Accessing Built-in Packaged Technology from Within SQL, Oracle Built-in Packages
RESTRICT_REFERENCES
17.3. Requirements for Stored Functions in SQL, Oracle PL/SQL Programming
17.5.1. The RESTRICT_REFERENCES Pragma, Oracle PL/SQL Programming
17.7.1. Manual Application of Pragmas, Oracle PL/SQL Programming
prebuilt packages: 1.5.2. Prebuilt Packages, Advanced Oracle PL/SQL Programming with Packages
precedence identifiers in cursors: 6.4.3. Identifier Precedence in a Cursor, Oracle PL/SQL Programming
precision: 4.2.1.2. Decimal numeric datatypes, Oracle PL/SQL Programming
predefined exceptions: 22.1.3. Impact of Predefined Exceptions, Advanced Oracle PL/SQL Programming with Packages
predefined system exceptions: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming
prefix table row value: 8.5. Setting the Display Prefix, Advanced Oracle PL/SQL Programming with Packages
prefix function
5.2.3. Setting the line prefix, Advanced Oracle PL/SQL Programming with Packages
5.25.6. Setting the row prefix, Advanced Oracle PL/SQL Programming with Packages
prefixes to package element names: 2.3.3. Avoiding Superfluous Naming Elements, Advanced Oracle PL/SQL Programming with Packages
prependitem procedure: 5.18.3. Modifying list contents , Advanced Oracle PL/SQL Programming with Packages
prevmod function
5.28.6. Tracing PL/SQL code execution, Advanced Oracle PL/SQL Programming with Packages
21.2.4.4. Previous module, Advanced Oracle PL/SQL Programming with Packages
primary_instance parameter, CREATE_QUEUE_TABLE procedure: 7.6.1. CREATE_QUEUE_TABLE and MIGRATE_QUEUE_TABLE: Setting Version Compatibility and Queue Migration, Guide to Oracle8i Features
print_answers procedure, EMP_SURVEY package: 8.2.4. The EMP_SURVEY Package, Oracle Web Applications
print_input_row procedure, GENERAL_FORM package: 8.3.4. The GENERAL_FORM Package, Oracle Web Applications
print_invoice function, XML_INVOICE_PKG: 9.5.2. Body, Oracle Web Applications
print_items function, XML_INVOICE_PKG: 9.5.2. Body, Oracle Web Applications
print_textarea_row procedure, GENERAL_FORM package: 8.3.4. The GENERAL_FORM Package, Oracle Web Applications
print_thread_links procedure, FORUM package
8.3.6. The FORUM Package, Oracle Web Applications
8.3.6.2. Body, Oracle Web Applications
print_xml_tag function, XML_INVOICE_PKG: 9.5.2. Body, Oracle Web Applications
priority groups
(see also site priority groups)
16.3. Priority Groups with DBMS_REPCAT, Oracle Built-in Packages
16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure, Oracle Built-in Packages
adding priority levels: 16.3.3.1. The DBMS_REPCAT.ADD_PRIORITY_<datatype> procedure, Oracle Built-in Packages
altering data values: 16.3.3.3. The DBMS_REPCAT.ALTER_PRIORITY_<datatype> procedure, Oracle Built-in Packages
altering priority levels: 16.3.3.2. The DBMS_REPCAT.ALTER_PRIORITY procedure, Oracle Built-in Packages
comments, creating or changing: 16.3.2.3. The DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP procedure, Oracle Built-in Packages
concepts
16.3.1. About Priority Groups, Oracle Built-in Packages
16.3.3. Creating and Maintaining Priorities Within a Priority Group, Oracle Built-in Packages
creating: 16.3.2.1. The DBMS_REPCAT.DEFINE_PRIORITY_GROUP procedure, Oracle Built-in Packages
dropping priority groups: 16.3.2.2. The DBMS_REPCAT.DROP_PRIORITY_GROUP procedure, Oracle Built-in Packages
dropping priority levels by data value: 16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure, Oracle Built-in Packages
dropping priority levels by priority level number: 16.3.4.1. The DBMS_REPCAT.DROP_PRIORITY procedure, Oracle Built-in Packages
priority levels
adding: 16.3.3.1. The DBMS_REPCAT.ADD_PRIORITY_<datatype> procedure, Oracle Built-in Packages
altering: 16.3.3.2. The DBMS_REPCAT.ALTER_PRIORITY procedure, Oracle Built-in Packages
dropping by data value: 16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure, Oracle Built-in Packages
dropping by level number: 16.3.4.1. The DBMS_REPCAT.DROP_PRIORITY procedure, Oracle Built-in Packages
dropping site priorities via: 16.4.3.2. The DBMS_REPCAT.DROP_SITE_PRIORITY_SITE procedure, Oracle Built-in Packages
priority package
(see also specific program names)
5.7.2. Working with Prioritized Queues, Oracle Built-in Packages
priority.spp : 5.7.2. Working with Prioritized Queues, Oracle Built-in Packages
priority.tst : 5.7.2. Working with Prioritized Queues, Oracle Built-in Packages
priority_name function: 5.7.2. Working with Prioritized Queues, Oracle Built-in Packages
private
PL/Vision package synonyms: 4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
elements
16.2.2. The Body, Oracle PL/SQL Programming
16.2.4. Public and Private Package Elements, Oracle PL/SQL Programming
1.4.4.1. Public and private data, Advanced Oracle PL/SQL Programming with Packages
2.7. Building Windows Into Your Packages, Advanced Oracle PL/SQL Programming with Packages
2.10. Hiding Package Data, Advanced Oracle PL/SQL Programming with Packages
declaring before public: 2.2.1. Choosing the Order of Elements, Advanced Oracle PL/SQL Programming with Packages
global data: 16.5.4. Global Private Data, Oracle PL/SQL Programming
package elements
1.3.1. Enforced Information Hiding, Advanced Oracle PL/SQL Programming with Packages
1.4.4. Access to Package Elements, Advanced Oracle PL/SQL Programming with Packages
pipes
3.1. DBMS_PIPE: Communicating Between Sessions , Oracle Built-in Packages
3.1.3.1. The DBMS_PIPE.CREATE_PIPE function, Oracle Built-in Packages
privilege parameter: 7.6.2.1. GRANT_SYSTEM_PRIVILEGE: Granting system-level privileges, Guide to Oracle8i Features
privileges
(see also roles)
2.2.1. Creating the DBMS_SQL Package, Oracle Built-in Packages
2.5.3. Privileges, Oracle Web Applications
3.1.3.3. Controlling access to content, Oracle Web Applications
DDL statement execution and
2.4.7. Executing DDL in PL/SQL, Oracle Built-in Packages
19.4.1. DDL Operations , Advanced Oracle PL/SQL Programming with Packages
collections: 19.8.1. Privileges, Oracle PL/SQL Programming
object: 2.5.3.2. Object privileges, Oracle Web Applications
of objects: 18.3.7. Privileges, Oracle PL/SQL Programming
system
2.5.3.1. System privileges, Oracle Web Applications
7.6.2. System-Level Access Control, Guide to Oracle8i Features
proc procedure
5.13.7. Generating a procedure, Advanced Oracle PL/SQL Programming with Packages
16.2.2. Generating a Procedure, Advanced Oracle PL/SQL Programming with Packages
16.4.2. Implementing the Procedure Generator, Advanced Oracle PL/SQL Programming with Packages
procedural code, avoiding: 25.3.5. Avoid Procedural Code When Possible , Oracle PL/SQL Programming
procedure wizard, WebDB: 3.1.2.1. Building database objects, Oracle Web Applications
procedures
(see also functions; modules)
1.4.3.10. Modular construction, Oracle PL/SQL Programming
15. Procedures and Functions, Oracle PL/SQL Programming
15.4. Procedures, Oracle PL/SQL Programming
22.1.1. Make Sure the Module Name Explains the Module, Oracle PL/SQL Programming
IN OUT parameters in: 22.2.1.2. Switch to a procedure with IN OUT parameters, Oracle PL/SQL Programming
RETURN statements in: 15.5.8.5. RETURN statement in a procedure, Oracle PL/SQL Programming
changing trigger code to: 25.3.7. Keep Database Triggers Small, Oracle PL/SQL Programming
describing: 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure, Oracle Built-in Packages
execute authority: 1.3.5. Guaranteeing Transaction Integrity, Advanced Oracle PL/SQL Programming with Packages
external (see external procedures)
1.4.7.5. External procedures
for collections: 19.6. Collection Built-Ins, Oracle PL/SQL Programming
generating
16.2.2. Generating a Procedure, Advanced Oracle PL/SQL Programming with Packages
16.4.2. Implementing the Procedure Generator, Advanced Oracle PL/SQL Programming with Packages
headers of: 15.4.2. Procedure Header, Oracle PL/SQL Programming
help: 16.2.5.2. Generating a help procedure, Advanced Oracle PL/SQL Programming with Packages
local: 15.7. Local Modules, Oracle PL/SQL Programming
parameters of: 15.6. Parameters, Oracle PL/SQL Programming
recompiling: 10.3.2. Compiling PL/SQL Objects, Oracle Built-in Packages
records as parameters: 9.1.4. Guidelines for Using Records, Oracle PL/SQL Programming
referencing in packages: 1.3.3. Referencing Built-in Package Elements, Oracle Built-in Packages
remote
22.7.5. Default Values and Remote Procedure Calls, Oracle PL/SQL Programming
23.4. Remote Procedure Calls, Oracle PL/SQL Programming
replicated procedures: 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages
shared: 23.1.1. Executing Procedures, Oracle PL/SQL Programming
stored, from PL/SQL Version 1.1: B. Calling Stored Procedures from PL/SQL Version 1.1, Oracle PL/SQL Programming
synonyms for: 23.2.2. Creating Synonyms for Stored Objects, Oracle PL/SQL Programming
tables as parameters for: 10.5.4. Passing PL/SQL Tables as Parameters, Oracle PL/SQL Programming
process_halted exception
5.10.2. Package-based exceptions, Advanced Oracle PL/SQL Programming with Packages
22.1.10. Bailing Out with PLVexc, Advanced Oracle PL/SQL Programming with Packages
22.1.2. Package-Based Exceptions, Advanced Oracle PL/SQL Programming with Packages
process_request procedure: 3.1.7.5. The pipesvr package, Oracle Built-in Packages
process_survey procedure, EMP_SURVEY package
8.2.4. The EMP_SURVEY Package, Oracle Web Applications
8.2.4.2. Body, Oracle Web Applications
producers
(see also consumers)
5.1.5. A Glossary of Terms, Oracle Built-in Packages
delaying dequeuing: 5.3.6. Message Properties Record Type, Oracle Built-in Packages
production support: 26.2. Tracing for Production Support, Oracle PL/SQL Programming
productivity: 4.1.1. The Benefits of PL/Vision, Advanced Oracle PL/SQL Programming with Packages
profdel.sql file: 7.1.4. Profiler Return Codes, Guide to Oracle8i Features
profiler return codes: 7.1.4. Profiler Return Codes, Guide to Oracle8i Features
profilers: 7.1. DBMS_PROFILER: Providing Code Profiling , Guide to Oracle8i Features
profload.sql file: 7.1.2. Installing DBMS_PROFILER, Guide to Oracle8i Features
profrep.sql file: 7.1.2. Installing DBMS_PROFILER, Guide to Oracle8i Features
profsum.sql file: 7.1.2. Installing DBMS_PROFILER, Guide to Oracle8i Features
proftab.sql file: 7.1.2. Installing DBMS_PROFILER, Guide to Oracle8i Features
proftrunc.sql file: 7.1.4. Profiler Return Codes, Guide to Oracle8i Features
program names
finding within packages and DBMS_DESCRIBE: 10.2.3.2. Using psdesc.args as a quality assurance tool, Oracle Built-in Packages
registering: 7.2.5. The DBMS_APPLICATION_INFO.SET_MODULE procedure, Oracle Built-in Packages
returning
7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure, Oracle Built-in Packages
10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages
syntax for: 10.2.2.1. Specifying a program name, Oracle Built-in Packages
programmer-defined
datatypes: (see subtypes)
exceptions
8.3.2. Named Programmer-Defined Exceptions, Oracle PL/SQL Programming
8.3.4. Unnamed Programmer-Defined Exceptions , Oracle PL/SQL Programming
scope of: 8.4.1.1. Scope of programmer-defined exception, Oracle PL/SQL Programming
PL/SQL functions: (see stored functions, PL/SQL)
records
1.4.3.3. Programmer-defined records, Oracle PL/SQL Programming
9.4. Programmer-Defined Records, Oracle PL/SQL Programming
subtypes: 1.4.4.4. Programmer-defined subtypes, Oracle PL/SQL Programming
programming: (see coding)
programming technique
A. Appendix: PL/SQL Exercises, Advanced Oracle PL/SQL Programming with Packages
1.2.1. The Iceberg Approach to Coding, Advanced Oracle PL/SQL Programming with Packages
10.1.3.6. numinstr function, Advanced Oracle PL/SQL Programming with Packages
analyzing performance: (see performance)
avoiding hard-coded literals: 3.12. Obliterating the Literals, Advanced Oracle PL/SQL Programming with Packages
avoiding redundancy: (see redundancy)
backward compatibility
3.3. Supplying Backward Compatibility, Advanced Oracle PL/SQL Programming with Packages
3.11. Don't Forget Backward Compatibility, Advanced Oracle PL/SQL Programming with Packages
coding packages: 2. Best Practices for Packages, Advanced Oracle PL/SQL Programming with Packages
consistent error data: 22.2.1.1. Recording consistent error data, Advanced Oracle PL/SQL Programming with Packages
cover package: 1.6.4. Working with Large Packages, Advanced Oracle PL/SQL Programming with Packages
declarative programming: 19.2. Declarative Programming in PL/SQL, Advanced Oracle PL/SQL Programming with Packages
handling exceptions: 22.3.1. Analyzing the Need, Advanced Oracle PL/SQL Programming with Packages
handling fatal errors: 22.1.10. Bailing Out with PLVexc, Advanced Oracle PL/SQL Programming with Packages
hard-coded transaction processing: 20.1.1. Who Needs PLVcmt?, Advanced Oracle PL/SQL Programming with Packages
logging: (see logging)
modularizing: 2.9. Modularizing for Maintainable Packages, Advanced Oracle PL/SQL Programming with Packages
object-oriented design: 1.3.2. Object-Oriented Design, Advanced Oracle PL/SQL Programming with Packages
overloading: 2.8.1. When to Overload, Advanced Oracle PL/SQL Programming with Packages
simultaneous package construction: 2.11. Simultaneous Construction of Multiple Packages, Advanced Oracle PL/SQL Programming with Packages
testing/debugging: 2.6.3.1. The test/debug cycle in PL/SQL, Advanced Oracle PL/SQL Programming with Packages
toggles: 2.6.1. Toggling Package Behavior, Advanced Oracle PL/SQL Programming with Packages
top-down design: 1.3.3. Top-Down Design, Advanced Oracle PL/SQL Programming with Packages
user interface: 3.4. Improving the User Interface, Advanced Oracle PL/SQL Programming with Packages
using package initialization section: 1.6.3.1. When to use the initialization section, Advanced Oracle PL/SQL Programming with Packages
using packages: 1.6.1. When Should You Build a Package?, Advanced Oracle PL/SQL Programming with Packages
windows: 2.7. Building Windows Into Your Packages, Advanced Oracle PL/SQL Programming with Packages
programs
(see also functions; procedures; code)
1.3.3. Referencing Built-in Package Elements, Oracle Built-in Packages
analyzing performance of: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming
describing: 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure, Oracle Built-in Packages
enabling tracing of: 26.1.1. Enabling Program Units for Tracing, Oracle PL/SQL Programming
pinning into SGA shared pool: 25.2.2. Pin Critical Code into the SGA, Oracle PL/SQL Programming
recompiling: 10.3.2. Compiling PL/SQL Objects, Oracle Built-in Packages
referencing in packages: 1.3.3. Referencing Built-in Package Elements, Oracle Built-in Packages
shared, executing: 23.1. Executing Stored Code, Oracle PL/SQL Programming
testing: 24.2.5. Change and Test One Area of Code at a Time, Oracle PL/SQL Programming
progress boxes: 22.6.3. Progress Box as ADT, Oracle PL/SQL Programming
progress package: 22.6.4.1. The progress package specification, Oracle PL/SQL Programming
propagating messages
AQ features for: 5.1.4. Propagation Features, Oracle Built-in Packages
Oracle8 versions and: 5.2.2.3. Setting Oracle AQ compatibility, Oracle Built-in Packages
scheduling: 5.5.5.1. The DBMS_AQADM.SCHEDULE_PROPAGATION procedure, Oracle Built-in Packages
starting: 5.2.2.2. Starting propagation processes, Oracle Built-in Packages
unscheduling: 5.5.5.2. The DBMS_AQADM.UNSCHEDULE_PROPAGATION procedure , Oracle Built-in Packages
viewing schedules: 5.6.2.3. The DBA_JOBS view, Oracle Built-in Packages
propagating transactions
(see also deferred transactions)
17.2.5. Propagating Deferred RPCs, Oracle Built-in Packages
Oracle8 scheduling: 17.2.6. Scheduling Propagation (Oracle8 only), Oracle Built-in Packages
disabling: 17.2.6.1. The DBMS_DEFER_SYS.EXCLUDE_PUSH function (Oracle8 only), Oracle Built-in Packages
enabling and disabling: 17.2.4.5. The DBMS_DEFER_SYS.SET_DISABLED procedure, Oracle Built-in Packages
new destinations: 17.2.3. Copying Deferred Transactions to New Destinations, Oracle Built-in Packages
purging: 17.2.6.2. The DBMS_DEFER_SYS.PURGE function (Oracle8 only), Oracle Built-in Packages
pushing queued transactions
17.2.5. Propagating Deferred RPCs, Oracle Built-in Packages
17.2.6.3. The DBMS_DEFER_SYS.PUSH function, Oracle Built-in Packages
registering propagators: 17.2.6.8. The DBMS_DEFER_SYS.REGISTER_PROPAGATOR procedure (Oracle8 only), Oracle Built-in Packages
scheduling purge: 17.2.6.4. The DBMS_DEFER_SYS.SCHEDULE_PURGE procedure (Oracle8 only), Oracle Built-in Packages
scheduling push: 17.2.6.5. The DBMS_DEFER_SYS.SCHEDULE_PUSH procedure (Oracle8 only), Oracle Built-in Packages
scheduling, strategies for: 17.2.5.1. Scheduling strategies, Oracle Built-in Packages
unregistrating propagators: 17.2.6.9. The DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR procedure (Oracle8 only), Oracle Built-in Packages
unscheduling purge: 17.2.6.6. The DBMS_DEFER_SYS.UNSCHEDULE_PURGE procedure (Oracle8 only), Oracle Built-in Packages
unscheduling push: 17.2.6.7. The DBMS_DEFER_SYS.UNSCHEDULE_PUSH procedure (Oracle8 only), Oracle Built-in Packages
propagation of exceptions: 8.4.2. Propagation of an Exception , Oracle PL/SQL Programming
propagator accounts: 15.1.3. Granting and Revoking Propagator Accounts (Oracle8), Oracle Built-in Packages
properties, object: (see attributes, object)
protocol, network: 2.2.5. The Uniform Resource Locator, Oracle Web Applications
protocols (for messages)
5.1.5. A Glossary of Terms, Oracle Built-in Packages
5.3.4. Agents Object Type, Oracle Built-in Packages
tips about: 3.1.6.3. Establishing messaging protocols, Oracle Built-in Packages
protocols, communications: 1.1. The Internet Grows Up, Oracle Web Applications
prt package: 6.1.6.2. Package specification for a DBMS_OUTPUT encapsulator, Oracle Built-in Packages
prt.spp : 6.1.6.2. Package specification for a DBMS_OUTPUT encapsulator, Oracle Built-in Packages
prvtjob.plb script: 13.3.3. DBMS_IJOB: Managing Other Users' Jobs , Oracle Built-in Packages
prvtoctk.plb script: 10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages
prvtofln.plb script
14.3.1. Getting Started with DBMS_OFFLINE_SNAPSHOT, Oracle Built-in Packages
15.4.1. Getting Started with DBMS_OFFLINE_OG, Oracle Built-in Packages
prvtpbp.plb file: 7.1.2. Installing DBMS_PROFILER, Guide to Oracle8i Features
prvtpool.plb script: 12.2.1. Getting Started with DBMS_SHARED_POOL, Oracle Built-in Packages
prvtrctf.sql script
15.5.1. Getting Started with DBMS_RECTIFIER_DIFF, Oracle Built-in Packages
17.2.1. Getting Started with DBMS_DEFER_SYS, Oracle Built-in Packages
17.4.1. Getting Started with DBMS_DEFER_QUERY, Oracle Built-in Packages
prvtrepc.sql script
15.1.1. Getting Started with DBMS_REPCAT_AUTH, Oracle Built-in Packages
15.2.1. Getting Started with DBMS_REPCAT_ADMIN, Oracle Built-in Packages
prvtutil.plb script: 11.2.1. Getting Started with DBMS_SYSTEM , Oracle Built-in Packages
ps2db procedure
5.17.6. Managing the log , Advanced Oracle PL/SQL Programming with Packages
21.1.4.3. Transferring a PL/SQL table log to a database table, Advanced Oracle PL/SQL Programming with Packages
ps_callstack function
5.28.5. Accessing the PL/SQL call stack, Advanced Oracle PL/SQL Programming with Packages
21.2.2. Accessing the PL/SQL Call Stack, Advanced Oracle PL/SQL Programming with Packages
ps_module function
5.28.5. Accessing the PL/SQL call stack, Advanced Oracle PL/SQL Programming with Packages
21.2.2. Accessing the PL/SQL Call Stack, Advanced Oracle PL/SQL Programming with Packages
psdesc package
(see also specific program names)
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
10.2.3.1. Features of the psdesc package, Oracle Built-in Packages
psdesc.spp : 10.2.3.1. Features of the psdesc package, Oracle Built-in Packages
psdesc.tst
10.2.2.2. The DESCRIBE level, Oracle Built-in Packages
10.2.2. Explaining DBMS_DESCRIBE Results, Oracle Built-in Packages
pseudocolumns: 9.1.2. ROWID Concepts, Oracle Built-in Packages
pseudoinstructions: 2.6. The PRAGMA Keyword, Oracle PL/SQL Programming
psformat procedure: 4.1.2. The Origins of PL/Vision, Advanced Oracle PL/SQL Programming with Packages
pstab constant: 5.3.1. PL/Vision constants, Advanced Oracle PL/SQL Programming with Packages
pstab2file procedure
5.11.11. Copying a file, Advanced Oracle PL/SQL Programming with Packages
13.7.4. Copying PL/SQL Table to File, Advanced Oracle PL/SQL Programming with Packages
pstab_count function
5.17.6. Managing the log , Advanced Oracle PL/SQL Programming with Packages
21.1.4.1. Counting and clearing the PL/SQL table, Advanced Oracle PL/SQL Programming with Packages
public
PL/Vision package synonyms: 4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
elements
16.2.1. The Specification, Oracle PL/SQL Programming
16.2.4. Public and Private Package Elements, Oracle PL/SQL Programming
data
16.5.3. Global Public Data, Oracle PL/SQL Programming
1.4.4.1. Public and private data, Advanced Oracle PL/SQL Programming with Packages
2.7. Building Windows Into Your Packages, Advanced Oracle PL/SQL Programming with Packages
2.10. Hiding Package Data, Advanced Oracle PL/SQL Programming with Packages
2.10.4. When to Make Data Public, Advanced Oracle PL/SQL Programming with Packages
anchored declarations: 2.10.5. Anchoring to Public Variables, Advanced Oracle PL/SQL Programming with Packages
declaring before private: 2.2.1. Choosing the Order of Elements, Advanced Oracle PL/SQL Programming with Packages
package elements
1.3.1. Enforced Information Hiding, Advanced Oracle PL/SQL Programming with Packages
1.4.1. The Package Specification, Advanced Oracle PL/SQL Programming with Packages
package elements: 1.4.4. Access to Package Elements, Advanced Oracle PL/SQL Programming with Packages
pipes
3.1. DBMS_PIPE: Communicating Between Sessions , Oracle Built-in Packages
3.1.3.1. The DBMS_PIPE.CREATE_PIPE function, Oracle Built-in Packages
synonyms: 7.1.2. Installing DBMS_PROFILER, Guide to Oracle8i Features
purge_all_pipes procedure: 3.1.3.4. The DBMS_PIPE.PURGE procedure, Oracle Built-in Packages
purity levels
1.6.5.1. RESTRICT_REFERENCES pragma, Advanced Oracle PL/SQL Programming with Packages
1.3.7.1. Calling a packaged function in SQL, Oracle Built-in Packages
packages: 17.5.1. The RESTRICT_REFERENCES Pragma, Oracle PL/SQL Programming
push procedure
5.24.3. Modifying stack contents, Advanced Oracle PL/SQL Programming with Packages
5.7.3. Building a Stack with AQ Using Sequence Deviation, Oracle Built-in Packages
put_line procedure
5.11.10. Writing to a file, Advanced Oracle PL/SQL Programming with Packages
5.15.7. Reading and writing lines, Advanced Oracle PL/SQL Programming with Packages
5.17.4. Writing to the log , Advanced Oracle PL/SQL Programming with Packages
12.7. Writing to the Target, Advanced Oracle PL/SQL Programming with Packages
13.6. Writing to a File, Advanced Oracle PL/SQL Programming with Packages
16.4.3. put_line Procedure, Advanced Oracle PL/SQL Programming with Packages
21.1.2. Writing to the Log, Advanced Oracle PL/SQL Programming with Packages
specifying rollbacks: 21.1.5.5. Specifying rollbacks when calling put_line, Advanced Oracle PL/SQL Programming with Packages
put_line repository: 12.7.3. Displaying the Target Repository, Advanced Oracle PL/SQL Programming with Packages


Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Copyright © 2000 O'Reilly & Associates, Inc. All rights reserved.