Home
Customize
Help
Contact Us
SQL and PL/SQL Syntax and Examples: C
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
CA
CE
CH
CL
CO
CP
CR
CU
Statements, Keywords, Packages, and Functions
CACHE | NOCACHE:
Definition
,
Search for examples
CACHE | NOCACHE | CACHE READS:
Definition
,
Search for examples
CALL:
Definition
,
Search for examples
CALL Procedure:
Definition
,
Search for examples
CANCEL_STATISTICS Procedure:
Definition
,
Search for examples
CASCADE:
Definition
,
Search for examples
CASCADE CONSTRAINTS:
Definition
,
Search for examples
CASE Expressions:
Definition
,
Search for examples
CAST Expressions:
Definition
,
Search for examples
CAST_TO_RAW Function:
Definition
,
Search for examples
CAST_TO_VARCHAR2 Function:
Definition
,
Search for examples
CEIL:
Definition
,
Search for examples
CHANGE:
Definition
,
Search for examples
CHANGE CATEGORY TO new_category_name:
Definition
,
Search for examples
CHANGE Procedure:
Definition
,
Search for examples
CHAR:
Definition
,
Search for examples
CHAR Datatype:
Definition
,
Search for examples
CHARACTER SET character_set:
Definition
,
Search for examples
CHARACTER SET Example:
Definition
,
Search for examples
CHARACTER SET, NATIONAL CHARACTER SET:
Definition
,
Search for examples
CHARTOROWID:
Definition
,
Search for examples
CHECK Constraints:
Definition
,
Search for examples
CHECK DATAFILES:
Definition
,
Search for examples
CHECKPOINT:
Definition
,
Search for examples
CHECK_OBJECT Procedure:
Definition
,
Search for examples
CHR:
Definition
,
Search for examples
CLEAR:
Definition
,
Search for examples
CLEAR_PENDING_AREA Procedure:
Definition
,
Search for examples
CLEAR_PLSQL_TRACE Procedure:
Definition
,
Search for examples
CLOB:
Definition
,
Search for examples
CLOB Datatype:
Definition
,
Search for examples
CLOSE DATABASE LINK:
Definition
,
Search for examples
CLOSE Procedure:
Definition
,
Search for examples
CLOSE Statement:
Definition
,
Search for examples
CLOSE_CURSOR:
Definition
,
Search for examples
CLOSE_CURSOR Procedure:
Definition
,
Search for examples
CLOSE_DATABASE_LINK Procedure:
Definition
,
Search for examples
CLUSTER:
Definition
,
Search for examples
CLUSTER cluster:
Definition
,
Search for examples
COALESCE:
Definition
,
Search for examples
COLUMN:
Definition
,
Search for examples
COLUMN:
Definition
,
Search for examples
COLUMN DEFAULT:
Definition
,
Search for examples
COLUMN_VALUE Procedure:
Definition
,
Search for examples
COLUMN_VALUE_LONG Procedure:
Definition
,
Search for examples
COMMA_TO_TABLE Procedure:
Definition
,
Search for examples
COMMENT:
Definition
,
Search for examples
COMMENT:
Definition
,
Search for examples
COMMENT 'text':
Definition
,
Search for examples
COMMENT Example:
Definition
,
Search for examples
COMMENT_ON_COLUMN_GROUP Procedure:
Definition
,
Search for examples
COMMENT_ON_PRIORITY_GROUP/COMMENT_ON_SITE_PRIORITY Procedures:
Definition
,
Search for examples
COMMENT_ON_REPGROUP Procedure:
Definition
,
Search for examples
COMMENT_ON_REPOBJECT Procedure:
Definition
,
Search for examples
COMMENT_ON_REPSITES Procedure:
Definition
,
Search for examples
COMMENT_ON_SNAPSHOT_REPSITES Procedure:
Definition
,
Search for examples
COMMIT:
Definition
,
Search for examples
COMMIT Procedure:
Definition
,
Search for examples
COMMIT Statement:
Definition
,
Search for examples
COMMIT_COMMENT Procedure:
Definition
,
Search for examples
COMMIT_FORCE Procedure:
Definition
,
Search for examples
COMMIT_WORK Procedure:
Definition
,
Search for examples
COMPARE Function:
Definition
,
Search for examples
COMPARE_OLD_VALUES Procedure:
Definition
,
Search for examples
COMPARE_TEMPLATES Function:
Definition
,
Search for examples
COMPILE:
Definition
,
Search for examples
COMPILE Example:
Definition
,
Search for examples
COMPILE_SCHEMA Procedure:
Definition
,
Search for examples
COMPRESS Example:
Definition
,
Search for examples
COMPUTE:
Definition
,
Search for examples
COMPUTE STATISTICS:
Definition
,
Search for examples
COMPUTE STATISTICS Example:
Definition
,
Search for examples
CONCAT:
Definition
,
Search for examples
CONCAT Function:
Definition
,
Search for examples
CONNECT:
Definition
,
Search for examples
CONNECT TO:
Definition
,
Search for examples
CONNECT_TIME:
Definition
,
Search for examples
CONSIDER FRESH:
Definition
,
Search for examples
CONSIDER FRESH Example:
Definition
,
Search for examples
CONSTANT:
Definition
,
Search for examples
CONSTRAINT:
Definition
,
Search for examples
CONTINUE Function:
Definition
,
Search for examples
CONTROLFILE REUSE:
Definition
,
Search for examples
CONTROL_FILE_RECORD_KEEP_TIME = integer:
Definition
,
Search for examples
CONVERT:
Definition
,
Search for examples
CONVERT Function:
Definition
,
Search for examples
CONVERT_RAW_VALUE Procedure:
Definition
,
Search for examples
COPIES Function:
Definition
,
Search for examples
COPY:
Definition
,
Search for examples
COPY Procedure:
Definition
,
Search for examples
COPY_CLASS Procedure:
Definition
,
Search for examples
COPY_INST Procedure:
Definition
,
Search for examples
COPY_TEMPLATE Function:
Definition
,
Search for examples
CORE_DUMP_DEST = 'text':
Definition
,
Search for examples
CORR:
Definition
,
Search for examples
COS:
Definition
,
Search for examples
COSH:
Definition
,
Search for examples
COUNT:
Definition
,
Search for examples
COUNT:
Definition
,
Search for examples
COVAR_POP:
Definition
,
Search for examples
COVAR_SAMP:
Definition
,
Search for examples
CPU_PER_SESSION:
Definition
,
Search for examples
CREATE:
Definition
,
Search for examples
CREATE CLUSTER:
Definition
,
Search for examples
CREATE CONTEXT:
Definition
,
Search for examples
CREATE CONTEXT Example:
Definition
,
Search for examples
CREATE CONTROLFILE:
Definition
,
Search for examples
CREATE CONTROLFILE Example:
Definition
,
Search for examples
CREATE DATABASE:
Definition
,
Search for examples
CREATE DATABASE Example:
Definition
,
Search for examples
CREATE DATABASE LINK:
Definition
,
Search for examples
CREATE DIMENSION:
Definition
,
Search for examples
CREATE DIMENSION Example:
Definition
,
Search for examples
CREATE DIRECTORY:
Definition
,
Search for examples
CREATE DIRECTORY Example:
Definition
,
Search for examples
CREATE FUNCTION:
Definition
,
Search for examples
CREATE FUNCTION Examples:
Definition
,
Search for examples
CREATE INDEX:
Definition
,
Search for examples
CREATE INDEXTYPE:
Definition
,
Search for examples
CREATE INDEXTYPE Example:
Definition
,
Search for examples
CREATE JAVA:
Definition
,
Search for examples
CREATE LIBRARY:
Definition
,
Search for examples
CREATE LIBRARY Examples:
Definition
,
Search for examples
CREATE MATERIALIZED VIEW:
Definition
,
Search for examples
CREATE MATERIALIZED VIEW LOG:
Definition
,
Search for examples
CREATE OPERATOR:
Definition
,
Search for examples
CREATE OPERATOR Example:
Definition
,
Search for examples
CREATE OUTLINE:
Definition
,
Search for examples
CREATE OUTLINE Example:
Definition
,
Search for examples
CREATE PACKAGE:
Definition
,
Search for examples
CREATE PACKAGE BODY:
Definition
,
Search for examples
CREATE PACKAGE BODY Example:
Definition
,
Search for examples
CREATE PACKAGE Example:
Definition
,
Search for examples
CREATE PROCEDURE:
Definition
,
Search for examples
CREATE PROCEDURE Example:
Definition
,
Search for examples
CREATE PROFILE:
Definition
,
Search for examples
CREATE PROFILE Example:
Definition
,
Search for examples
CREATE ROLE:
Definition
,
Search for examples
CREATE ROLE Example:
Definition
,
Search for examples
CREATE ROLLBACK SEGMENT:
Definition
,
Search for examples
CREATE ROLLBACK SEGMENT Example:
Definition
,
Search for examples
CREATE SCHEMA:
Definition
,
Search for examples
CREATE SCHEMA Example:
Definition
,
Search for examples
CREATE SEQUENCE:
Definition
,
Search for examples
CREATE SEQUENCE Example:
Definition
,
Search for examples
CREATE SYNONYM:
Definition
,
Search for examples
CREATE SYNONYM Examples:
Definition
,
Search for examples
CREATE TABLE:
Definition
,
Search for examples
CREATE TABLESPACE:
Definition
,
Search for examples
CREATE TEMPORARY TABLESPACE:
Definition
,
Search for examples
CREATE TRIGGER:
Definition
,
Search for examples
CREATE TYPE:
Definition
,
Search for examples
CREATE TYPE BODY:
Definition
,
Search for examples
CREATE USER:
Definition
,
Search for examples
CREATE VIEW:
Definition
,
Search for examples
CREATETEMPORARY Procedure:
Definition
,
Search for examples
CREATE_BASE_CAPS Procedure:
Definition
,
Search for examples
CREATE_BASE_DD Procedure:
Definition
,
Search for examples
CREATE_CLASS_CAPS Procedure:
Definition
,
Search for examples
CREATE_CLASS_DD Procedure:
Definition
,
Search for examples
CREATE_CLASS_INIT Procedure:
Definition
,
Search for examples
CREATE_CONSUMER_GROUP Procedure:
Definition
,
Search for examples
CREATE_FDS_CLASS Procedure:
Definition
,
Search for examples
CREATE_FDS_INST Procedure:
Definition
,
Search for examples
CREATE_INST_CAPS Procedure:
Definition
,
Search for examples
CREATE_INST_DD Procedure:
Definition
,
Search for examples
CREATE_INST_INIT Procedure:
Definition
,
Search for examples
CREATE_MASTER_REPGROUP Procedure:
Definition
,
Search for examples
CREATE_MASTER_REPOBJECT Procedure:
Definition
,
Search for examples
CREATE_NP_QUEUE Procedure:
Definition
,
Search for examples
CREATE_OBJECT_FROM_EXISTING Function:
Definition
,
Search for examples
CREATE_PENDING_AREA Procedure:
Definition
,
Search for examples
CREATE_PIPE Function:
Definition
,
Search for examples
CREATE_PLAN Procedure:
Definition
,
Search for examples
CREATE_PLAN_DIRECTIVE Procedure:
Definition
,
Search for examples
CREATE_QUEUE Procedure:
Definition
,
Search for examples
CREATE_QUEUE_TABLE Procedure:
Definition
,
Search for examples
CREATE_REFRESH_TEMPLATE Function:
Definition
,
Search for examples
CREATE_SNAPSHOT_REPGROUP Procedure:
Definition
,
Search for examples
CREATE_SNAPSHOT_REPOBJECT Procedure:
Definition
,
Search for examples
CREATE_STAT_TABLE Procedure:
Definition
,
Search for examples
CREATE_TEMPLATE_OBJECT Function:
Definition
,
Search for examples
CREATE_TEMPLATE_PARM Function:
Definition
,
Search for examples
CREATE_USER_AUTHORIZATION Function:
Definition
,
Search for examples
CREATE_USER_PARM_VALUE Function:
Definition
,
Search for examples
CRLF:
Definition
,
Search for examples
CUBE Example:
Definition
,
Search for examples
CUME_DIST:
Definition
,
Search for examples
CURRENT_INSTANCE Function:
Definition
,
Search for examples
CURRENT_SCHEMA = schema:
Definition
,
Search for examples
CURRENT_USER Example:
Definition
,
Search for examples
CURSOR Expressions:
Definition
,
Search for examples
Copyright © 2024, Oracle and/or its affiliates. All rights reserved.