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)
  6.1.6.1. Encapsulating DBMS_OUTPUT
  About 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
PACK_MESSAGE_RAW procedure
  3.1.1.1. DBMS_PIPE programs
  3.1.4.2. The DBMS_PIPE.PACK_MESSAGE_RAW procedure
PACK_MESSAGE_ROWID procedure
  3.1.1.1. DBMS_PIPE programs
  3.1.4.3. The DBMS_PIPE.PACK_MESSAGE_ROWID procedure
pack_send_friend procedure
  3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure
  3.1.6.1. Defining message types and encapsulating communications logic
pack_send_request procedure
  3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure
  3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function
  3.1.7.5. The pipesvr package
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
  1.3.4. Exception Handling and Built-in Packages
  1.3.4.2. Package-defined exception
package-named system exceptions
  1.3.4. Exception Handling and Built-in Packages
  1.3.4.1. Package-named system exception
package-specific exceptions
  1.3.4. Exception Handling and Built-in Packages
  1.3.4.4. Package-specific exception
  Oracle Developer/2000 and : 1.3.6.2. Handling exceptions in Oracle Developer/2000 Release 1
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
parallel server mode, testing for : 10.1.2.15. The DBMS_UTILITY.IS_PARALLEL_SERVER function
parameters
  (see also initialization parameters)
  10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function
  ANY parameters : 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4)
  describing : 10.2. DBMS_DESCRIBE: Describing PL/SQL Program Headers
  optional : 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure
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
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
  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
performance analysis
  (see also statistics)
  7. Defining an Application Profile
  DBMS_APPLICATION_INFO used for
    7. Defining an Application Profile
    7.3. DBMS_APPLICATION_INFO Examples
    7.3.7. Monitoring Application SQL Resource Consumption
    7.3.8. Session Monitoring and Three-Tier Architectures
  hashing (example) : 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function
  storing information for (example) : 7.3.3. The set_stats Procedure
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
  (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.3.1. The DBMS_PIPE.CREATE_PIPE function
    3.1.3.4. The DBMS_PIPE.PURGE procedure
    3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function
    RECEIVE_MESSAGE and : 3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function
    SEND_MESSAGE and : 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function
  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
    allocating : 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function
    freeing
      3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function
      3.1.3.4. The DBMS_PIPE.PURGE procedure
    tips about : 3.1.6.6. Sizing and removing pipes for good memory management
  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
    3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function
    3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function
    3.1.6.4. Paying attention to timeouts
  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
pipesvr package
  (see also specific program names)
  3.1.7.5. The pipesvr package
pipesvr.sql
  3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure
  3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function
  3.1.7.5. The pipesvr package
pipex1.sql
  3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure
  3.1.6.1. Defining message types and encapsulating communications logic
pipex2.sql : 3.1.4.7. The DBMS_PIPE.NEXT_ITEM_TYPE function
pl procedure : 6.1.6.1. Encapsulating DBMS_OUTPUT
PL/SQL
  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)
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
  10.1.1. Getting Started with DBMS_UTILITY
  10.1.2.19. The DBMS_UTILITY.PORT_STRING function
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.1. About Priority Groups
    16.3.3. Creating and Maintaining Priorities Within a Priority Group
  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
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
priority package
  (see also specific program names)
  5.7.2. Working with Prioritized Queues
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
  3.1. DBMS_PIPE: Communicating Between Sessions
  3.1.3.1. The DBMS_PIPE.CREATE_PIPE function
privileges
  (see also roles)
  2.2.1. Creating the DBMS_SQL Package
  DDL statement execution and : 2.4.7. Executing DDL in PL/SQL
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
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
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
    7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure
    10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure
  syntax for : 10.2.2.1. Specifying a program name
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
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
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
    17.2.6.3. The DBMS_DEFER_SYS.PUSH function
  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)
propagator accounts : 15.1.3. Granting and Revoking Propagator Accounts (Oracle8)
protocols (for messages)
  5.1.5. A Glossary of Terms
  5.3.4. Agents Object Type
  tips about : 3.1.6.3. Establishing messaging protocols
prt package
  (see also specific program names)
  6.1.6.2. Package specification for a DBMS_OUTPUT encapsulator
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
  14.3.1. Getting Started with DBMS_OFFLINE_SNAPSHOT
  15.4.1. Getting Started with DBMS_OFFLINE_OG
prvtpool.plb script : 12.2.1. Getting Started with DBMS_SHARED_POOL
prvtrctf.sql script
  15.5.1. Getting Started with DBMS_RECTIFIER_DIFF
  17.2.1. Getting Started with DBMS_DEFER_SYS
  17.4.1. Getting Started with DBMS_DEFER_QUERY
prvtrepc.sql script
  15.1.1. Getting Started with DBMS_REPCAT_AUTH
  15.2.1. Getting Started with DBMS_REPCAT_ADMIN
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
psdesc.spp : 10.2.3.1. Features of the psdesc package
psdesc.tst
  10.2.2.2. The DESCRIBE level
  10.2.2. Explaining DBMS_DESCRIBE Results
pseudocolumns : 9.1.2. ROWID Concepts
public pipes
  3.1. DBMS_PIPE: Communicating Between Sessions
  3.1.3.1. The DBMS_PIPE.CREATE_PIPE function
PURGE procedure (DBMS_DEFER_SYS)
  17.2.1.1. DBMS_DEFER_SYS programs
  17.2.6.2. The DBMS_DEFER_SYS.PURGE function (Oracle8 only)
PURGE procedure (DBMS_PIPE)
  3.1.1.1. DBMS_PIPE programs
  3.1.3.4. The DBMS_PIPE.PURGE procedure
purge_all_pipes procedure : 3.1.3.4. The DBMS_PIPE.PURGE procedure
PURGE_LOG procedure
  14.1.1. Getting Started with DBMS_SNAPSHOT
  14.1.4. Purging the Snapshot Log
PURGE_LOST_DB_ENTRY procedure
  4.2.1.1. DBMS_TRANSACTION programs
  4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure
PURGE_MASTER_LOG procedure
  15.3.1.1. DBMS_REPCAT programs
  15.3.6.3. The DBMS_REPCAT.PURGE_MASTER_LOG procedure
PURGE_MIXED procedure
  4.2.1.1. DBMS_TRANSACTION programs
  4.2.6.1. The DBMS_TRANSACTION.PURGE_MIXED procedure
PURGE_STATISTICS procedure
  16.1.1. DBMS_REPCAT Programs
  16.6.1.3. The DBMS_REPCAT.PURGE_STATISTICS procedure
purity levels : 1.3.7.1. Calling a packaged function in SQL
PUSH function
  17.2.1.1. DBMS_DEFER_SYS programs
  17.2.6.3. The DBMS_DEFER_SYS.PUSH function
push procedure : 5.7.3. Building a Stack with AQ Using Sequence Deviation
PUT procedure (DBMS_OUTPUT)
  6.1.1.1. DBMS_OUTPUT programs
  6.1.3.1. The DBMS_OUTPUT.PUT procedure
PUT procedure (UTL_FILE)
  6.2.1.1. UTL_FILE programs
  6.2.4.1. The UTL_FILE.PUT procedure
PUT_LINE procedure (DBMS_OUTPUT)
  6.1.1.1. DBMS_OUTPUT programs
  6.1.3.2. The DBMS_OUTPUT.PUT_LINE procedure
PUT_LINE procedure (UTL_FILE)
  6.2.1.1. UTL_FILE programs
  6.2.4.3. The UTL_FILE.PUT_LINE procedure
PUTF procedure (UTL_FILE)
  6.2.1.1. UTL_FILE programs
  6.2.4.4. The UTL_FILE.PUTF procedure

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

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