Home
Home
Customize
Customize
Help
Help
Contact us
Contact Us

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

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

FACT Hint: Definition
FCLOSE Procedure: Definition
FCLOSE_ALL Procedure: Definition
FCOPY Procedure: Definition
FEATURE_ID: Definition
FEATURE_SET: Definition
FEATURE_VALUE: Definition
FETCH Statement: Definition
FETCH_ROW Function: Definition
FETCH_ROWS Function: Definition
FFLUSH Procedure: Definition
FGETATTR Procedure: Definition
FGETPOS Function: Definition
FILE Type: Definition
FILECLOSE Procedure: Definition
FILECLOSEALL Procedure: Definition
FILEEXISTS Function: Definition
FILEGETNAME Procedure: Definition
FILEISOPEN Function: Definition
FILEOPEN Procedure: Definition
FILE_SET Type: Definition
FINDENTITY Function: Definition
FINDNOTATION Function: Definition
FINISH_CAPTURE Procedure: Definition
FINISH_REDEF_TABLE Procedure: Definition
FIRST: Definition
FIRST_ROWS Hint: Definition
FIRST_VALUE: Definition
FIX_CORRUPT_BLOCKS Procedure: Definition
FI_HORIZONTAL Function: Definition
FI_TRANSACTIONAL Function: Definition
FLASHBACK DATABASE: Definition
FLASHBACK TABLE: Definition
FLOOR: Definition
FLUSH Procedure: Definition
FLUSH_DATABASE_MONITORING_INFO Procedure: Definition
FONTCLOSE Function: Definition
FONTCLOSE Procedure: Definition
FONTOPEN Function: Definition
FONTOPEN Procedure: Definition
FOPEN Function: Definition
FOPEN_NCHAR Function: Definition
FORALL Statement: Definition
FORMAT_CALL_STACK Function: Definition
FORMAT_CELL Function: Definition
FORMAT_ERROR_BACKTRACE Function: Definition
FORMAT_ERROR_STACK Function: Definition
FORMAT_MESSAGE Function: Definition
FORMCHECKBOX Function: Definition
FORMCHECKBOX Procedure: Definition
FORMCLOSE Function: Definition
FORMCLOSE Procedure: Definition
FORMFILE Function: Definition
FORMFILE Procedure: Definition
FORMHIDDEN Function: Definition
FORMHIDDEN Procedure: Definition
FORMIMAGE Function: Definition
FORMIMAGE Procedure: Definition
FORMOPEN Function: Definition
FORMOPEN Procedure: Definition
FORMPASSWORD Function: Definition
FORMPASSWORD Procedure: Definition
FORMRADIO Function: Definition
FORMRADIO Procedure: Definition
FORMRESET Function: Definition
FORMRESET Procedure: Definition
FORMSELECTCLOSE Function: Definition
FORMSELECTCLOSE Procedure: Definition
FORMSELECTOPEN Function: Definition
FORMSELECTOPEN Procedure: Definition
FORMSELECTOPTION Function: Definition
FORMSELECTOPTION Procedure: Definition
FORMSUBMIT Function: Definition
FORMSUBMIT Procedure: Definition
FORMTEXT Function: Definition
FORMTEXT Procedure: Definition
FORMTEXTAREA Function: Definition
FORMTEXTAREA Procedure: Definition
FORMTEXTAREA2 Function: Definition
FORMTEXTAREA2 Procedure: Definition
FORMTEXTAREACLOSE Function: Definition
FORMTEXTAREACLOSE Procedure: Definition
FORMTEXTAREAOPEN Function: Definition
FORMTEXTAREAOPEN Procedure: Definition
FORMTEXTAREAOPEN2 Function: Definition
FORMTEXTAREAOPEN2 Procedure: Definition
FRAME Function: Definition
FRAME Procedure: Definition
FRAMESETCLOSE Function: Definition
FRAMESETCLOSE Procedure: Definition
FRAMESETOPEN Function: Definition
FRAMESETOPEN Procedure: Definition
FREEDOCFRAG Procedure: Definition
FREEDOCUMENT Procedure: Definition
FREENODE Procedure: Definition
FREEPARSER: Definition
FREEPROCESSOR Procedure: Definition
FREESTYLESHEET Procedure: Definition
FREETEMPORARY Procedures: Definition
FREE_BLOCKS Procedure: Definition
FREE_UNUSED_USER_MEMORY Procedure: Definition
FREMOVE Procedure: Definition
FRENAME Procedure: Definition
FROM_TZ: Definition
FSEEK Procedure: Definition
FULL Hint: Definition
IF Statement: Definition
IMG Function: Definition
IMG Procedure: Definition
IMG2 Function: Definition
IMG2 Procedure: Definition
IMPLEMENT_TASK Procedure: Definition
IMPORTNODE Function: Definition
IMPORT_AWR Function: Definition
IMPORT_COLUMN_STATS Procedure: Definition
IMPORT_DATABASE_STATS Procedure: Definition
IMPORT_DICTIONARY_STATS Procedure: Definition
IMPORT_FIXED_OBJECTS_STATS Procedure: Definition
IMPORT_INDEX_STATS Procedure: Definition
IMPORT_MODEL Procedure: Definition
IMPORT_SCHEMA_STATS Procedure: Definition
IMPORT_SQLWKLD_SCHEMA Procedure: Definition
IMPORT_SQLWKLD_SQLCACHE Procedure: Definition
IMPORT_SQLWKLD_STS Procedure: Definition
IMPORT_SQLWKLD_SUMADV Procedure: Definition
IMPORT_SQLWKLD_USER Procedure: Definition
IMPORT_SYSTEM_STATS Procedure: Definition
IMPORT_TABLE_STATS Procedure: Definition
IN Condition: Definition
IN Operator: Definition
INCLUDE_EXTRA_ATTRIBUTE Procedure: Definition
INDEX Hint: Definition
INDEX_ASC Hint: Definition
INDEX_COMBINE Hint: Definition
INDEX_DESC Hint: Definition
INDEX_FFS Hint: Definition
INDEX_JOIN Hint: Definition
INDEX_PARAMETERS Procedure: Definition
INDEX_SS Hint: Definition
INDEX_SS_ASC Hint: Definition
INDEX_SS_DESC Hint: Definition
INITCAP: Definition
INITIALIZE Function: Definition
INITIALIZE Procedure: Definition
INPUT: Definition
INSERT: Definition
INSERT Statement: Definition
INSERTBEFORE Function: Definition
INSERTCHILDXML: Definition
INSERTDATA Procedure: Definition
INSERTXML: Definition
INSERTXMLBEFORE: Definition
INSERT_AUTOBIN_NUM_EQWIDTH Procedure: Definition
INSERT_BIN_CAT_FREQ Procedure: Definition
INSERT_BIN_NUM_EQWIDTH Procedure: Definition
INSERT_BIN_NUM_QTILE Procedure: Definition
INSERT_CLIP_TRIM_TAIL Procedure: Definition
INSERT_CLIP_WINSOR_TAIL Procedure: Definition
INSERT_MISS_CAT_MODE Procedure: Definition
INSERT_MISS_NUM_MEAN Procedure: Definition
INSERT_NORM_LIN_MINMAX Procedure: Definition
INSERT_NORM_LIN_SCALE Procedure: Definition
INSERT_NORM_LIN_ZSCORE Procedure: Definition
INSTANCE Procedure: Definition
INSTANTIATE_TABLE Procedure: Definition
INSTR: Definition
INSTR Functions: Definition
INTERNAL_VERSION_CHECK Function: Definition
INTERRUPT_TASK Procedure: Definition
INTERRUPT_TUNING_TASK Procedure: Definition
INTERVAL DAY TO SECOND: Definition
INTERVAL DAY TO SECOND Datatype: Definition
INTERVAL DAY TO SECOND Datatype: Definition
INTERVAL Procedure: Definition
INTERVAL YEAR TO MONTH: Definition
INTERVAL YEAR TO MONTH Datatype: Definition
INTERVAL YEAR TO MONTH Datatype: Definition
INTERVAL_DAY_TO_SECOND_TABLE: Definition
INTERVAL_YEAR_TO_MONTH_TABLE: Definition
INVALIDATE Procedure: Definition
INVOKE Function: Definition
IS A SET Condition: Definition
IS ANY Condition: Definition
IS EMPTY Condition: Definition
IS NULL Operator: Definition
IS PRESENT Condition: Definition
ISFRAGMENT: Definition
ISINDEX Function: Definition
ISINDEX Procedure: Definition
ISNULL Functions: Definition
ISO Standards: Definition
ISOPEN Function: Definition
ISOPEN Functions: Definition
ISSCHEMABASED: Definition
ISSCHEMAVALID: Definition
ISSCHEMAVALIDATED: Definition
ISTEMPORARY Functions: Definition
IS_CLUSTER_DATABASE Function: Definition
IS_HIERARCHY_ENABLED Function: Definition
IS_LOCATOR Function: Definition
IS_OPEN Function: Definition
IS_ROLE_ENABLED Function: Definition
IS_SESSION_ALIVE Function: Definition
IS_TRIGGER_FIRE_ONCE Function: Definition
ITALIC Function: Definition
ITALIC Procedure: Definition
ITEM Functions: Definition
ITERATION_NUMBER: Definition
I_AM_A_REFRESH Function: Definition
PACK_MESSAGE Procedures: Definition
PACK_STGTAB_SQLPROF Procedure: Definition
PACK_STGTAB_SQLSET Procedure: Definition
PARA Function: Definition
PARA Procedure: Definition
PARAGRAPH Function: Definition
PARAGRAPH Procedure: Definition
PARALLEL Hint: Definition
PARALLEL_INDEX Hint: Definition
PARAM Function: Definition
PARAM Procedure: Definition
PARSE: Definition
PARSE Procedure: Definition
PARSEBUFFER: Definition
PARSECLOB: Definition
PARSEDTD: Definition
PARSEDTDBUFFER: Definition
PARSEDTDCLOB: Definition
PASSWORD: Definition
PATH: Definition
PAUSE: Definition
PERCENTILE_CONT: Definition
PERCENTILE_DISC: Definition
PERCENT_RANK: Definition
PING Procedure: Definition
PL/SQL Architecture: Definition
PL/SQL Datatypes: Definition
PL/SQL LOB Types: Definition
PLAINTEXT Function: Definition
PLAINTEXT Procedure: Definition
PLSQL_TRACE_VERSION Procedure: Definition
PLS_INTEGER Datatype: Definition
PMARKER Function: Definition
POISSON_DIST_FIT Procedure: Definition
PORT_STRING Function: Definition
POST Procedure: Definition
POST_INSTANTIATION_SETUP Procedure: Definition
POWER: Definition
POWERMULTISET: Definition
POWERMULTISET_BY_CARDINALITY: Definition
PQ_DISTRIBUTE Hint: Definition
PRECLOSE Function: Definition
PRECLOSE Procedure: Definition
PREDICT Procedure: Definition
PREDICTION: Definition
PREDICTION_COST: Definition
PREDICTION_DETAILS: Definition
PREDICTION_PROBABILITY: Definition
PREDICTION_SET: Definition
PREOPEN Function: Definition
PREOPEN Procedure: Definition
PREPARE_COLUMN_VALUES Procedures: Definition
PREPARE_COLUMN_VALUES_NVARCHAR2 Procedure: Definition
PREPARE_COLUMN_VALUES_ROWID Procedure: Definition
PREPARE_FOR_NEW_PRIMARY Procedure: Definition
PREPARE_GLOBAL_INSTANTIATION Procedure: Definition
PREPARE_SCHEMA_INSTANTIATION Procedure: Definition
PREPARE_TABLE_INSTANTIATION Procedure: Definition
PRESENTNNV: Definition
PRESENTV: Definition
PREVIOUS: Definition
PRE_INSTANTIATION_SETUP Procedure: Definition
PRINT: Definition
PRINT Functions: Definition
PRINT Procedures: Definition
PRINTS Procedure: Definition
PRINT_BACKTRACE Procedure: Definition
PRINT_CGI_ENV Procedure: Definition
PRINT_INSTANTIATIONS Procedure: Definition
PRINT_MULTI Procedure: Definition
PRINT_POST_PROCESSED_SOURCE Procedures: Definition
PRINT_ROW_LIST Procedure: Definition
PRIOR: Definition
PRN Functions: Definition
PRN Procedures: Definition
PROBE_VERSION Procedure: Definition
PROCESS_RULES Procedure: Definition
PRODUCT_USER_PROFILE Table: Definition
PROMPT: Definition
PROPAGATEORIGINALEXCEPTION: Definition
PS Procedure: Definition
PULL_SIMPLE_TABLESPACE Procedure: Definition
PULL_TABLESPACES Procedure: Definition
PURGE: Definition
PURGE Procedure: Definition
PURGELDAPCACHE Function: Definition
PURGERESOURCEMETADATA Procedure: Definition
PURGE_CHANGE_SET Procedure: Definition
PURGE_CHANGE_TABLE Procedure: Definition
PURGE_DIRECT_LOAD_LOG Procedure: Definition
PURGE_FILE_GROUP Procedure: Definition
PURGE_FILTER Procedure: Definition
PURGE_LOG Procedure: Definition
PURGE_LOST_DB_ENTRY Procedure: Definition
PURGE_MIXED Procedure: Definition
PURGE_MVIEW_FROM_LOG Procedure: Definition
PURGE_QUEUE_TABLE Procedure: Definition
PURGE_RESULTS Procedure: Definition
PURGE_SESSION Procedure: Definition
PURGE_SOURCE_CATALOG Procedure: Definition
PURGE_STATS Procedure: Definition
PURGE_WINDOW Procedure: Definition
PURGE_WORKLOAD Procedure: Definition
PUSH_PRED Hint: Definition
PUSH_SUBQ Hint: Definition
PUT Function: Definition
PUT Procedure: Definition
PUTF Procedure: Definition
PUTF_NCHAR Procedure: Definition
PUT_FILE Procedure: Definition
PUT_LINE Procedure: Definition
PUT_LINE_NCHAR Procedure: Definition
PUT_NCHAR Procedure: Definition
PUT_RAW Function: Definition
PX_JOIN_FILTER Hint: Definition