Home
Home
Customize
Customize
Help
Help
Contact us
Contact Us

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

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

DATABASE_TRACE_DISABLE Procedure: Definition
DATABASE_TRACE_ENABLE Procedure: Definition
DATA_BLOCK_ADDRESS_BLOCK Function: Definition
DATA_BLOCK_ADDRESS_FILE Function: Definition
DATA_FILTER Procedures: Definition
DATE Datatype: Definition
DATE Datatype: Definition
DATE Values: Definition
DATE_TABLE: Definition
DBMS_ADVANCED_REWRITE: Definition
DBMS_ADVISOR: Definition
DBMS_ALERT: Definition
DBMS_APPLICATION_INFO: Definition
DBMS_APPLY_ADM: Definition
DBMS_AQ: Definition
DBMS_AQADM: Definition
DBMS_AQELM: Definition
DBMS_AQIN: Definition
DBMS_CAPTURE_ADM: Definition
DBMS_CDC_PUBLISH: Definition
DBMS_CDC_SUBSCRIBE: Definition
DBMS_CHANGE_NOTIFICATION: Definition
DBMS_CRYPTO: Definition
DBMS_DATAPUMP: Definition
DBMS_DATA_MINING: Definition
DBMS_DATA_MINING_TRANSFORM: Definition
DBMS_DB_VERSION: Definition
DBMS_DDL: Definition
DBMS_DEBUG: Definition
DBMS_DEFER: Definition
DBMS_DEFER_QUERY: Definition
DBMS_DEFER_SYS: Definition
DBMS_DESCRIBE: Definition
DBMS_DIMENSION: Definition
DBMS_DISTRIBUTED_TRUST_ADMIN: Definition
DBMS_EPG: Definition
DBMS_ERRLOG: Definition
DBMS_EXPFIL: Definition
DBMS_FGA: Definition
DBMS_FILE_GROUP: Definition
DBMS_FILE_TRANSFER: Definition
DBMS_FLASHBACK: Definition
DBMS_FREQUENT_ITEMSET: Definition
DBMS_HS_PASSTHROUGH: Definition
DBMS_IOT: Definition
DBMS_JAVA: Definition
DBMS_JOB: Definition
DBMS_LDAP: Definition
DBMS_LDAP_UTL: Definition
DBMS_LIBCACHE: Definition
DBMS_LOB: Definition
DBMS_LOCK: Definition
DBMS_LOGMNR: Definition
DBMS_LOGMNR_D: Definition
DBMS_LOGSTDBY: Definition
DBMS_METADATA: Definition
DBMS_MGWADM: Definition
DBMS_MGWMSG: Definition
DBMS_MONITOR: Definition
DBMS_MVIEW: Definition
DBMS_OBFUSCATION_TOOLKIT: Definition
DBMS_ODCI: Definition
DBMS_OFFLINE_OG: Definition
DBMS_OLAP: Definition
DBMS_OUTLN: Definition
DBMS_OUTLN_EDIT: Definition
DBMS_OUTPUT: Definition
DBMS_PCLXUTIL: Definition
DBMS_PIPE: Definition
DBMS_PREDICTIVE_ANALYTICS: Definition
DBMS_PREPROCESSOR: Definition
DBMS_PROFILER: Definition
DBMS_PROPAGATION_ADM: Definition
DBMS_RANDOM: Definition
DBMS_RECTIFIER_DIFF: Definition
DBMS_REDEFINITION: Definition
DBMS_REFRESH: Definition
DBMS_REPAIR: Definition
DBMS_REPCAT: Definition
DBMS_REPCAT_ADMIN: Definition
DBMS_REPCAT_INSTANTIATE: Definition
DBMS_REPCAT_RGT: Definition
DBMS_REPUTIL: Definition
DBMS_RESOURCE_MANAGER: Definition
DBMS_RESOURCE_MANAGER_PRIVS: Definition
DBMS_RESUMABLE: Definition
DBMS_RLMGR: Definition
DBMS_RLS: Definition
DBMS_ROWID: Definition
DBMS_RULE: Definition
DBMS_RULE_ADM: Definition
DBMS_SCHEDULER: Definition
DBMS_SERVER_ALERT: Definition
DBMS_SERVICE: Definition
DBMS_SESSION: Definition
DBMS_SHARED_POOL: Definition
DBMS_SPACE: Definition
DBMS_SPACE_ADMIN: Definition
DBMS_SQL: Definition
DBMS_SQLTUNE: Definition
DBMS_STATS: Definition
DBMS_STAT_FUNCS: Definition
DBMS_STORAGE_MAP: Definition
DBMS_STREAMS: Definition
DBMS_STREAMS_ADM: Definition
DBMS_STREAMS_AUTH: Definition
DBMS_STREAMS_MESSAGING: Definition
DBMS_STREAMS_TABLESPACE_ADM: Definition
DBMS_TDB: Definition
DBMS_TRACE: Definition
DBMS_TRANSACTION: Definition
DBMS_TRANSFORM: Definition
DBMS_TTS: Definition
DBMS_TYPES: Definition
DBMS_UTILITY: Definition
DBMS_WARNING: Definition
DBMS_WM: Definition
DBMS_WORKLOAD_CAPTURE: Definition
DBMS_WORKLOAD_REPOSITORY: Definition
DBMS_XDB: Definition
DBMS_XDBT: Definition
DBMS_XDBZ: Definition
DBMS_XDB_VERSION: Definition
DBMS_XMLDOM: Definition
DBMS_XMLGEN: Definition
DBMS_XMLPARSER: Definition
DBMS_XMLQUERY: Definition
DBMS_XMLSAVE: Definition
DBMS_XMLSCHEMA: Definition
DBMS_XMLSTORE: Definition
DBMS_XPLAN: Definition
DBMS_XSLPROCESSOR: Definition
DBTIMEZONE: Definition
DBURITYPE: Definition
DB_CONNECT_INFO Procedure: Definition
DB_VERSION Procedure: Definition
DEAUTHORIZE_DAD Procedure: Definition
DEBUG_EXTPROC: Definition
DEBUG_OFF Procedure: Definition
DEBUG_ON Procedure: Definition
DECLARE_REWRITE_EQUIVALENCE Procedures: Definition
DECODE: Definition
DECOMPOSE: Definition
DECRYPT Function: Definition
DECRYPT Procedures: Definition
DEFAULT_INDEX_PARAMETERS Procedure: Definition
DEFAULT_XPINDEX_PARAMETERS Procedure: Definition
DEFINE: Definition
DEFINE_ANYDATA_ARGUMENT Procedure: Definition
DEFINE_ARRAY Procedure: Definition
DEFINE_CHAIN_EVENT_STEP Procedure: Definition
DEFINE_CHAIN_RULE Procedure: Definition
DEFINE_CHAIN_STEP Procedure: Definition
DEFINE_COLUMN Procedure: Definition
DEFINE_COLUMN_LONG Procedure: Definition
DEFINE_METADATA_ARGUMENT Procedure: Definition
DEFINE_PROGRAM_ARGUMENT Procedures: Definition
DEFRAG_INDEX Procedure: Definition
DEL: Definition
DELETE: Definition
DELETE Statement: Definition
DELETEDATA Procedure: Definition
DELETERESOURCE Procedure: Definition
DELETERESOURCEMETADATA Procedures: Definition
DELETESCHEMA Procedure: Definition
DELETEXML: Definition
DELETEXML: Definition
DELETE_ALL_ERRORS Procedure: Definition
DELETE_BREAKPOINT Function: Definition
DELETE_CAPTURE_INFO Procedure: Definition
DELETE_COLUMN Procedure: Definition
DELETE_COLUMN_STATS Procedure: Definition
DELETE_CONSUMER_GROUP Procedure: Definition
DELETE_DAD_ATTRIBUTE Procedure: Definition
DELETE_DATABASE_STATS Procedure: Definition
DELETE_DICTIONARY_STATS Procedure: Definition
DELETE_ERROR Procedure: Definition
DELETE_FILTER Procedure: Definition
DELETE_FIXED_OBJECTS_STATS Procedure: Definition
DELETE_GLOBAL_ATTRIBUTE Procedure: Definition
DELETE_INDEX_STATS Procedure: Definition
DELETE_OBJECT Procedure: Definition
DELETE_OER_BREAKPOINT Function: Definition
DELETE_PLAN Procedure: Definition
DELETE_PLAN_CASCADE Procedure: Definition
DELETE_PLAN_DIRECTIVE Procedure: Definition
DELETE_POLICY_GROUP Procedure: Definition
DELETE_RULE Procedure: Definition
DELETE_SCHEMA_STATS Procedure: Definition
DELETE_SERVICE Procedure: Definition
DELETE_SQLSET Procedure: Definition
DELETE_SQLWKLD Procedure: Definition
DELETE_SQLWKLD_REF Procedure: Definition
DELETE_SQLWKLD_STATEMENT Procedure: Definition
DELETE_SYSTEM_STATS Procedure: Definition
DELETE_TABLE_STATS Procedure: Definition
DELETE_TASK Procedure: Definition
DEL_ALIAS_FROM_LDAP Procedure: Definition
DENSE_RANK: Definition
DENY_ALL Procedure: Definition
DENY_SERVER Procedure: Definition
DEPTH: Definition
DEQUEUE Procedure: Definition
DEQUEUE_ARRAY Function: Definition
DEQUEUE_OPTIONS_T Type: Definition
DEREF: Definition
DEREGISTER Procedure: Definition
DESCRIBE: Definition
DESCRIBE_COLUMNS Procedure: Definition
DESCRIBE_COLUMNS2 Procedure: Definition
DESCRIBE_DIMENSION Procedure: Definition
DESCRIBE_PROCEDURE Procedure: Definition
DESC_REC, DESC_TAB: Definition
DETACH Procedure: Definition
DETACH_SESSION Procedure: Definition
DETACH_SIMPLE_TABLESPACE Procedure: Definition
DETACH_TABLESPACES Procedure: Definition
DFN Function: Definition
DFN Procedure: Definition
DIRECTORY_OBJECT_SET Type: Definition
DIRLISTCLOSE Function: Definition
DIRLISTCLOSE Procedure: Definition
DIRLISTOPEN Function: Definition
DIRLISTOPEN Procedure: Definition
DISABLE Procedure: Definition
DISABLE_BREAKPOINT Function: Definition
DISABLE_DB_ACCESS Procedure: Definition
DISABLE_GROUPED_POLICY Procedure: Definition
DISABLE_HIERARCHY Procedure: Definition
DISABLE_POLICY Procedure: Definition
DISABLE_PROPAGATION_SCHEDULE Procedure: Definition
DISASSOCIATE STATISTICS: Definition
DISCONNECT: Definition
DISCONNECT_SESSION Procedure: Definition
DISPLAY Function: Definition
DISPLAY_AWR Function: Definition
DISPLAY_CURSOR Function: Definition
DISPLAY_SQLSET Function: Definition
DIV Function: Definition
DIV Procedure: Definition
DLISTCLOSE Function: Definition
DLISTCLOSE Procedure: Definition
DLISTDEF Function: Definition
DLISTDEF Procedure: Definition
DLISTOPEN Function: Definition
DLISTOPEN Procedure: Definition
DLISTTERM Function: Definition
DLISTTERM Procedure: Definition
DOC[UMENT] (obsolete): Definition
DOWNGRADE Procedure: Definition
DOWNLOAD_FILE Procedures: Definition
DRIVING_SITE Hint: Definition
DROP CLUSTER: Definition
DROP CONTEXT: Definition
DROP DATABASE: Definition
DROP DATABASE LINK: Definition
DROP DIMENSION: Definition
DROP DIRECTORY: Definition
DROP DISKGROUP: Definition
DROP FUNCTION: Definition
DROP INDEX: Definition
DROP INDEXTYPE: Definition
DROP JAVA: Definition
DROP LIBRARY: Definition
DROP MATERIALIZED VIEW: Definition
DROP MATERIALIZED VIEW LOG: Definition
DROP OPERATOR: Definition
DROP OUTLINE: Definition
DROP PACKAGE: Definition
DROP PROCEDURE: Definition
DROP PROFILE: Definition
DROP RESTORE POINT: Definition
DROP ROLE: Definition
DROP ROLLBACK SEGMENT: Definition
DROP SEQUENCE: Definition
DROP SYNONYM: Definition
DROP TABLE: Definition
DROP TABLESPACE: Definition
DROP TRIGGER: Definition
DROP TYPE: Definition
DROP TYPE BODY: Definition
DROP USER: Definition
DROP VIEW: Definition
DROPPREFERENCES Procedure: Definition
DROP_ALL Function: Definition
DROP_APPLY Procedure: Definition
DROP_AQ_AGENT Procedure: Definition
DROP_ATTRIBUTE_SET Procedure: Definition
DROP_BASELINE Procedure: Definition
DROP_BY_CAT Procedure: Definition
DROP_CAPTURE Procedure: Definition
DROP_CHAIN Procedure: Definition
DROP_CHAIN_RULE Procedure: Definition
DROP_CHAIN_STEP Procedure: Definition
DROP_CHANGE_SET Procedure: Definition
DROP_CHANGE_SOURCE Procedure: Definition
DROP_CHANGE_TABLE Procedure: Definition
DROP_DAD Procedure: Definition
DROP_EDIT_TABLES Procedure: Definition
DROP_ELEMENT Function: Definition
DROP_EVALUATION_CONTEXT Procedure: Definition
DROP_EVENT_STRUCTURE Procedure: Definition
DROP_FILE Function: Definition
DROP_FILE_GROUP Procedure: Definition
DROP_GROUPED_POLICY Procedure: Definition
DROP_JOB Procedure: Definition
DROP_JOB_CLASS Procedure: Definition
DROP_MODEL Procedure: Definition
DROP_OBJECT_DEPENDENCY: Definition
DROP_POLICY Procedure: Definition
DROP_POLICY_CONTEXT Procedure: Definition
DROP_PROGRAM Procedure: Definition
DROP_PROGRAM_ARGUMENT Procedures: Definition
DROP_PROPAGATION Procedure: Definition
DROP_QUEUE Procedure: Definition
DROP_QUEUE_TABLE Procedure: Definition
DROP_REWRITE_EQUIVALENCE Procedure: Definition
DROP_RULE Procedure: Definition
DROP_RULE_CLASS Procedure: Definition
DROP_RULE_SET Procedure: Definition
DROP_SCHEDULE Procedure: Definition
DROP_SNAPSHOT_RANGE Procedure: Definition
DROP_SQLSET Procedure: Definition
DROP_SQL_PROFILE Procedure: Definition
DROP_STAT_TABLE Procedure: Definition
DROP_SUBSCRIPTION Procedure: Definition
DROP_TRANSFORMATION Procedure: Definition
DROP_TUNING_TASK Procedure: Definition
DROP_UNUSED Procedure: Definition
DROP_VERSION Procedure: Definition
DROP_WINDOW Procedure: Definition
DROP_WINDOW_GROUP Procedure: Definition
DUMP: Definition
DUMP_ORPHAN_KEYS Procedure: Definition
DYNAMIC_SAMPLING Hint: Definition
JDBC Demonstrations: Definition