SQL, PL/SQL, and SQL*Plus Syntax and Examples: P

P: Definition, Search for examples

PACK_MESSAGE Procedures: Definition, Search for examples

PACK_STGTAB_BASELINE Function: Definition, Search for examples

PACK_STGTAB_SQLPATCH Procedure: Definition, Search for examples

PACK_STGTAB_SQLPROF Procedure: Definition, Search for examples

PACK_STGTAB_SQLSET Procedure: Definition, Search for examples

PACKAGE: Definition, Search for examples

PACKAGE: Definition, Search for examples

PACKAGE_BODY: Definition, Search for examples

PACKAGE_SPEC: Definition, Search for examples

PAD_NONE: Definition, Search for examples

PAD_PKCS5: Definition, Search for examples

PAD_ZERO: Definition, Search for examples

PARA Function: Definition, Search for examples

PARA Procedure: Definition, Search for examples

PARAGRAPH Function: Definition, Search for examples

PARAGRAPH Procedure: Definition, Search for examples

PARALLEL_ENABLE Option: Definition, Search for examples

PARALLEL_ENABLE: Definition, Search for examples

PARAM Function: Definition, Search for examples

PARAM Procedure: Definition, Search for examples

PARAM_NAME: Definition, Search for examples

PARAM_UNIT: Definition, Search for examples

PARAM_VALUE: Definition, Search for examples

PARENT_ID: Definition, Search for examples

PARENT_ID_PLUS_EXP: Definition, Search for examples

PARSE Procedure: Definition, Search for examples

PARSE Procedures: Definition, Search for examples

PARSE: Definition, Search for examples

PARSE_FAILURES_SEC: Definition, Search for examples

PARSE_FAILURES_TXN: Definition, Search for examples

PARSEBUFFER: Definition, Search for examples

PARSECLOB: Definition, Search for examples

PARSEDTD: Definition, Search for examples

PARSEDTDBUFFER: Definition, Search for examples

PARSEDTDCLOB: Definition, Search for examples

PARTIAL: Definition, Search for examples

PARTIAL_MULTIBYTE_CHAR: Definition, Search for examples

PARTIAL_MULTIBYTE_EXCEPTION: Definition, Search for examples

PARTITION: Definition, Search for examples

PARTITION_BY_GUID: Definition, Search for examples

PARTITION_BY_ITEM: Definition, Search for examples

PARTITION_BY_PATH: Definition, Search for examples

PARTITION_NAME_TEMPLATE: Definition, Search for examples

PARTITION_OPTIONS: Definition, Search for examples

PARTITIONING_GOAL: Definition, Search for examples

PARTITIONING_TYPES: Definition, Search for examples

PARTITIONOPTION: Definition, Search for examples

PASSWORD: Definition, Search for examples

PASSWORD: Definition, Search for examples

PASSWORD_HISTORY: Definition, Search for examples

PASSWORD_VERIFY_FUNCTION: Definition, Search for examples

PATCHREPOSITORYRESCONFIGLIST Procedure: Definition, Search for examples

PATH: Definition, Search for examples

PATH_EXISTS: Definition, Search for examples

PATH_ID: Definition, Search for examples

PATH_ITEM_T Record Type: Definition, Search for examples

PATH_ITEMS_T Table Type: Definition, Search for examples

PATH_KEY: Definition, Search for examples

PATH_MAX: Definition, Search for examples

PATH_T: Definition, Search for examples

PATHIDTABLE Function: Definition, Search for examples

PAUSE: Definition, Search for examples

PAUSE: Definition, Search for examples

PAUSE_REPLAY Procedure: Definition, Search for examples

PCT_CORRECT: Definition, Search for examples

PCT_INCORRECT: Definition, Search for examples

PCT_TIED: Definition, Search for examples

PCTSPACE: Definition, Search for examples

PERFORMANCE: Definition, Search for examples

PERFORMANCE_CLASS: Definition, Search for examples

PERIODS: Definition, Search for examples

PERMANENT_ERROR: Definition, Search for examples

PERMIT_92_WRAP_FORMAT: Definition, Search for examples

PGA_CACHE_HIT: Definition, Search for examples

PHYS_DESGN_WAIT_SCT: Definition, Search for examples

PHYS_DESGN_WAIT_TIME: Definition, Search for examples

PHYSICAL_READS_DIR_SEC: Definition, Search for examples

PHYSICAL_READS_DIR_TXN: Definition, Search for examples

PHYSICAL_READS_LOB_SEC: Definition, Search for examples

PHYSICAL_READS_LOB_TXN: Definition, Search for examples

PHYSICAL_READS_SEC: Definition, Search for examples

PHYSICAL_READS_TXN: Definition, Search for examples

PHYSICAL_WRITES_DIR_SEC: Definition, Search for examples

PHYSICAL_WRITES_DIR_TXN: Definition, Search for examples

PHYSICAL_WRITES_LOB_SEC: Definition, Search for examples

PHYSICAL_WRITES_LOB_TXN: Definition, Search for examples

PHYSICAL_WRITES_SEC: Definition, Search for examples

PHYSICAL_WRITES_TXN: Definition, Search for examples

PIECEWISE Member Procedure: Definition, Search for examples

PIECEWISE Member Procedure: Definition, Search for examples

PING Procedure: Definition, Search for examples

PIPELINED Option: Definition, Search for examples

PIPELINED: Definition, Search for examples

PL/SQL Engine: Definition, Search for examples

PL/SQL Hierarchical Profiler: Definition, Search for examples

PLAINTEXT Function: Definition, Search for examples

PLAINTEXT Procedure: Definition, Search for examples

PLAN_PLUS_EXP: Definition, Search for examples

PLS_INTEGER: Definition, Search for examples

PLSCOPE_SETTINGS: Definition, Search for examples

PLSCOPE_SETTINGS: Definition, Search for examples

PLSQL: Definition, Search for examples

PLSQL_CCFLAGS: Definition, Search for examples

PLSQL_CCFLAGS: Definition, Search for examples

PLSQL_CODE_TYPE: Definition, Search for examples

PLSQL_CONN_MEM_LIMIT: Definition, Search for examples

PLSQL_MEMORY_ADDRESS: Definition, Search for examples

PLSQL_MEMORY_SIZE: Definition, Search for examples

PLSQL_OPTIMIZE_LEVEL: Definition, Search for examples

PLSQL_OPTIMIZE_LEVEL: Definition, Search for examples

PLSQL_TIMEOUT: Definition, Search for examples

PLSQL_TRACE_VERSION Procedure: Definition, Search for examples

PLSQL_WARNINGS: Definition, Search for examples

PMARKER Function: Definition, Search for examples

POISSON_DIST_FIT Procedure: Definition, Search for examples

POLICY_NAME: Definition, Search for examples

POPULATE_DIVERGENCE Procedure: Definition, Search for examples

POPULATELINEAGE: Definition, Search for examples

PORT_STRING Function: Definition, Search for examples

POSITION: Definition, Search for examples

POSITIVE: Definition, Search for examples

POSITIVEN: Definition, Search for examples

POST Procedure: Definition, Search for examples

POST_CHECKIN_EVENT: Definition, Search for examples

POST_CHECKOUT_EVENT: Definition, Search for examples

POST_CREATE_EVENT: Definition, Search for examples

POST_DELETE_EVENT: Definition, Search for examples

POST_INCONSISTENT_UPDATE_EVENT: Definition, Search for examples

POST_INSTANTIATION_SETUP Procedure: Definition, Search for examples

POST_LINKIN_EVENT: Definition, Search for examples

POST_LINKTO_EVENT: Definition, Search for examples

POST_LOCK_EVENT: Definition, Search for examples

POST_OPEN_EVENT: Definition, Search for examples

POST_UNCHECKOUT_EVENT: Definition, Search for examples

POST_UNLINKFROM_EVENT: Definition, Search for examples

POST_UNLINKIN_EVENT: Definition, Search for examples

POST_UNLOCK_EVENT: Definition, Search for examples

POST_UPDATE_EVENT: Definition, Search for examples

POST_VERSIONCONTROL_EVENT: Definition, Search for examples

PR: Definition, Search for examples

PRE_CHECKIN_EVENT: Definition, Search for examples

PRE_CHECKOUT_EVENT: Definition, Search for examples

PRE_CREATE_EVENT: Definition, Search for examples

PRE_DELETE_EVENT: Definition, Search for examples

PRE_INCONSISTENT_UPDATE_EVENT: Definition, Search for examples

PRE_INSTANTIATION_SETUP Procedure: Definition, Search for examples

PRE_LINKIN_EVENT: Definition, Search for examples

PRE_LINKTO_EVENT: Definition, Search for examples

PRE_LOCK_EVENT: Definition, Search for examples

PRE_OPEN_EVENT: Definition, Search for examples

PRE_UNCHECKOUT_EVENT: Definition, Search for examples

PRE_UNLINKFROM_EVENT: Definition, Search for examples

PRE_UNLINKIN_EVENT: Definition, Search for examples

PRE_UNLOCK_EVENT: Definition, Search for examples

PRE_UPDATE_EVENT: Definition, Search for examples

PRE_VERSIONCONTROL_EVENT: Definition, Search for examples

PRECLOSE Function: Definition, Search for examples

PRECLOSE Procedure: Definition, Search for examples

PRECOMPUTE: Definition, Search for examples

PREDICT Procedure: Definition, Search for examples

PREDICTED_TARGET_VALUE: Definition, Search for examples

PREDICTION: Definition, Search for examples

PREDICTION: Definition, Search for examples

PREOPEN Function: Definition, Search for examples

PREOPEN Procedure: Definition, Search for examples

PREP_AUTO_OFF: Definition, Search for examples

PREP_AUTO_ON: Definition, Search for examples

PREPARE_COLUMN_VALUES Procedures: Definition, Search for examples

PREPARE_COLUMN_VALUES_NVARCHAR2 Procedure: Definition, Search for examples

PREPARE_COLUMN_VALUES_ROWID Procedure: Definition, Search for examples

PREPARE_CONSOLIDATED_REPLAY Procedure: Definition, Search for examples

PREPARE_FOR_NEW_PRIMARY Procedure: Definition, Search for examples

PREPARE_GLOBAL_INSTANTIATION Procedure: Definition, Search for examples

PREPARE_REPLAY Procedure: Definition, Search for examples

PREPARE_SCHEMA_INSTANTIATION Procedure: Definition, Search for examples

PREPARE_SERVERS: Definition, Search for examples

PREPARE_SYNC_INSTANTIATION Function: Definition, Search for examples

PREPARE_TABLE_INSTANTIATION Procedure: Definition, Search for examples

PRESERVE_COMMIT_ORDER: Definition, Search for examples

PRINT Functions: Definition, Search for examples

PRINT Procedures: Definition, Search for examples

PRINT: Definition, Search for examples

PRINT: Definition, Search for examples

PRINT_BACKTRACE Procedure: Definition, Search for examples

PRINT_CGI_ENV Procedure: Definition, Search for examples

PRINT_INSTANTIATIONS Procedure: Definition, Search for examples

PRINT_MULTI Procedure: Definition, Search for examples

PRINT_POST_PROCESSED_SOURCE Procedures: Definition, Search for examples

PRINT_PRETTY_SQL: Definition, Search for examples

PRINT_ROW_LIST Procedure: Definition, Search for examples

PRINTS Procedure: Definition, Search for examples

PRIOR: Definition, Search for examples

PRIOR: Definition, Search for examples

PRIORITY_HIGH: Definition, Search for examples

PRIORITY_MEDIUM: Definition, Search for examples

PRIORITY_URGENT: Definition, Search for examples

PRN Functions: Definition, Search for examples

PRN Procedures: Definition, Search for examples

PROBABILITY: Definition, Search for examples

PROBABILITY: Definition, Search for examples

PROBE_VERSION Procedure: Definition, Search for examples

PROBLEM_TYPE_ALT_PLAN_GEN: Definition, Search for examples

PROBLEM_TYPE_COMPILATION_ERROR: Definition, Search for examples

PROBLEM_TYPE_EXECUTION_ERROR: Definition, Search for examples

PROBLEM_TYPE_PERFORMANCE: Definition, Search for examples

PROBLEM_TYPE_WRONG_RESULTS: Definition, Search for examples

PROCEDURE setXSLT: Definition, Search for examples

PROCEDURE: Definition, Search for examples

PROCESS_CAPTURE Procedure: Definition, Search for examples

PROCESS_LIMIT_PCT: Definition, Search for examples

PROCESS_RULES Procedure: Definition, Search for examples

PROCESSED: Definition, Search for examples

PROCESSED_WITH_ERROR: Definition, Search for examples

PROCESSING: Definition, Search for examples

PROCESSING_INSTRUCTION_NODE: Definition, Search for examples

PROCESSLINKS Procedure: Definition, Search for examples

PRODUCT: Definition, Search for examples

PRODUCT_USER_PROFILE Table: Definition, Search for examples

PROFILE Procedure: Definition, Search for examples

PROFILE: Definition, Search for examples

PROFILE: Definition, Search for examples

PROFILE_ID: Definition, Search for examples

PROGRAM_ERROR: Definition, Search for examples

PROGRAM_ERROR: Definition, Search for examples

PROGRAM_INFO Record Type: Definition, Search for examples

PROMPT: Definition, Search for examples

PROMPT: Definition, Search for examples

PROP_ALL: Definition, Search for examples

PROP_DATA: Definition, Search for examples

PROP_ITEM_T Record Type: Definition, Search for examples

PROP_ITEMS_T Table Type: Definition, Search for examples

PROP_NAME: Definition, Search for examples

PROP_NONE: Definition, Search for examples

PROP_OPT: Definition, Search for examples

PROP_SPC: Definition, Search for examples

PROP_STD: Definition, Search for examples

PROP_USR: Definition, Search for examples

PROP_VALUE: Definition, Search for examples

PROPAGATEORIGINALEXCEPTION: Definition, Search for examples

PROPAGATEORIGINALEXCEPTION: Definition, Search for examples

PROPANY Functions: Definition, Search for examples

PROPERTIES_T Table Type: Definition, Search for examples

PROPERTIESH2T Function: Definition, Search for examples

PROPERTIEST2H Function: Definition, Search for examples

PROPERTY_T Record Type: Definition, Search for examples

PROPNAME_BUCKET: Definition, Search for examples

PROPNAME_CACHESIZE: Definition, Search for examples

PROPNAME_COMPRESSLEVEL: Definition, Search for examples

PROPNAME_ENABLECLEANUPONDELETE: Definition, Search for examples

PROPNAME_HTTPPROXY: Definition, Search for examples

PROPNAME_LICENSEID: Definition, Search for examples

PROPNAME_LOBCACHE_QUOTA: Definition, Search for examples

PROPNAME_MAX: Definition, Search for examples

PROPNAME_MEDIAPOOL: Definition, Search for examples

PROPNAME_OPTTARBALLSIZE: Definition, Search for examples

PROPNAME_READCHUNKSIZE: Definition, Search for examples

PROPNAME_S3HOST: Definition, Search for examples

PROPNAME_SBT_LIBRARY: Definition, Search for examples

PROPNAME_STREAMABLE: Definition, Search for examples

PROPNAME_T: Definition, Search for examples

PROPNAME_WALLET: Definition, Search for examples

PROPNAME_WRITECHUNKSIZ: Definition, Search for examples

PROPNUMBER Function: Definition, Search for examples

PROPRAW Function: Definition, Search for examples

PROPTIMESTAMP Function: Definition, Search for examples

PROPVAL_COMPLVL_HIGH: Definition, Search for examples

PROPVAL_COMPLVL_LOW: Definition, Search for examples

PROPVAL_COMPLVL_MEDIUM: Definition, Search for examples

PROPVAL_COMPLVL_NONE: Definition, Search for examples

PROPVAL_MAX: Definition, Search for examples

PROPVAL_T: Definition, Search for examples

PROPVARCHAR2 Function: Definition, Search for examples

PROTOCOL_ERROR: Definition, Search for examples

PROXY: Definition, Search for examples

PROXY_SESSIONID: Definition, Search for examples

PS Procedure: Definition, Search for examples

PSERVICE_WAIT_SCT: Definition, Search for examples

PSERVICE_WAIT_TIME: Definition, Search for examples

PSEUDO_R_SQ_CS: Definition, Search for examples

PSEUDO_R_SQ_N: Definition, Search for examples

PUBLISH_PENDING_STATS Procedure: Definition, Search for examples

PULL_SIMPLE_TABLESPACE Procedure: Definition, Search for examples

PULL_TABLESPACES Procedure: Definition, Search for examples

PUP Table Administration: Definition, Search for examples

PUP Table Structure: Definition, Search for examples

PURGE Procedure: Definition, Search for examples

PURGE Procedure: Definition, Search for examples

PURGE Procedure: Definition, Search for examples

PURGE_CHANGE_SET Procedure: Definition, Search for examples

PURGE_CHANGE_TABLE Procedure: Definition, Search for examples

PURGE_COMPARISON Procedure: Definition, Search for examples

PURGE_DIRECT_LOAD_LOG Procedure: Definition, Search for examples

PURGE_EVENTS Procedure: Definition, Search for examples

PURGE_FILE_GROUP Procedure: Definition, Search for examples

PURGE_JOB_DISABLE: Definition, Search for examples

PURGE_JOB_ENABLE: Definition, Search for examples

PURGE_LOG Procedure: Definition, Search for examples

PURGE_LOG Procedure: Definition, Search for examples

PURGE_LOST_DB_ENTRY Procedure: Definition, Search for examples

PURGE_MIXED Procedure: Definition, Search for examples

PURGE_MVIEW_FROM_LOG Procedure: Definition, Search for examples

PURGE_PROCESSED_CHUNKS Procedure: Definition, Search for examples

PURGE_QUEUE_TABLE Procedure: Definition, Search for examples

PURGE_SESSION Procedure: Definition, Search for examples

PURGE_SOURCE_CATALOG Procedure: Definition, Search for examples

PURGE_SQL_DETAILS Procedure: Definition, Search for examples

PURGE_STATS Procedure: Definition, Search for examples

PURGE_WINDOW Procedure: Definition, Search for examples

PURGEALL Procedure: Definition, Search for examples

PURGEALL Procedure: Definition, Search for examples

PURGELDAPCACHE Function: Definition, Search for examples

PURGEPATH Procedure: Definition, Search for examples

PURGEPATH Procedure: Definition, Search for examples

PURGERESOURCEMETADATA Procedure: Definition, Search for examples

PURGESCHEMA Procedure: Definition, Search for examples

PUT Function: Definition, Search for examples

PUT Procedure: Definition, Search for examples

PUT Procedure: Definition, Search for examples

PUT_FILE Procedure: Definition, Search for examples

PUT_FILE Procedure: Definition, Search for examples

PUT_LINE Procedure: Definition, Search for examples

PUT_LINE Procedure: Definition, Search for examples

PUT_LINE_NCHAR Procedure: Definition, Search for examples

PUT_NCHAR Procedure: Definition, Search for examples

PUT_RAW Procedure: Definition, Search for examples

PUTF Procedure: Definition, Search for examples

PUTF_NCHAR Procedure: Definition, Search for examples

PUTPATH Procedures: Definition, Search for examples

PUTPATH Procedures: Definition, Search for examples

PX_DOWNGRADED_25_SEC: Definition, Search for examples

PX_DOWNGRADED_50_SEC: Definition, Search for examples

PX_DOWNGRADED_75_SEC: Definition, Search for examples

PX_DOWNGRADED_SEC: Definition, Search for examples

PX_DOWNGRADED_SER_SEC: Definition, Search for examples