Home
Home
Customize
Customize
Help
Help
Contact us
Contact Us

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

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

ABORT Procedure: Definition
ABORTED_REQUEST_THRESHOLD Procedure: Definition
ABORT_GLOBAL_INSTANTIATION Procedure: Definition
ABORT_REDEF_TABLE Procedure: Definition
ABORT_SCHEMA_INSTANTIATION Procedure: Definition
ABORT_TABLE_INSTANTIATION Procedure: Definition
ABS: Definition
ACCEPT: Definition
ACLCHECKPRIVILEGES Function: Definition
ACOS: Definition
ACTIVATE_SUBSCRIPTION Procedure: Definition
ACTIVE_INSTANCES Procedure: Definition
ADD2MULTI Procedure: Definition
ADDRESS Function: Definition
ADDRESS Procedure: Definition
ADD_ALIAS_TO_LDAP Procedure: Definition
ADD_COLUMN Procedure: Definition
ADD_COOKIES Procedure: Definition
ADD_ELEMENTARY_ATTRIBUTE Procedures: Definition
ADD_EVENT Procedures: Definition
ADD_EVENT_QUEUE_SUBSCRIBER Procedure: Definition
ADD_FILE Procedure: Definition
ADD_FILTER Procedures: Definition
ADD_FILTER_ITEM Procedure: Definition
ADD_FUNCTIONS Procedure: Definition
ADD_GLOBAL_PROPAGATION_RULES Procedure: Definition
ADD_GLOBAL_RULES Procedure: Definition
ADD_GROUPED_POLICY Procedure: Definition
ADD_LOGFILE Procedure: Definition
ADD_MESSAGE_PROPAGATION_RULE Procedure: Definition
ADD_MESSAGE_RULE Procedure: Definition
ADD_MONTHS: Definition
ADD_POLICY Procedure: Definition
ADD_POLICY_CONTEXT Procedure: Definition
ADD_RULE Procedure: Definition
ADD_SCHEMA_PROPAGATION_RULES Procedure: Definition
ADD_SCHEMA_RULES Procedure: Definition
ADD_SQLSET_REFERENCE Function: Definition
ADD_SQLWKLD_REF Procedure: Definition
ADD_SQLWKLD_STATEMENT Procedure: Definition
ADD_SUBSCRIBER Procedure: Definition
ADD_SUBSET_PROPAGATION_RULES Procedure: Definition
ADD_SUBSET_RULES Procedure: Definition
ADD_TABLE_PROPAGATION_RULES Procedure: Definition
ADD_TABLE_RULES Procedure: Definition
ADD_TRANSFORM Function: Definition
ADD_WARNING_SETTING_CAT Procedure: Definition
ADD_WARNING_SETTING_NUM Procedure: Definition
ADD_WINDOW_GROUP_MEMBER Procedure: Definition
ADMIN_TABLES Procedure: Definition
ADOPTNODE Function: Definition
ADVISE_COMMIT Procedure: Definition
ADVISE_NOTHING Procedure: Definition
ADVISE_ROLLBACK Procedure: Definition
ALLOCATE_UNIQUE Procedure: Definition
ALLOW_ALL Procedure: Definition
ALLOW_SERVER Procedure: Definition
ALL_ROWS Hint: Definition
ALTER CLUSTER: Definition
ALTER DATABASE: Definition
ALTER DIMENSION: Definition
ALTER DISKGROUP: Definition
ALTER FUNCTION: Definition
ALTER INDEX: Definition
ALTER INDEXTYPE: Definition
ALTER JAVA: Definition
ALTER MATERIALIZED VIEW: Definition
ALTER MATERIALIZED VIEW LOG: Definition
ALTER OPERATOR: Definition
ALTER OUTLINE: Definition
ALTER PACKAGE: Definition
ALTER PROCEDURE: Definition
ALTER PROFILE: Definition
ALTER RESOURCE COST: Definition
ALTER ROLE: Definition
ALTER ROLLBACK SEGMENT: Definition
ALTER SEQUENCE: Definition
ALTER SESSION: Definition
ALTER SYSTEM: Definition
ALTER TABLE: Definition
ALTER TABLESPACE: Definition
ALTER TRIGGER: Definition
ALTER TYPE: Definition
ALTER USER: Definition
ALTER VIEW: Definition
ALTER_AGENT Procedure: Definition
ALTER_APPLY Procedure: Definition
ALTER_AQ_AGENT Procedure: Definition
ALTER_AUTOLOG_CHANGE_SOURCE Procedure: Definition
ALTER_CAPTURE Procedure: Definition
ALTER_CHAIN Procedure: Definition
ALTER_CHANGE_SET Procedure: Definition
ALTER_CHANGE_TABLE Procedure: Definition
ALTER_COMPILE Procedure: Definition
ALTER_DATABASE_TAB_MONITORING Procedure: Definition
ALTER_EVALUATION_CONTEXT Procedure: Definition
ALTER_FILE Procedure: Definition
ALTER_FILE_GROUP Procedure: Definition
ALTER_HOTLOG_CHANGE_SOURCE Procedure: Definition
ALTER_PROPAGATION Procedure: Definition
ALTER_PROPAGATION_SCHEDULE Procedure: Definition
ALTER_QUEUE Procedure: Definition
ALTER_QUEUE_TABLE Procedure: Definition
ALTER_REWRITE_EQUIVALENCE Procedure: Definition
ALTER_RULE Procedure: Definition
ALTER_RUNNING_CHAIN Procedure: Definition
ALTER_SCHEMA_TAB_MONITORING Procedure: Definition
ALTER_SQL_PROFILE Procedure: Definition
ALTER_STATS_HISTORY_RETENTION Procedure: Definition
ALTER_SUBSCRIBER Procedure: Definition
ALTER_TABLE_NOT_REFERENCEABLE Procedure: Definition
ALTER_TABLE_REFERENCEABLE Procedure: Definition
ALTER_VERSION Procedure: Definition
AMATCH Function: Definition
ANALYZE: Definition
ANALYZE_DATABASE Procedure: Definition
ANALYZE_PART_OBJECT Procedure: Definition
ANALYZE_SCHEMA Procedure: Definition
ANCHOR Function: Definition
ANCHOR Procedure: Definition
ANCHOR2 Function: Definition
ANCHOR2 Procedure: Definition
ANSI Standards: Definition
ANYDATA: Definition
ANYDATA TYPE: Definition
ANYDATASET: Definition
ANYDATASET TYPE: Definition
ANYTYPE: Definition
ANYTYPE TYPE: Definition
APPEND: Definition
APPEND Hint: Definition
APPEND Procedures: Definition
APPENDCHILD Function: Definition
APPENDCHILDXML: Definition
APPENDDATA Procedure: Definition
APPENDRESOURCEMETADATA Procedure: Definition
APPLETCLOSE Function: Definition
APPLETCLOSE Procedure: Definition
APPLETOPEN Function: Definition
APPLETOPEN Procedure: Definition
APPLY Procedure: Definition
APPLY_SET Procedure: Definition
APPLY_UNSET Procedure: Definition
AQ$_AGENT Type: Definition
AQ$_AGENT_LIST_T Type: Definition
AQ$_DESCRIPTOR Type: Definition
AQ$_NTFN_DESCRIPTOR Type: Definition
AQ$_POST_INFO Type: Definition
AQ$_POST_INFO_LIST Type: Definition
AQ$_PURGE_OPTIONS_T Type: Definition
AQ$_RECIPIENT_LIST_T Type: Definition
AQ$_REG_INFO Type: Definition
AQ$_REG_INFO_LIST Type: Definition
AQ$_SUBSCRIBER_LIST_T Type: Definition
ARCHIVE LOG: Definition
ARCHIVELOG Mode: Definition
AREA Function: Definition
AREA Procedure: Definition
ASA_RECOMMENDATIONS Function: Definition
ASCII: Definition
ASCIISTR: Definition
ASH_REPORT_HTML Function: Definition
ASH_REPORT_TEXT Function: Definition
ASIN: Definition
ASSIGN_ATTRIBUTE_SET Procedure: Definition
ASSM_SEGMENT_VERIFY Procedure: Definition
ASSM_TABLESPACE_VERIFY Procedure: Definition
ASSOCIATE STATISTICS: Definition
ATAN: Definition
ATAN2: Definition
ATTACH Function: Definition
ATTACH_SESSION Procedure: Definition
ATTACH_SIMPLE_TABLESPACE Procedure: Definition
ATTACH_TABLESPACES Procedure: Definition
ATTRIBUTE: Definition
AUDIT: Definition
AUTHORIZE Function: Definition
AUTHORIZE_DAD Procedure: Definition
AUTONOMOUS_TRANSACTION Pragma: Definition
AVAILABLE Function: Definition
AVG: Definition
AWR_DIFF_REPORT_HTML Function: Definition
AWR_DIFF_REPORT_TEXT Function: Definition
AWR_REPORT_HTML Function: Definition
AWR_REPORT_TEXT Function: Definition
AWR_SQL_REPORT_HTML Function: Definition
AWR_SQL_REPORT_TEXT Function: Definition
LAG: Definition
LAPACK_GBSV Procedures: Definition
LAPACK_GEES Procedures: Definition
LAPACK_GEEV Procedures: Definition
LAPACK_GELS Procedures: Definition
LAPACK_GESDD Procedures: Definition
LAPACK_GESV Procedures: Definition
LAPACK_GESVD Procedures: Definition
LAPACK_GTSV Procedures: Definition
LAPACK_PBSV Procedures: Definition
LAPACK_POSV Procedures: Definition
LAPACK_PPSV Procedures: Definition
LAPACK_PTSV Procedures: Definition
LAPACK_SBEV Procedures: Definition
LAPACK_SBEVD Procedures: Definition
LAPACK_SPEV Procedures: Definition
LAPACK_SPEVD Procedures: Definition
LAPACK_SPSV Procedures: Definition
LAPACK_STEV Procedures: Definition
LAPACK_STEVD Procedures: Definition
LAPACK_SYEV Procedures: Definition
LAPACK_SYEVD Procedures: Definition
LAPACK_SYSV Procedures: Definition
LAST: Definition
LAST_DAY: Definition
LAST_ERROR_POSITION Function: Definition
LAST_ROW_COUNT Function: Definition
LAST_ROW_ID Function: Definition
LAST_SQL_FUNCTION_CODE Function: Definition
LAST_VALUE: Definition
LCR$_DDL_RECORD Constructor: Definition
LCR$_DDL_RECORD Type: Definition
LCR$_ROW_LIST Type: Definition
LCR$_ROW_RECORD Constructor: Definition
LCR$_ROW_RECORD Type: Definition
LCR$_ROW_UNIT Type: Definition
LCR_TO_XML Function: Definition
LEAD: Definition
LEADING Hint: Definition
LEAST: Definition
LENGTH: Definition
LENGTH Function: Definition
LEVEL Pseudocolumn: Definition
LIKE Condition: Definition
LIKE Operator: Definition
LINE Function: Definition
LINE Procedure: Definition
LINK Procedure: Definition
LINKREL Function: Definition
LINKREL Procedure: Definition
LINKREV Function: Definition
LINKREV Procedure: Definition
LIST: Definition
LISTEN Procedures: Definition
LISTHEADER Function: Definition
LISTHEADER Procedure: Definition
LISTINGCLOSE Function: Definition
LISTINGCLOSE Procedure: Definition
LISTINGOPEN Function: Definition
LISTINGOPEN Procedure: Definition
LISTITEM Function: Definition
LISTITEM Procedure: Definition
LISTPRINT Procedure: Definition
LIST_CONTEXT Procedures: Definition
LN: Definition
LNNVL: Definition
LOADBLOBFROMFILE Procedure: Definition
LOADCLOBFROMFILE Procedure: Definition
LOADFROMFILE Procedure: Definition
LOAD_SQLSET Procedure: Definition
LOAD_WORKLOAD_CACHE Procedure: Definition
LOAD_WORKLOAD_TRACE Procedure: Definition
LOAD_WORKLOAD_USER Procedure: Definition
LOCALTIMESTAMP: Definition
LOCAL_TRANSACTION_ID Function: Definition
LOCK TABLE: Definition
LOCK TABLE Statement: Definition
LOCKRESOURCE Function: Definition
LOCK_MAP Procedure: Definition
LOCK_OBJECT Procedure: Definition
LOCK_SCHEMA_STATS Procedure: Definition
LOCK_TABLE_STATS Procedure: Definition
LOG: Definition
LOGON Option: Definition
LOG_ENTRY Procedure: Definition
LOOP Statements: Definition
LOWER: Definition
LPAD: Definition
LTRIM: Definition
LZ_COMPRESS_ADD Procedure: Definition
LZ_COMPRESS_CLOSE: Definition
LZ_COMPRESS_OPEN: Definition
LZ_UNCOMPRESS_CLOSE Procedure: Definition
LZ_UNCOMPRESS_EXTRACT Procedure: Definition
LZ_UNCOMPRESS_OPEN Function: Definition
NAME_COL_LEN: Definition
NAME_RESOLVE Procedure: Definition
NAME_TOKENIZE Procedure: Definition
NANVL: Definition
NCHAR Datatype: Definition
NCHAR Datatype: Definition
NCHR: Definition
NCLOB Datatype: Definition
NCLOB Datatype: Definition
NEWCONTEXT: Definition
NEWCONTEXT Functions: Definition
NEWDOMDOCUMENT Functions: Definition
NEWPARSER: Definition
NEWPROCESSOR Function: Definition
NEWSTYLESHEET Functions: Definition
NEW_LINE Procedure: Definition
NEW_REG_START Function: Definition
NEW_TIME: Definition
NEXT_DATE Procedure: Definition
NEXT_DAY: Definition
NEXT_ITEM_TYPE Function: Definition
NL Function: Definition
NL Procedure: Definition
NLSSORT: Definition
NLS_CHARSET_DECL_LEN: Definition
NLS_CHARSET_ID: Definition
NLS_CHARSET_NAME: Definition
NLS_INITCAP: Definition
NLS_LOWER: Definition
NLS_UPPER: Definition
NOAPPEND Hint: Definition
NOAUDIT: Definition
NOBR Function: Definition
NOBR Procedure: Definition
NOCACHE Hint: Definition
NOFRAMESCLOSE Function: Definition
NOFRAMESCLOSE Procedure: Definition
NOFRAMESOPEN Function: Definition
NOFRAMESOPEN Procedure: Definition
NOPARALLEL Hint: Definition
NOPARALLEL_INDEX Hint: Definition
NOREWRITE Hint: Definition
NORMAL Function: Definition
NORMALIZE Procedure: Definition
NORMAL_DIST_FIT Procedure: Definition
NO_EXPAND Hint: Definition
NO_FACT Hint: Definition
NO_INDEX Hint: Definition
NO_INDEX_FFS Hint: Definition
NO_INDEX_SS Hint: Definition
NO_MERGE Hint: Definition
NO_PARALLEL Hint: Definition
NO_PARALLEL_INDEX Hint: Definition
NO_PUSH_PRED Hint: Definition
NO_PUSH_SUBQ Hint: Definition
NO_PX_JOIN_FILTER Hint: Definition
NO_QUERY_TRANSFORMATION Hint: Definition
NO_REWRITE Hint: Definition
NO_STAR_TRANSFORMATION Hint: Definition
NO_UNNEST Hint: Definition
NO_USE_HASH Hint: Definition
NO_USE_MERGE Hint: Definition
NO_USE_NL Hint: Definition
NO_XML_QUERY_REWRITE Hint: Definition
NTILE: Definition
NULL Statement: Definition
NULLIF: Definition
NUMBER Datatype: Definition
NUMBER Datatype: Definition
NUMBER_TABLE: Definition
NUMTODSINTERVAL: Definition
NUMTOYMINTERVAL: Definition
NVARCHAR2 Datatype: Definition
NVARCHAR2 Datatype: Definition
NVARRAY_ADD Procedure: Definition
NVARRAY_FIND_NAME Function: Definition
NVARRAY_FIND_NAME_TYPE Function: Definition
NVARRAY_GET Function: Definition
NVARRAY_GET_BOOLEAN Function: Definition
NVARRAY_GET_BYTE Function: Definition
NVARRAY_GET_DATE Function: Definition
NVARRAY_GET_DOUBLE Function: Definition
NVARRAY_GET_FLOAT Function: Definition
NVARRAY_GET_INTEGER Function: Definition
NVARRAY_GET_LONG Function: Definition
NVARRAY_GET_RAW Function: Definition
NVARRAY_GET_SHORT Function: Definition
NVARRAY_GET_TEXT Function: Definition
NVL: Definition
NVL2: 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