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

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
ACCESSED GLOBALLY: Definition
ACCOUNT Clause: Definition
ACLCHECKPRIVILEGES Function: Definition
ACOS: Definition
ACTIVATE_SUBSCRIPTION Procedure: Definition
ACTIVE_INSTANCES Procedure: Definition
ADD: Definition
ADD Clause: Definition
ADD | DROP: 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_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 Clause: Definition
ADVISE_COMMIT Procedure: Definition
ADVISE_NOTHING Procedure: Definition
ADVISE_ROLLBACK Procedure: Definition
AFTER: Definition
AGENT Clause: Definition
AGGREGATE USING Clause: Definition
ALL: Definition
ALL Clause: Definition
ALL into_clause: Definition
ALL TRIGGERS: Definition
ALL [PRIVILEGES]: Definition
ALLOCATE_UNIQUE Procedure: Definition
ALLOW ... CORRUPTION: 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
ANCILLARY TO Clause: Definition
AND DATAFILES: 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: Definition
ARCHIVELOG Mode: Definition
ARCHIVELOG | NOARCHIVELOG: Definition
AREA Function: Definition
AREA Procedure: Definition
AS OBJECT Clause: Definition
AS source_char: Definition
AS subquery: Definition
ASA_RECOMMENDATIONS Function: Definition
ASC | DESC: 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
AUTHID Clause: Definition
AUTHID CURRENT_USER: Definition
AUTHID DEFINER: Definition
AUTHORIZE Function: Definition
AUTHORIZE_DAD Procedure: Definition
AUTOMATIC: 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