Home
Customize
Help
Contact Us
SQL and PL/SQL Syntax and Examples: D
Shortcuts to Items in the List
%
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
DA
DB
DE
DI
DO
DR
DU
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_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_OUTPUT:
Definition
,
Search for examples
DBMS_PCLXUTIL:
Definition
,
Search for examples
DBMS_PIPE:
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:
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:
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
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
Copyright © 2024, Oracle and/or its affiliates. All rights reserved.