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
Index: P
- p package (PL/Vision)
- pack_from_tbl procedure
: 3.1.7.3. The dbpipe utility package
- PACK_MESSAGE procedure
- 3.1.1.1. DBMS_PIPE programs
- 3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure
- sending/receiving relationship and : 3.1.7.3. The dbpipe utility package
- 3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure
- 3.1.1.1. DBMS_PIPE programs
- PACK_MESSAGE_RAW procedure
- PACK_MESSAGE_ROWID procedure
- pack_send_friend procedure
- pack_send_request procedure
- pack_send_status procedure
: 3.1.7.5. The pipesvr package
- package body, definition : 1.3.1. What Is a Package?
- package names, returning : 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure
- package specification, definition : 1.3.1. What Is a Package?
- package-defined exceptions
- package body, definition : 1.3.1. What Is a Package?
- package-named system exceptions
- package-specific exceptions
- packages
- (see also built-in packages)
- 1.3.1. What Is a Package?
- controlling use of elements : 1.3.2. Controlling Access with Packages
- description : 1.3.1. What Is a Package?
- dot notation for referencing elements : 1.3.3. Referencing Built-in Package Elements
- exception handling, identifying cause of : 1.3.4.5. Same exception, different causes
- pinning : (see shared pool)
- recompiling : 10.3.2. Compiling PL/SQL Objects
- referencing elements of : 1.3.3. Referencing Built-in Package Elements
- refresh state : 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function
- replicated packages : 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure
- resetting state : 11.1.4.3. The DBMS_SESSION.RESET_PACKAGE procedure
- 1.3.1. What Is a Package?
- (see also built-in packages)
- parallel server mode, testing for
: 10.1.2.15. The DBMS_UTILITY.IS_PARALLEL_SERVER function
- parameters
- parse procedure
: 2.4.6. Problem-Solving Dynamic SQL Errors
- PARSE procedure
- 2.2.3. DBMS_SQL Programs
- 2.3.3.1. The DBMS_SQL.PARSE procedure
- encapsulating for error handling : 2.4.6. Problem-Solving Dynamic SQL Errors
- SQL language version : 2.2.6. DBMS_SQL Nonprogram Elements
- 2.3.3.1. The DBMS_SQL.PARSE procedure
- 2.2.3. DBMS_SQL Programs
- parse_long_one procedure
: 2.3.3.2. Parsing very long SQL statements
- parsing SQL statements : (see deferred parsing; SQL statements, parsing)
- parslong.sp : 2.3.3.2. Parsing very long SQL statements
- partitioned objects, analyzing : 10.1.2.3. The DBMS_UTILITY.ANALYZE_PART_OBJECT procedure (Oracle8 Only)
- path function : 6.2.6.4. Adding support for paths
- pathnames, UTL_FILE enhancement : 6.2.6.4. Adding support for paths
- payload : (see messages (AQ); queues)
- payload types : 5.3.3. Queue Type Names
- pcex1.sql : 12.1.2.1. The DBMS_SPACE.FREE_BLOCKS procedure
- peek procedure : 3.1.7.3. The dbpipe utility package
- peers : (see master sites)
- percent (multiple-character substitution) : 5.7.5.1. Wildcarded correlation identifiers
- performance
- parsing SQL statements : (see deferred parsing; SQL statements, parsing)
- array fetching and
: 2.5.6.4. Using array processing to fetch
- DBMS_SQL used for improving : 2.4.5. Improving the Performance of Dynamic SQL
- session identifiers and : 11.1.5.4. The sid function
- DBMS_SQL used for improving : 2.4.5. Improving the Performance of Dynamic SQL
- array fetching and
: 2.5.6.4. Using array processing to fetch
- performance analysis
- (see also statistics)
- 7. Defining an Application Profile
- DBMS_APPLICATION_INFO used for
- 7. Defining an Application Profile
- hashing (example)
: 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function
- storing information for (example) : 7.3.3. The set_stats Procedure
- (see also statistics)
- pinning
: (see shared pool)
- pipe1 procedure : 3.1.7.2. Exploring DBMS_PIPE
- pipe1.sql : 3.1.7.2. Exploring DBMS_PIPE
- pipe2.sql : 3.1.7.2. Exploring DBMS_PIPE
- pipenames : 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function
- pipes
- pipe1 procedure : 3.1.7.2. Exploring DBMS_PIPE
- (see also DBMS_PIPE package; message buffers; messages (pipes))
- 3.1. DBMS_PIPE: Communicating Between Sessions
- advanced queuing versus : 3.1.2.3. Pipe communications logic
- creating
- 3.1. DBMS_PIPE: Communicating Between Sessions
- encapsulating pack/send and receive/unpack
: 3.1.7.5. The pipesvr package
- implementation of : 3.1.2. How Database Pipes Work
- job queue and : 13. Job Scheduling in the Database
- memory for
- implementation of : 3.1.2. How Database Pipes Work
- names for
: 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function
- packing/unpacking relationship : 3.1.7.2. Exploring DBMS_PIPE
- purging : 3.1.3.4. The DBMS_PIPE.PURGE procedure
- removing : 3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function
- separating messages for specific recipients : 3.1.6.2. Separating messages
- timeouts
- packing/unpacking relationship : 3.1.7.2. Exploring DBMS_PIPE
- unique session names, returning
: 3.1.3.5. The DBMS_PIPE.UNIQUE_SESSION_NAME function
- utility package : 3.1.7.3. The dbpipe utility package
- (see also DBMS_PIPE package; message buffers; messages (pipes))
- pipesvr package
- (see also specific program names)
- 3.1.7.5. The pipesvr package
- (see also specific program names)
- pipesvr.sql
- pipex1.sql
- pipex2.sql
: 3.1.4.7. The DBMS_PIPE.NEXT_ITEM_TYPE function
- pl procedure : 6.1.6.1. Encapsulating DBMS_OUTPUT
- PL/SQL
- pl procedure : 6.1.6.1. Encapsulating DBMS_OUTPUT
- scope with dynamic SQL
: 2.4.8. Executing Dynamic PL/SQL
- blocks, syntax for : 2.4.8. Executing Dynamic PL/SQL
- connections and : 2.4.7. Executing DDL in PL/SQL
- debugging stored code : 6.1. DBMS_OUTPUT: Displaying Output
- dynamic execution of : 2. Executing Dynamic SQL and PL/SQL
- tables : (see index-by tables)
- blocks, syntax for : 2.4.8. Executing Dynamic PL/SQL
- scope with dynamic SQL
: 2.4.8. Executing Dynamic PL/SQL
- PL/SQL server, DBMS_PIPE implementation of
: 3.1.7.4. Implementing a server program
- PL/Vision (RevealNet product) : About PL/Vision
- PL/Vision Lite : 2.4.6. Problem-Solving Dynamic SQL Errors
- place_bid procedure : 3.2.3.5. The auction package
- placeholders : (see host variables)
- plsqlarray.sp : 2.5.6.5. Using array processing in dynamic PL/SQL
- PLVdyn : About PL/Vision
- PLVfile : About PL/Vision
- pop procedure : 5.7.3. Building a Stack with AQ Using Sequence Deviation
- PORT_STRING function
- PL/Vision (RevealNet product) : About PL/Vision
- pragmas, packaged programs and
: 1.3.7. Accessing Built-in Packaged Technology from Within SQL
- priority groups
- (see also site priority groups)
- 16.3. Priority Groups with DBMS_REPCAT
- 16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure
- adding priority levels : 16.3.3.1. The DBMS_REPCAT.ADD_PRIORITY_<datatype> procedure
- altering data values : 16.3.3.3. The DBMS_REPCAT.ALTER_PRIORITY_<datatype> procedure
- altering priority levels : 16.3.3.2. The DBMS_REPCAT.ALTER_PRIORITY procedure
- comments, creating or changing : 16.3.2.3. The DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP procedure
- concepts
- 16.3. Priority Groups with DBMS_REPCAT
- creating
: 16.3.2.1. The DBMS_REPCAT.DEFINE_PRIORITY_GROUP procedure
- dropping priority groups : 16.3.2.2. The DBMS_REPCAT.DROP_PRIORITY_GROUP procedure
- dropping priority levels by data value : 16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure
- dropping priority levels by priority level number : 16.3.4.1. The DBMS_REPCAT.DROP_PRIORITY procedure
- dropping priority groups : 16.3.2.2. The DBMS_REPCAT.DROP_PRIORITY_GROUP procedure
- (see also site priority groups)
- priority levels
- adding
: 16.3.3.1. The DBMS_REPCAT.ADD_PRIORITY_<datatype> procedure
- altering : 16.3.3.2. The DBMS_REPCAT.ALTER_PRIORITY procedure
- dropping by data value : 16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure
- dropping by level number : 16.3.4.1. The DBMS_REPCAT.DROP_PRIORITY procedure
- dropping site priorities via : 16.4.3.2. The DBMS_REPCAT.DROP_SITE_PRIORITY_SITE procedure
- altering : 16.3.3.2. The DBMS_REPCAT.ALTER_PRIORITY procedure
- adding
: 16.3.3.1. The DBMS_REPCAT.ADD_PRIORITY_<datatype> procedure
- priority package
- (see also specific program names)
- 5.7.2. Working with Prioritized Queues
- (see also specific program names)
- priority.spp
: 5.7.2. Working with Prioritized Queues
- priority.tst : 5.7.2. Working with Prioritized Queues
- priority_name function : 5.7.2. Working with Prioritized Queues
- private pipes
- priority.tst : 5.7.2. Working with Prioritized Queues
- privileges
- (see also roles)
- 2.2.1. Creating the DBMS_SQL Package
- DDL statement execution and : 2.4.7. Executing DDL in PL/SQL
- 2.2.1. Creating the DBMS_SQL Package
- (see also roles)
- procedures
- describing
: 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure
- recompiling : 10.3.2. Compiling PL/SQL Objects
- referencing in packages : 1.3.3. Referencing Built-in Package Elements
- replicated procedures : 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure
- recompiling : 10.3.2. Compiling PL/SQL Objects
- describing
: 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure
- process_request procedure
: 3.1.7.5. The pipesvr package
- producers
- (see also consumers)
- 5.1.5. A Glossary of Terms
- delaying dequeuing : 5.3.6. Message Properties Record Type
- 5.1.5. A Glossary of Terms
- (see also consumers)
- program names
- finding within packages and DBMS_DESCRIBE
: 10.2.3.2. Using psdesc.args as a quality assurance tool
- registering : 7.2.5. The DBMS_APPLICATION_INFO.SET_MODULE procedure
- returning
- registering : 7.2.5. The DBMS_APPLICATION_INFO.SET_MODULE procedure
- syntax for : 10.2.2.1. Specifying a program name
- finding within packages and DBMS_DESCRIBE
: 10.2.3.2. Using psdesc.args as a quality assurance tool
- programs
- (see also functions; procedures)
- 1.3.3. Referencing Built-in Package Elements
- describing : 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure
- recompiling : 10.3.2. Compiling PL/SQL Objects
- referencing in packages : 1.3.3. Referencing Built-in Package Elements
- 1.3.3. Referencing Built-in Package Elements
- (see also functions; procedures)
- propagating messages
- AQ features for
: 5.1.4. Propagation Features
- Oracle8 versions and : 5.2.2.3. Setting Oracle AQ compatibility
- scheduling : 5.5.5.1. The DBMS_AQADM.SCHEDULE_PROPAGATION procedure
- starting : 5.2.2.2. Starting propagation processes
- unscheduling : 5.5.5.2. The DBMS_AQADM.UNSCHEDULE_PROPAGATION procedure
- viewing schedules : 5.6.2.3. The DBA_JOBS view
- Oracle8 versions and : 5.2.2.3. Setting Oracle AQ compatibility
- AQ features for
: 5.1.4. Propagation Features
- propagating transactions
- (see also deferred traansactions)
- 17.2.5. Propagating Deferred RPCs
- disabling : 17.2.6.1. The DBMS_DEFER_SYS.EXCLUDE_PUSH function (Oracle8 only)
- enabling and disabling : 17.2.4.5. The DBMS_DEFER_SYS.SET_DISABLED procedure
- new destinations : 17.2.3. Copying Deferred Transactions to New Destinations
- Oracle8 scheduling : 17.2.6. Scheduling Propagation (Oracle8 only)
- purging : 17.2.6.2. The DBMS_DEFER_SYS.PURGE function (Oracle8 only)
- pushing queued transactions
- 17.2.5. Propagating Deferred RPCs
- registering propagators
: 17.2.6.8. The DBMS_DEFER_SYS.REGISTER_PROPAGATOR procedure (Oracle8 only)
- scheduling purge : 17.2.6.4. The DBMS_DEFER_SYS.SCHEDULE_PURGE procedure (Oracle8 only)
- scheduling push : 17.2.6.5. The DBMS_DEFER_SYS.SCHEDULE_PUSH procedure (Oracle8 only)
- scheduling, strategies for : 17.2.5.1. Scheduling strategies
- unregistrating propagators : 17.2.6.9. The DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR procedure (Oracle8 only)
- unscheduling purge : 17.2.6.6. The DBMS_DEFER_SYS.UNSCHEDULE_PURGE procedure (Oracle8 only)
- unscheduling push : 17.2.6.7. The DBMS_DEFER_SYS.UNSCHEDULE_PUSH procedure (Oracle8 only)
- scheduling purge : 17.2.6.4. The DBMS_DEFER_SYS.SCHEDULE_PURGE procedure (Oracle8 only)
- (see also deferred traansactions)
- propagator accounts
: 15.1.3. Granting and Revoking Propagator Accounts (Oracle8)
- protocols (for messages)
- prt package
- (see also specific program names)
- 6.1.6.2. Package specification for a DBMS_OUTPUT encapsulator
- (see also specific program names)
- prt.spp
: 6.1.6.2. Package specification for a DBMS_OUTPUT encapsulator
- prvtjob.plb script : 13.3.3. DBMS_IJOB: Managing Other Users' Jobs
- prvtoctk.plb script : 10.4.1. Getting Started with DBMS_RANDOM
- prvtofln.plb script
- prvtjob.plb script : 13.3.3. DBMS_IJOB: Managing Other Users' Jobs
- prvtpool.plb script
: 12.2.1. Getting Started with DBMS_SHARED_POOL
- prvtrctf.sql script
- prvtrepc.sql script
- prvtutil.plb script
: 11.2.1. Getting Started with DBMS_SYSTEM
- psdesc package
- (see also specific program names)
- 1.3.5.1. Examples of encapsulation packages
- 10.2.3.1. Features of the psdesc package
- 1.3.5.1. Examples of encapsulation packages
- (see also specific program names)
- psdesc.spp
: 10.2.3.1. Features of the psdesc package
- psdesc.tst
- pseudocolumns
: 9.1.2. ROWID Concepts
- public pipes
- PURGE procedure (DBMS_DEFER_SYS)
- PURGE procedure (DBMS_PIPE)
- purge_all_pipes procedure
: 3.1.3.4. The DBMS_PIPE.PURGE procedure
- PURGE_LOG procedure
- PURGE_LOST_DB_ENTRY procedure
- PURGE_MASTER_LOG procedure
- PURGE_MIXED procedure
- PURGE_STATISTICS procedure
- purity levels
: 1.3.7.1. Calling a packaged function in SQL
- PUSH function
- push procedure
: 5.7.3. Building a Stack with AQ Using Sequence Deviation
- PUT procedure (DBMS_OUTPUT)
- PUT procedure (UTL_FILE)
- PUT_LINE procedure (DBMS_OUTPUT)
- PUT_LINE procedure (UTL_FILE)
- PUTF procedure (UTL_FILE)
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
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.