Home

Help

Feedback

SQL and PL/SQL Syntax and Examples: D

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

DATABASE Clause: Definition , Search for examples

DATAFILE 'filename': Definition , Search for examples

DATAFILE Clause: Definition , Search for examples

DATAFILE datafile_tempfile_spec: Definition , Search for examples

DATA_BLOCK_ADDRESS_BLOCK Function: Definition , Search for examples

DATA_BLOCK_ADDRESS_FILE Function: Definition , Search for examples

DATE: Definition , Search for examples

DATE Datatype: Definition , Search for examples

DATE Values: Definition , Search for examples

DBA_XML_SCHEMAS: Definition , Search for examples

DBA_XML_TABLES: Definition , Search for examples

DBA_XML_TAB_COLS: Definition , Search for examples

DBA_XML_VIEWS: Definition , Search for examples

DBA_XML_VIEW_COLS: Definition , Search for examples

DBLINK_ENCRYPT_LOGIN: Definition , Search for examples

DBMS_ALERT: Definition , Search for examples

DBMS_APPLICATION_INFO: Definition , Search for examples

DBMS_APPLY_ADM: Definition , Search for examples

DBMS_AQ: Definition , Search for examples

DBMS_AQADM: Definition , Search for examples

DBMS_AQELM: Definition , Search for examples

DBMS_CAPTURE_ADM: Definition , Search for examples

DBMS_DDL: Definition , Search for examples

DBMS_DEBUG: Definition , Search for examples

DBMS_DEFER: Definition , Search for examples

DBMS_DEFER_QUERY: Definition , Search for examples

DBMS_DEFER_SYS: Definition , Search for examples

DBMS_DESCRIBE: Definition , Search for examples

DBMS_DISTRIBUTED_TRUST_ADMIN: Definition , Search for examples

DBMS_FGA: Definition , Search for examples

DBMS_FLASHBACK: Definition , Search for examples

DBMS_HS_PASSTHROUGH: Definition , Search for examples

DBMS_IOT: Definition , Search for examples

DBMS_JOB: Definition , Search for examples

DBMS_JOB.CHANGE: Definition , Search for examples

DBMS_JOB.INSTANCE: Definition , Search for examples

DBMS_JOB.RUN: Definition , Search for examples

DBMS_JOB.SUBMIT: Definition , Search for examples

DBMS_LDAP: Definition , Search for examples

DBMS_LIBCACHE: Definition , Search for examples

DBMS_LOB: Definition , Search for examples

DBMS_LOCK: Definition , Search for examples

DBMS_LOGMNR: Definition , Search for examples

DBMS_LOGMNR Constants: Definition , Search for examples

DBMS_LOGMNR_CDC_PUBLISH: Definition , Search for examples

DBMS_LOGMNR_CDC_SUBSCRIBE: Definition , Search for examples

DBMS_LOGMNR_D: Definition , Search for examples

DBMS_LOGSTDBY: Definition , Search for examples

DBMS_METADATA: Definition , Search for examples

DBMS_MGWADM: Definition , Search for examples

DBMS_MGWADM Constants: Definition , Search for examples

DBMS_MGWMSG: Definition , Search for examples

DBMS_MGWMSG Constants: Definition , Search for examples

DBMS_MVIEW: Definition , Search for examples

DBMS_OBFUSCATION_TOOLKIT: Definition , Search for examples

DBMS_ODCI: Definition , Search for examples

DBMS_OFFLINE_OG: Definition , Search for examples

DBMS_OFFLINE_SNAPSHOT: Definition , Search for examples

DBMS_OLAP: Definition , Search for examples

DBMS_ORACLE_TRACE_AGENT: Definition , Search for examples

DBMS_ORACLE_TRACE_USER: Definition , Search for examples

DBMS_OUTLN: Definition , Search for examples

DBMS_OUTLN_EDIT: Definition , Search for examples

DBMS_OUTPUT: Definition , Search for examples

DBMS_PCLXUTIL: Definition , Search for examples

DBMS_PIPE: Definition , Search for examples

DBMS_PROFILER: Definition , Search for examples

DBMS_PROPAGATION_ADM: Definition , Search for examples

DBMS_RANDOM: Definition , Search for examples

DBMS_RECTIFIER_DIFF: Definition , Search for examples

DBMS_REDEFINITION: Definition , Search for examples

DBMS_REFRESH: Definition , Search for examples

DBMS_REPAIR: Definition , Search for examples

DBMS_REPCAT: Definition , Search for examples

DBMS_REPCAT_ADMIN: Definition , Search for examples

DBMS_REPCAT_INSTANTIATE: Definition , Search for examples

DBMS_REPCAT_RGT: Definition , Search for examples

DBMS_REPUTIL: Definition , Search for examples

DBMS_RESOURCE_MANAGER: Definition , Search for examples

DBMS_RESOURCE_MANAGER_PRIVS: Definition , Search for examples

DBMS_RESUMABLE: Definition , Search for examples

DBMS_RLS: Definition , Search for examples

DBMS_ROWID: Definition , Search for examples

DBMS_RULE: Definition , Search for examples

DBMS_RULE_ADM: Definition , Search for examples

DBMS_SESSION: Definition , Search for examples

DBMS_SHARED_POOL: Definition , Search for examples

DBMS_SPACE: Definition , Search for examples

DBMS_SPACE_ADMIN: Definition , Search for examples

DBMS_SQL: Definition , Search for examples

DBMS_STATS: Definition , Search for examples

DBMS_STORAGE_MAP: Definition , Search for examples

DBMS_STREAMS: Definition , Search for examples

DBMS_STREAMS_ADM: Definition , Search for examples

DBMS_TRACE: Definition , Search for examples

DBMS_TRANSACTION: Definition , Search for examples

DBMS_TRANSFORM: Definition , Search for examples

DBMS_TTS: Definition , Search for examples

DBMS_TYPES: Definition , Search for examples

DBMS_UTILITY: Definition , Search for examples

DBMS_WM: Definition , Search for examples

DBMS_XDB: Definition , Search for examples

DBMS_XDBT: Definition , Search for examples

DBMS_XDB_VERSION: Definition , Search for examples

DBMS_XMLDOM: Definition , Search for examples

DBMS_XMLGEN: Definition , Search for examples

DBMS_XMLPARSER: Definition , Search for examples

DBMS_XMLQUERY: Definition , Search for examples

DBMS_XMLSAVE: Definition , Search for examples

DBMS_XPLAN: Definition , Search for examples

DBMS_XSLPROCESSOR: Definition , Search for examples

DBTIMEZONE: Definition , Search for examples

DBWR_IO_SLAVES: Definition , Search for examples

DB_BLOCK_BUFFERS: Definition , Search for examples

DB_BLOCK_CHECKING: Definition , Search for examples

DB_BLOCK_CHECKSUM: Definition , Search for examples

DB_BLOCK_SIZE: Definition , Search for examples

DB_CACHE_ADVICE: Definition , Search for examples

DB_CACHE_SIZE: Definition , Search for examples

DB_CONNECT_INFO Procedure: Definition , Search for examples

DB_CREATE_FILE_DEST: Definition , Search for examples

DB_DOMAIN: Definition , Search for examples

DB_FILES: Definition , Search for examples

DB_FILE_MULTIBLOCK_READ_COUNT: Definition , Search for examples

DB_FILE_NAME_CONVERT: Definition , Search for examples

DB_KEEP_CACHE_SIZE: Definition , Search for examples

DB_NAME: Definition , Search for examples

DB_RECYCLE_CACHE_SIZE: Definition , Search for examples

DB_VERSION Procedure: Definition , Search for examples

DB_WRITER_PROCESSES: Definition , Search for examples

DEBUG_EXTPROC: Definition , Search for examples

DEBUG_OFF Procedure: Definition , Search for examples

DEBUG_ON Procedure: Definition , Search for examples

DECLARE: Definition , Search for examples

DECODE: Definition , Search for examples

DECOMPOSE: Definition , Search for examples

DEFAULT: Definition , Search for examples

DEFAULT ROLE Clause: Definition , Search for examples

DEFAULT storage_clause: Definition , Search for examples

DEFAULT TABLESPACE Clause: Definition , Search for examples

DEFERRED: Definition , Search for examples

DEFINE: Definition , Search for examples

DEFINE_ARRAY Procedure: Definition , Search for examples

DEFINE_COLUMN Procedure: Definition , Search for examples

DEFINE_COLUMN_GROUP Procedure: Definition , Search for examples

DEFINE_COLUMN_LONG Procedure: Definition , Search for examples

DEFINE_PRIORITY_GROUP Procedure: Definition , Search for examples

DEFINE_SITE_PRIORITY Procedure: Definition , Search for examples

DEL: Definition , Search for examples

DELETE: Definition , Search for examples

DELETE Statement: Definition , Search for examples

DELETE_ALL_ERRORS Procedure: Definition , Search for examples

DELETE_BREAKPOINT Function: Definition , Search for examples

DELETE_COLUMN_STATS Procedure: Definition , Search for examples

DELETE_CONSUMER_GROUP Procedure: Definition , Search for examples

DELETE_DATABASE_STATS Procedure: Definition , Search for examples

DELETE_DEFAULT_DEST Procedure: Definition , Search for examples

DELETE_DEF_DESTINATION Procedure: Definition , Search for examples

DELETE_ERROR Procedure: Definition , Search for examples

DELETE_INDEX_STATS Procedure: Definition , Search for examples

DELETE_OBJECT Procedure: Definition , Search for examples

DELETE_OER_BREAKPOINT Function: Definition , Search for examples

DELETE_PLAN Procedure: Definition , Search for examples

DELETE_PLAN_CASCADE Procedure: Definition , Search for examples

DELETE_PLAN_DIRECTIVE Procedure: Definition , Search for examples

DELETE_POLICY_GROUP Procedure: Definition , Search for examples

DELETE_RUNTIME_PARMS Procedure: Definition , Search for examples

DELETE_SCHEMA_STATS Procedure: Definition , Search for examples

DELETE_SYSTEM_STATS Procedure: Definition , Search for examples

DELETE_TABLE_STATS Procedure: Definition , Search for examples

DELETE_TRAN Procedure: Definition , Search for examples

DEL_ALIAS_FROM_LDAP Procedure: Definition , Search for examples

DENSE_RANK: Definition , Search for examples

DENY_ALL Procedure: Definition , Search for examples

DENY_SERVER Procedure: Definition , Search for examples

DEPTH: Definition , Search for examples

DEQUEUE Procedure: Definition , Search for examples

DEQUEUE_OPTIONS_T Type: Definition , Search for examples

DEREF: Definition , Search for examples

DESCRIBE: Definition , Search for examples

DESCRIBE_COLUMNS Procedure: Definition , Search for examples

DESCRIBE_PROCEDURE Procedure: Definition , Search for examples

DESTROY Procedure: Definition , Search for examples

DETACH_SESSION Procedure: Definition , Search for examples

DETERMINISTIC: Definition , Search for examples

DETERMINISTIC Clause: Definition , Search for examples

DG_BROKER_START: Definition , Search for examples

DIFFERENCES Procedure: Definition , Search for examples

DISABLE Clause: Definition , Search for examples

DISABLE Procedure: Definition , Search for examples

DISABLED Function: Definition , Search for examples

DISABLE_BREAKPOINT Function: Definition , Search for examples

DISABLE_DB_ACCESS Procedure: Definition , Search for examples

DISABLE_POLICY Procedure: Definition , Search for examples

DISABLE_PROPAGATION_SCHEDULE Procedure: Definition , Search for examples

DISASSOCIATE STATISTICS: Definition , Search for examples

DISCONNECT: Definition , Search for examples

DISK_ASYNCH_IO: Definition , Search for examples

DISPATCHERS: Definition , Search for examples

DISPLAY Function: Definition , Search for examples

DISTINCT | UNIQUE: Definition , Search for examples

DISTRIBUTED RECOVERY Clause: Definition , Search for examples

DISTRIBUTED_LOCK_TIMEOUT: Definition , Search for examples

DML_LOCKS: Definition , Search for examples

DOCUMENT: Definition , Search for examples

DOWNGRADE Procedure: Definition , Search for examples

DO_DEFERRED_REPCAT_ADMIN Procedure: Definition , Search for examples

DROP: Definition , Search for examples

DROP Clause: Definition , Search for examples

DROP CLUSTER: Definition , Search for examples

DROP CONTEXT: Definition , Search for examples

DROP DATABASE LINK: Definition , Search for examples

DROP DIMENSION: Definition , Search for examples

DROP DIRECTORY: Definition , Search for examples

DROP FUNCTION: Definition , Search for examples

DROP INDEX: Definition , Search for examples

DROP INDEXTYPE: Definition , Search for examples

DROP JAVA: Definition , Search for examples

DROP LIBRARY: Definition , Search for examples

DROP MATERIALIZED VIEW: Definition , Search for examples

DROP MATERIALIZED VIEW LOG: Definition , Search for examples

DROP OPERATOR: Definition , Search for examples

DROP OUTLINE: Definition , Search for examples

DROP PACKAGE: Definition , Search for examples

DROP PROCEDURE: Definition , Search for examples

DROP PROFILE: Definition , Search for examples

DROP ROLE: Definition , Search for examples

DROP ROLLBACK SEGMENT: Definition , Search for examples

DROP SEQUENCE: Definition , Search for examples

DROP SYNONYM: Definition , Search for examples

DROP TABLE: Definition , Search for examples

DROP TABLESPACE: Definition , Search for examples

DROP TRIGGER: Definition , Search for examples

DROP TYPE: Definition , Search for examples

DROP TYPE BODY: Definition , Search for examples

DROP USER: Definition , Search for examples

DROP VIEW: Definition , Search for examples

DROP_ALL Function: Definition , Search for examples

DROP_ALL_OBJECTS Procedure: Definition , Search for examples

DROP_ALL_TEMPLATES Procedure: Definition , Search for examples

DROP_ALL_TEMPLATE_PARMS Procedure: Definition , Search for examples

DROP_ALL_TEMPLATE_SITES Procedure: Definition , Search for examples

DROP_ALL_USER_AUTHORIZATIONS Procedure: Definition , Search for examples

DROP_ALL_USER_PARM_VALUES Procedure: Definition , Search for examples

DROP_APPLY Procedure: Definition , Search for examples

DROP_AQ_AGENT Procedure: Definition , Search for examples

DROP_BY_CAT Procedure: Definition , Search for examples

DROP_CAPTURE Procedure: Definition , Search for examples

DROP_CHANGE_TABLE Procedure: Definition , Search for examples

DROP_COLLISION Procedure: Definition , Search for examples

DROP_COLUMN_GROUP Procedure: Definition , Search for examples

DROP_EDIT_TABLES Procedure: Definition , Search for examples

DROP_ELEMENT Function: Definition , Search for examples

DROP_EVALUATION_CONTEXT Procedure: Definition , Search for examples

DROP_EXTRAS Procedure: Definition , Search for examples

DROP_FILE Function: Definition , Search for examples

DROP_GROUPED_COLUMN Procedure: Definition , Search for examples

DROP_GROUPED_POLICY Procedure: Definition , Search for examples

DROP_MASTER_REPGROUP Procedure: Definition , Search for examples

DROP_MASTER_REPOBJECT Procedure: Definition , Search for examples

DROP_MVIEW_REPGROUP Procedure: Definition , Search for examples

DROP_MVIEW_REPOBJECT Procedure: Definition , Search for examples

DROP_POLICY Procedure: Definition , Search for examples

DROP_POLICY_CONTEXT Procedure: Definition , Search for examples

DROP_PRIORITY Procedure: Definition , Search for examples

DROP_PRIORITY_GROUP Procedure: Definition , Search for examples

DROP_PROPAGATION Procedure: Definition , Search for examples

DROP_QUEUE Procedure: Definition , Search for examples

DROP_QUEUE_TABLE Procedure: Definition , Search for examples

DROP_REFRESH_TEMPLATE Procedure: Definition , Search for examples

DROP_RULE Procedure: Definition , Search for examples

DROP_RULE_SET Procedure: Definition , Search for examples

DROP_SITE_INSTANTIATION Procedure: Definition , Search for examples

DROP_SITE_PRIORITY Procedure: Definition , Search for examples

DROP_SITE_PRIORITY_SITE Procedure: Definition , Search for examples

DROP_STAT_TABLE Procedure: Definition , Search for examples

DROP_SUBSCRIBER_VIEW Procedure: Definition , Search for examples

DROP_SUBSCRIPTION Procedure: Definition , Search for examples

DROP_TEMPLATE_OBJECT Procedure: Definition , Search for examples

DROP_TEMPLATE_PARM Procedure: Definition , Search for examples

DROP_TRANSFORMATION Procedure: Definition , Search for examples

DROP_UNREFD_HINTS Procedure: Definition , Search for examples

DROP_UNUSED Procedure: Definition , Search for examples

DROP_USER_AUTHORIZATION Procedure: Definition , Search for examples

DROP_USER_PARM_VALUE Procedure: Definition , Search for examples

DRS_START: Definition , Search for examples

DUMP: Definition , Search for examples

DUMP_ORPHAN_KEYS Procedure: Definition , Search for examples