Home

Help

SQL and PL/SQL Syntax and Examples: D

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

DATABASE database: Definition , Search for examples

DATAFILE filespec: 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

DBMS_ALERT: Definition , Search for examples

DBMS_APPLICATION_INFO: Definition , Search for examples

DBMS_AQ: Definition , Search for examples

DBMS_AQADM: Definition , Search for examples

DBMS_BACKUP_RESTORE: Definition , Search for examples

DBMS_DDL: Definition , Search for examples

DBMS_DEBUG: Definition , Search for examples

DBMS_DEFER: Definition , Search for examples

DBMS_DEFER Package: Definition , Search for examples

DBMS_DEFER_QUERY: Definition , Search for examples

DBMS_DEFER_QUERY Package: Definition , Search for examples

DBMS_DEFER_SYS: Definition , Search for examples

DBMS_DEFER_SYS Package: Definition , Search for examples

DBMS_DESCRIBE: Definition , Search for examples

DBMS_DISTRIBUTED_TRUST_ADMIN: Definition , Search for examples

DBMS_HS: Definition , Search for examples

DBMS_HS_PASSTHROUGH: Definition , Search for examples

DBMS_IOT: Definition , Search for examples

DBMS_JOB: Definition , Search for examples

DBMS_LOB: Definition , Search for examples

DBMS_LOCK: Definition , Search for examples

DBMS_LOGMNR: Definition , Search for examples

DBMS_LOGMNR_D: Definition , Search for examples

DBMS_MVIEW: Definition , Search for examples

DBMS_OBFUSCATION_TOOLKIT: Definition , Search for examples

DBMS_OFFLINE_OG: Definition , Search for examples

DBMS_OFFLINE_OG Package: Definition , Search for examples

DBMS_OFFLINE_SNAPSHOT: Definition , Search for examples

DBMS_OFFLINE_SNAPSHOT Package: 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_OUTPUT: Definition , Search for examples

DBMS_PCLXUTIL: Definition , Search for examples

DBMS_PIPE: Definition , Search for examples

DBMS_PROFILER: Definition , Search for examples

DBMS_RANDOM: Definition , Search for examples

DBMS_RECTIFIER_DIFF: Definition , Search for examples

DBMS_RECTIFIER_DIFF Package: Definition , Search for examples

DBMS_REFRESH: Definition , Search for examples

DBMS_REFRESH Package: Definition , Search for examples

DBMS_REPAIR: Definition , Search for examples

DBMS_REPCAT: Definition , Search for examples

DBMS_REPCAT Package: Definition , Search for examples

DBMS_REPCAT_ADMIN: Definition , Search for examples

DBMS_REPCAT_ADMIN Package: Definition , Search for examples

DBMS_REPCAT_INSTANTIATE: Definition , Search for examples

DBMS_REPCAT_INSTANTIATE Package: Definition , Search for examples

DBMS_REPCAT_RGT: Definition , Search for examples

DBMS_REPCAT_RGT Package: Definition , Search for examples

DBMS_REPUTIL: Definition , Search for examples

DBMS_REPUTIL Package: Definition , Search for examples

DBMS_RESOURCE_MANAGER: Definition , Search for examples

DBMS_RESOURCE_MANAGER_PRIVS: Definition , Search for examples

DBMS_RLS: Definition , Search for examples

DBMS_ROWID: Definition , Search for examples

DBMS_SESSION: Definition , Search for examples

DBMS_SHARED_POOL: Definition , Search for examples

DBMS_SNAPSHOT: Definition , Search for examples

DBMS_SNAPSHOT Package: 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_TRACE: Definition , Search for examples

DBMS_TRANSACTION: Definition , Search for examples

DBMS_TTS: Definition , Search for examples

DBMS_UTILITY: Definition , Search for examples

DB_BLOCK_MAX_DIRTY_TARGET = integer: Definition , Search for examples

DB_FILE_MULTIBLOCK_READ_COUNT = integer: Definition , Search for examples

DB_VERSION Procedure: Definition , Search for examples

DEALLOCATE UNUSED Example: Definition , Search for examples

DEBUG: 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 Expressions: Definition , Search for examples

DEFAULT: Definition , Search for examples

DEFAULT ROLE: Definition , Search for examples

DEFAULT storage_clause: Definition , Search for examples

DEFAULT TABLESPACE: Definition , Search for examples

DEFERRABLE | NOT DEFERRABLE: 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 STATISTICS: 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_PLAN Procedure: Definition , Search for examples

DELETE_PLAN_CASCADE Procedure: Definition , Search for examples

DELETE_PLAN_DIRECTIVE Procedure: Definition , Search for examples

DELETE_RUNTIME_PARMS Procedure: Definition , Search for examples

DELETE_SCHEMA_STATS Procedure: Definition , Search for examples

DELETE_TABLE_STATS Procedure: Definition , Search for examples

DELETE_TRAN 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

DEQUEUE Procedure: 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

DIFFERENCES Procedure: Definition , Search for examples

DISABLE: Definition , Search for examples

DISABLE Example: Definition , Search for examples

DISABLE Procedure: Definition , Search for examples

DISABLE THREAD: Definition , Search for examples

DISABLED Function: Definition , Search for examples

DISABLE_BREAKPOINT Function: Definition , Search for examples

DISABLE_PROPAGATION_SCHEDULE Procedure: Definition , Search for examples

DISASSOCIATE STATISTICS: Definition , Search for examples

DISCONNECT: Definition , Search for examples

DISTINCT | UNIQUE: Definition , Search for examples

DISTRIBUTED RECOVERY: 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 CLUSTER: Definition , Search for examples

DROP CLUSTER Example: Definition , Search for examples

DROP COLUMN Example: Definition , Search for examples

DROP CONTEXT: Definition , Search for examples

DROP CONTEXT Example: Definition , Search for examples

DROP DATABASE LINK: Definition , Search for examples

DROP DIMENSION: Definition , Search for examples

DROP DIMENSION Example: Definition , Search for examples

DROP DIRECTORY: Definition , Search for examples

DROP DIRECTORY Example: Definition , Search for examples

DROP FUNCTION: Definition , Search for examples

DROP FUNCTION Example: Definition , Search for examples

DROP INDEX: Definition , Search for examples

DROP INDEX Example: Definition , Search for examples

DROP INDEXTYPE: Definition , Search for examples

DROP INDEXTYPE Example: Definition , Search for examples

DROP JAVA: Definition , Search for examples

DROP JAVA CLASS Example: Definition , Search for examples

DROP LIBRARY: Definition , Search for examples

DROP LIBRARY Example: Definition , Search for examples

DROP MATERIALIZED VIEW: Definition , Search for examples

DROP MATERIALIZED VIEW Examples: Definition , Search for examples

DROP MATERIALIZED VIEW LOG: Definition , Search for examples

DROP MATERIALIZED VIEW LOG Example: Definition , Search for examples

DROP OPERATOR: Definition , Search for examples

DROP OPERATOR Example: Definition , Search for examples

DROP OUTLINE: Definition , Search for examples

DROP OUTLINE Example: Definition , Search for examples

DROP PACKAGE: Definition , Search for examples

DROP PACKAGE Example: Definition , Search for examples

DROP PROCEDURE: Definition , Search for examples

DROP PROCEDURE Example: Definition , Search for examples

DROP PROFILE: Definition , Search for examples

DROP PROFILE Example: Definition , Search for examples

DROP ROLE: Definition , Search for examples

DROP ROLE Example: Definition , Search for examples

DROP ROLLBACK SEGMENT: Definition , Search for examples

DROP ROLLBACK SEGMENT Example: Definition , Search for examples

DROP SEQUENCE: Definition , Search for examples

DROP SEQUENCE Example: Definition , Search for examples

DROP SYNONYM: Definition , Search for examples

DROP SYNONYM Example: Definition , Search for examples

DROP TABLE: Definition , Search for examples

DROP TABLE Example: Definition , Search for examples

DROP TABLESPACE: Definition , Search for examples

DROP TABLESPACE Example: Definition , Search for examples

DROP TRIGGER: Definition , Search for examples

DROP TRIGGER Example: Definition , Search for examples

DROP TYPE: Definition , Search for examples

DROP TYPE BODY: Definition , Search for examples

DROP TYPE BODY Example: Definition , Search for examples

DROP TYPE Example: Definition , Search for examples

DROP USER: Definition , Search for examples

DROP USER Example: Definition , Search for examples

DROP VIEW: Definition , Search for examples

DROP VIEW Example: 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_BASE_CAPS Procedure: Definition , Search for examples

DROP_BASE_DD Procedure: Definition , Search for examples

DROP_BY_CAT Procedure: Definition , Search for examples

DROP_CLASS_CAPS Procedure: Definition , Search for examples

DROP_CLASS_DD Procedure: Definition , Search for examples

DROP_CLASS_INIT Procedure: Definition , Search for examples

DROP_COLUMN_GROUP Procedure: Definition , Search for examples

DROP_FDS_CLASS Procedure: Definition , Search for examples

DROP_FDS_INST Procedure: Definition , Search for examples

DROP_GROUPED_COLUMN Procedure: Definition , Search for examples

DROP_INST_CAPS Procedure: Definition , Search for examples

DROP_INST_DD Procedure: Definition , Search for examples

DROP_INST_INIT Procedure: Definition , Search for examples

DROP_MASTER_REPGROUP Procedure: Definition , Search for examples

DROP_MASTER_REPOBJECT Procedure: Definition , Search for examples

DROP_POLICY Procedure: Definition , Search for examples

DROP_PRIORITY Procedure: Definition , Search for examples

DROP_PRIORITY_GROUP 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_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_SNAPSHOT_REPGROUP Procedure: Definition , Search for examples

DROP_SNAPSHOT_REPOBJECT Procedure: Definition , Search for examples

DROP_STAT_TABLE Procedure: Definition , Search for examples

DROP_TEMPLATE_OBJECT Procedure: Definition , Search for examples

DROP_TEMPLATE_PARM 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

DUMP: Definition , Search for examples

DUMP_ORPHAN_KEYS Procedure: Definition , Search for examples