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.