Home
Home
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

A SQL*Plus Limits: Definition, Search for examples
A: Definition, Search for examples
ABNS_MAX_BUILD_MINUTES: Definition, Search for examples
ABNS_MAX_NB_PREDICTORS: Definition, Search for examples
ABNS_MAX_PREDICTORS: Definition, Search for examples
ABNS_MODEL_TYPE: Definition, Search for examples
ABORT Procedure: Definition, Search for examples
ABORT_GLOBAL_INSTANTIATION Procedure: Definition, Search for examples
ABORT_REDEF_TABLE Procedure: Definition, Search for examples
ABORT_SCHEMA_INSTANTIATION Procedure: Definition, Search for examples
ABORT_SYNC_INSTANTIATION Procedure: Definition, Search for examples
ABORT_TABLE_INSTANTIATION Procedure: Definition, Search for examples
ABORTED_REQUEST_THRESHOLD Procedure: Definition, Search for examples
ACCEPT: Definition, Search for examples
ACCEPT: Definition, Search for examples
ACCEPT: Definition, Search for examples
ACCESS_DENIED: Definition, Search for examples
ACCESS_ERROR: Definition, Search for examples
ACCESS_INTO_NULL: Definition, Search for examples
ACCESS_INTO_NULL: Definition, Search for examples
ACLCHECKPRIVILEGES Function: Definition, Search for examples
ACTION_ID: Definition, Search for examples
ACTION_NAME: Definition, Search for examples
ACTIVATE_SUBSCRIPTION Procedure: Definition, Search for examples
ACTIVE_INSTANCES Procedure: Definition, Search for examples
ACTUAL_TARGET_VALUE: Definition, Search for examples
ADD: Definition, Search for examples
ADD2MULTI Procedure: Definition, Search for examples
ADD_<> Methods: Definition, Search for examples
ADD_ALIAS_TO_LDAP Procedure: Definition, Search for examples
ADD_CAPTURE Function: Definition, Search for examples
ADD_COLORED_SQL Procedure: Definition, Search for examples
ADD_COLUMN Member Procedure: Definition, Search for examples
ADD_COLUMN Procedure: Definition, Search for examples
ADD_COLUMN: Definition, Search for examples
ADD_COOKIES Procedure: Definition, Search for examples
ADD_COST_MATRIX Procedure: Definition, Search for examples
ADD_DOCUMENT Procedure: Definition, Search for examples
ADD_ELEMENTARY_ATTRIBUTE Procedures: Definition, Search for examples
ADD_ELEMENTARY_ATTRIBUTE Procedures: Definition, Search for examples
ADD_EVENT Procedure: Definition, Search for examples
ADD_EVENT_QUEUE_SUBSCRIBER Procedure: Definition, Search for examples
ADD_FILE Procedure: Definition, Search for examples
ADD_FILE Procedure: Definition, Search for examples
ADD_FILTER Procedure: Definition, Search for examples
ADD_FILTER Procedures: Definition, Search for examples
ADD_FUNCTIONS Procedure: Definition, Search for examples
ADD_FUNCTIONS Procedure: Definition, Search for examples
ADD_GLOBAL_PROPAGATION_RULES Procedure: Definition, Search for examples
ADD_GLOBAL_RULES Procedure: Definition, Search for examples
ADD_GROUP_MEMBER Procedure: Definition, Search for examples
ADD_GROUPED_POLICY Procedure: Definition, Search for examples
ADD_JOB_EMAIL_NOTIFICATION Procedure: Definition, Search for examples
ADD_LOGFILE Procedure: Definition, Search for examples
ADD_MESSAGE_PROPAGATION_RULE Procedure: Definition, Search for examples
ADD_MESSAGE_RULE Procedure: Definition, Search for examples
ADD_PAIR Member Procedure: Definition, Search for examples
ADD_POLICY Procedure: Definition, Search for examples
ADD_POLICY Procedure: Definition, Search for examples
ADD_POLICY Procedure: Definition, Search for examples
ADD_POLICY_CONTEXT Procedure: Definition, Search for examples
ADD_PRIVILEGE Procedure: Definition, Search for examples
ADD_RULE Procedure: Definition, Search for examples
ADD_RULE Procedure: Definition, Search for examples
ADD_SCHEDULE_ORDERING Function: Definition, Search for examples
ADD_SCHEMA_PROPAGATION_RULES Procedure: Definition, Search for examples
ADD_SCHEMA_RULES Procedure: Definition, Search for examples
ADD_SCHEME Procedure: Definition, Search for examples
ADD_SQLSET_REFERENCE Function: Definition, Search for examples
ADD_SQLWKLD_REF Procedure: Definition, Search for examples
ADD_SQLWKLD_STATEMENT Procedure: Definition, Search for examples
ADD_STMT_HANDLER Procedure: Definition, Search for examples
ADD_STMT_TO_HANDLER Procedure: Definition, Search for examples
ADD_STS_REF Procedure: Definition, Search for examples
ADD_SUBSCRIBER Procedure: Definition, Search for examples
ADD_SUBSCRIBER Procedure: Definition, Search for examples
ADD_SUBSET_PROPAGATION_RULES Procedure: Definition, Search for examples
ADD_SUBSET_RULES Procedure: Definition, Search for examples
ADD_TABLE_PROPAGATION_RULES Procedure: Definition, Search for examples
ADD_TABLE_RULES Procedure: Definition, Search for examples
ADD_TRANSFORM Function: Definition, Search for examples
ADD_WARNING_SETTING_CAT Procedure: Definition, Search for examples
ADD_WARNING_SETTING_NUM Procedure: Definition, Search for examples
ADD_WINDOW_GROUP_MEMBER Procedure: Definition, Search for examples
ADDATTR Member Procedure: Definition, Search for examples
ADDFILE: Definition, Search for examples
ADDHTTPEXPIREMAPPING Procedure: Definition, Search for examples
ADDINSTANCE Member Procedure: Definition, Search for examples
ADDMIMEMAPPING Procedure: Definition, Search for examples
ADDREPOSITORYRESCONFIG Procedure: Definition, Search for examples
ADDRESCONFIG Procedure: Definition, Search for examples
ADDRESS Function: Definition, Search for examples
ADDRESS Procedure: Definition, Search for examples
ADDSCHEMALOCMAPPING Procedure: Definition, Search for examples
ADDSERVLET Procedure: Definition, Search for examples
ADDSERVLETMAPPING Procedure: Definition, Search for examples
ADDSERVLETSECROLE Procedure: Definition, Search for examples
ADDTOPS: Definition, Search for examples
ADDUNIQUEKEYPREFIX: Definition, Search for examples
ADDXMLEXTENSION Procedure: Definition, Search for examples
ADJUSTED_R_SQUARE: Definition, Search for examples
ADM_DROP_CHUNKS Procedure: Definition, Search for examples
ADM_DROP_TASK Procedure: Definition, Search for examples
ADM_STOP_TASK Procedure: Definition, Search for examples
ADM_TASK_STATUS Procedure: Definition, Search for examples
ADMIN_TABLES Procedure: Definition, Search for examples
ADOPTNODE Function: Definition, Search for examples
ADT Examples : Definition, Search for examples
ADV_SQL_DIAG_NAME: Definition, Search for examples
ADVICETYPE: Definition, Search for examples
ADVISE_COMMIT Procedure: Definition, Search for examples
ADVISE_NOTHING Procedure: Definition, Search for examples
ADVISE_ROLLBACK Procedure: Definition, Search for examples
ADVISOR_RUN_ID: Definition, Search for examples
ADVISOR_RUN_REASON: Definition, Search for examples
ADVISOR_RUN_TIME: Definition, Search for examples
AFTER: Definition, Search for examples
AGENT_JAVA_PROP: Definition, Search for examples
AIC: Definition, Search for examples
AIC_INTERCEPT: Definition, Search for examples
AIC_MODEL: Definition, Search for examples
ALGO_ADAPTIVE_BAYES_NETWORK: Definition, Search for examples
ALGO_AI_MDL: Definition, Search for examples
ALGO_APRIORI_ASSOCIATION_RULES: Definition, Search for examples
ALGO_DECISION_TREE: Definition, Search for examples
ALGO_GENERALIZED_LINEAR_MODEL: Definition, Search for examples
ALGO_KMEANS: Definition, Search for examples
ALGO_NAIVE_BAYES: Definition, Search for examples
ALGO_NONNEGATIVE_MATRIX_FACTOR: Definition, Search for examples
ALGO_O_CLUSTER: Definition, Search for examples
ALGO_SUPPORT_VECTOR_MACHINES: Definition, Search for examples
ALL: Definition, Search for examples
ALL: Definition, Search for examples
ALL_OPERATIONS: Definition, Search for examples
ALL_ROWS: Definition, Search for examples
ALL_ROWS: Definition, Search for examples
ALL_SCHEMES: Definition, Search for examples
ALL_TSTZ_TABLES: Definition, Search for examples
ALL_XML_SCHEMAS: Definition, Search for examples
ALL_XML_TAB_COLS: Definition, Search for examples
ALL_XML_TABLES: Definition, Search for examples
ALL_XML_VIEW_COLS: Definition, Search for examples
ALL_XML_VIEWS: Definition, Search for examples
ALLOCATE_UNIQUE Procedure: Definition, Search for examples
ALLOW_ALL Procedure: Definition, Search for examples
ALLOW_SERVER Procedure: Definition, Search for examples
ALTER Statements: Definition, Search for examples
ALTER: Definition, Search for examples
ALTER_AGENT Procedures: Definition, Search for examples
ALTER_APPLY Procedure: Definition, Search for examples
ALTER_AQ_AGENT Procedure: Definition, Search for examples
ALTER_AUTOLOG_CHANGE_SOURCE Procedure: Definition, Search for examples
ALTER_CAPTURE Procedure: Definition, Search for examples
ALTER_CHAIN Procedure: Definition, Search for examples
ALTER_CHANGE_SET Procedure: Definition, Search for examples
ALTER_CHANGE_TABLE Procedure: Definition, Search for examples
ALTER_COMPILE Procedure: Definition, Search for examples
ALTER_EVALUATION_CONTEXT Procedure: Definition, Search for examples
ALTER_FILE Procedure: Definition, Search for examples
ALTER_FILE_GROUP Procedure: Definition, Search for examples
ALTER_HOTLOG_CHANGE_SOURCE Procedure: Definition, Search for examples
ALTER_JOB Procedure: Definition, Search for examples
ALTER_MONITORING Procedure: Definition, Search for examples
ALTER_PARAM Procedure: Definition, Search for examples
ALTER_POLICY Procedure: Definition, Search for examples
ALTER_PROPAGATION Procedure: Definition, Search for examples
ALTER_PROPAGATION_SCHEDULE Procedure: Definition, Search for examples
ALTER_PROPAGATION_SCHEDULE Procedure: Definition, Search for examples
ALTER_QUEUE Procedure: Definition, Search for examples
ALTER_QUEUE_TABLE Procedure: Definition, Search for examples
ALTER_REVERSE_EXPRESSION Procedure: Definition, Search for examples
ALTER_REWRITE_EQUIVALENCE Procedure: Definition, Search for examples
ALTER_RULE Procedure: Definition, Search for examples
ALTER_RUNNING_CHAIN Procedure: Definition, Search for examples
ALTER_SQL_PATCH Procedure: Definition, Search for examples
ALTER_SQL_PLAN_BASELINE Function: Definition, Search for examples
ALTER_SQL_PROFILE Procedure: Definition, Search for examples
ALTER_STATS_HISTORY_RETENTION Procedure: Definition, Search for examples
ALTER_SUBSCRIBER Procedure: Definition, Search for examples
ALTER_SUBSCRIBER Procedure: Definition, Search for examples
ALTER_SYNC_CAPTURE Procedure: Definition, Search for examples
ALTER_TABLE_NOT_REFERENCEABLE Procedure: Definition, Search for examples
ALTER_TABLE_REFERENCEABLE Procedure: Definition, Search for examples
ALTER_VERSION Procedure: Definition, Search for examples
ALTERED_TIME: Definition, Search for examples
ALTEROP: Definition, Search for examples
AMATCH Function: Definition, Search for examples
ANALYSIS_SCOPE: Definition, Search for examples
ANALYZE Function: Definition, Search for examples
ANALYZE Procedure: Definition, Search for examples
ANALYZE: Definition, Search for examples
ANALYZE_CURRENT_PERFORMANCE Procedure: Definition, Search for examples
ANALYZE_DATABASE Procedure: Definition, Search for examples
ANALYZE_DB Procedure: Definition, Search for examples
ANALYZE_INST Procedure: Definition, Search for examples
ANALYZE_PART_OBJECT Procedure: Definition, Search for examples
ANALYZE_PARTIAL Procedure: Definition, Search for examples
ANALYZE_SCHEMA Procedure: Definition, Search for examples
ANCHOR Function: Definition, Search for examples
ANCHOR Procedure: Definition, Search for examples
ANCHOR2 Function: Definition, Search for examples
ANCHOR2 Procedure: Definition, Search for examples
AND: Definition, Search for examples
APEX_APPLICATION: Definition, Search for examples
APEX_CUSTOM_AUTH: Definition, Search for examples
APEX_ITEM: Definition, Search for examples
APEX_UTIL: Definition, Search for examples
APIOBJECT: Definition, Search for examples
APPEND Procedures: Definition, Search for examples
APPEND: Definition, Search for examples
APPEND: Definition, Search for examples
APPEND: Definition, Search for examples
APPENDCHILD Function: Definition, Search for examples
APPENDDATA Procedure: Definition, Search for examples
APPENDPATH Procedure: Definition, Search for examples
APPENDRESCONFIG Procedure: Definition, Search for examples
APPENDRESOURCEMETADATA Procedure: Definition, Search for examples
APPLETCLOSE Function: Definition, Search for examples
APPLETCLOSE Procedure: Definition, Search for examples
APPLETOPEN Function: Definition, Search for examples
APPLETOPEN Procedure: Definition, Search for examples
APPLY Procedure: Definition, Search for examples
APPLY_SERVERS: Definition, Search for examples
APPLY_SET Procedure: Definition, Search for examples
APPLY_UNSET Procedure: Definition, Search for examples
AQ$_AGENT Type: Definition, Search for examples
AQ$_AGENT_LIST_T Type: Definition, Search for examples
AQ$_DESCRIPTOR Type: Definition, Search for examples
AQ$_NTFN_DESCRIPTOR Type: Definition, Search for examples
AQ$_NTFN_MSGID_ARRAY Type: Definition, Search for examples
AQ$_POST_INFO Type: Definition, Search for examples
AQ$_POST_INFO_LIST Type: Definition, Search for examples
AQ$_PURGE_OPTIONS_T Type: Definition, Search for examples
AQ$_RECIPIENT_LIST_T Type: Definition, Search for examples
AQ$_REG_INFO Type: Definition, Search for examples
AQ$_REG_INFO_LIST Type: Definition, Search for examples
AQ$_SUBSCRIBER_LIST_T Type: Definition, Search for examples
AQ_QUEUE: Definition, Search for examples
AQ_QUEUE_TABLE: Definition, Search for examples
AQ_TRANSFORM: Definition, Search for examples
ARCHIVELOG Mode: Definition, Search for examples
AREA Function: Definition, Search for examples
AREA Procedure: Definition, Search for examples
ASA_RECO_ROW Record Type: Definition, Search for examples
ASA_RECO_ROW_TB Table Type: Definition, Search for examples
ASA_RECOMMENDATIONS Function: Definition, Search for examples
ASH_GLOBAL_REPORT_HTML Function: Definition, Search for examples
ASH_GLOBAL_REPORT_TEXT Function: Definition, Search for examples
ASH_REPORT_HTML Function: Definition, Search for examples
ASH_REPORT_TEXT Function: Definition, Search for examples
ASSIGN_ACL Procedure: Definition, Search for examples
ASSIGN_ATTRIBUTE_SET Procedure: Definition, Search for examples
ASSIGN_WALLET_ACL Procedure: Definition, Search for examples
ASSIGNED: Definition, Search for examples
ASSM_SEGMENT_VERIFY Procedure: Definition, Search for examples
ASSM_TABLESPACE_VERIFY Procedure: Definition, Search for examples
ASSOCIATE: Definition, Search for examples
ASSOCIATION: Definition, Search for examples
ASSOCIATION: Definition, Search for examples
ATRMAPTYPE: Definition, Search for examples
ATTACH Function: Definition, Search for examples
ATTACH_SESSION Procedure: Definition, Search for examples
ATTACH_SIMPLE_TABLESPACE Procedure: Definition, Search for examples
ATTACH_TABLESPACES Procedure: Definition, Search for examples
ATTRIBUTE: Definition, Search for examples
ATTRIBUTE: Definition, Search for examples
ATTRIBUTE: Definition, Search for examples
ATTRIBUTE_IMPORTANCE: Definition, Search for examples
ATTRIBUTE_NAME: Definition, Search for examples
ATTRIBUTE_NODE: Definition, Search for examples
AUDIT: Definition, Search for examples
AUDIT: Definition, Search for examples
AUDIT_OBJ: Definition, Search for examples
AUDIT_TRAIL_ALL: Definition, Search for examples
AUDIT_TRAIL_AUD_STD: Definition, Search for examples
AUDIT_TRAIL_DB_STD: Definition, Search for examples
AUDIT_TRAIL_FGA_STD: Definition, Search for examples
AUDIT_TRAIL_FILES: Definition, Search for examples
AUDIT_TRAIL_OS: Definition, Search for examples
AUDIT_TRAIL_XML: Definition, Search for examples
AUDIT_TYPE: Definition, Search for examples
AUTHORIZE Function: Definition, Search for examples
AUTHORIZE_DAD Procedure: Definition, Search for examples
AUTO_CASCADE: Definition, Search for examples
AUTO_DEGREE: Definition, Search for examples
AUTO_INVALIDATE: Definition, Search for examples
AUTO_LIMIT: Definition, Search for examples
AUTO_SAMPLE_SIZE: Definition, Search for examples
AUTONOMOUS_TRANSACTION Pragma: Definition, Search for examples
AUTONOMOUS_TRANSACTION Pragma: Definition, Search for examples
AVAILABLE Function: Definition, Search for examples
AVAILABLE: Definition, Search for examples
AVG: Definition, Search for examples
AVG: Definition, Search for examples
AVG: Definition, Search for examples
AVG_FILE_READ_TIME: Definition, Search for examples
AVG_FILE_WRITE_TIME: Definition, Search for examples
AVG_USERS_WAITING: Definition, Search for examples
AW: Definition, Search for examples
AW: Definition, Search for examples
AWNAME: Definition, Search for examples
AWR_BASELINE_METRIC_TYPE Object Type: Definition, Search for examples
AWR_BASELINE_METRIC_TYPE_TABLE Table Type: Definition, Search for examples
AWR_DIFF_REPORT_HTML Function: Definition, Search for examples
AWR_DIFF_REPORT_TEXT Function: Definition, Search for examples
AWR_GLOBAL_DIFF_REPORT_HTML Functions: Definition, Search for examples
AWR_GLOBAL_DIFF_REPORT_TEXT Functions: Definition, Search for examples
AWR_GLOBAL_REPORT_HTML Functions: Definition, Search for examples
AWR_GLOBAL_REPORT_TEXT Functions: Definition, Search for examples
AWR_REPORT_HTML Function: Definition, Search for examples
AWR_REPORT_TEXT Function: Definition, Search for examples
AWR_SET_REPORT_THRESHOLDS Procedure: Definition, Search for examples
AWR_SQL_REPORT_HTML Function: Definition, Search for examples
AWR_SQL_REPORT_TEXT Function: Definition, Search for examples
AWRRPT_INSTANCE_LIST_TYPE Table Type: Definition, Search for examples
AWXML_ID: Definition, Search for examples