Home

Help

Feedback

SQL and PL/SQL Syntax and Examples: C

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

CACHE | NOCACHE: Definition , Search for examples

CACHE | NOCACHE Clause: Definition , Search for examples

CALL: Definition , Search for examples

CALL Procedure: Definition , Search for examples

CANCEL_STATISTICS Procedure: Definition , Search for examples

CAN_REDEF_TABLE Procedure: Definition , Search for examples

CASCADE: Definition , Search for examples

CASCADE CONSTRAINTS: Definition , Search for examples

CASE Expressions: Definition , Search for examples

CASE Statement: Definition , Search for examples

CAST: Definition , Search for examples

CAST_FROM_BINARY_INTEGER Function: Definition , Search for examples

CAST_FROM_NUMBER Function: Definition , Search for examples

CAST_TO_BINARY_INTEGER Function: Definition , Search for examples

CAST_TO_NUMBER Function: 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 Clause: Definition , Search for examples

CHANGE Procedure: Definition , Search for examples

CHANGE_JOIN_POS Procedure: Definition , Search for examples

CHAR: Definition , Search for examples

CHAR Datatype: Definition , Search for examples

CHARACTER SET Clause: Definition , Search for examples

CHARTOROWID: Definition , Search for examples

CHECK DATAFILES Clause: Definition , Search for examples

CHECKPOINT Clause: Definition , Search for examples

CHECK_OBJECT Procedure: Definition , Search for examples

CHR: Definition , Search for examples

CIRCUITS: Definition , Search for examples

CLEANUP_GATEWAY Procedure: Definition , Search for examples

CLEAR: Definition , Search for examples

CLEAR_CONTEXT: Definition , Search for examples

CLEAR_COOKIES Procedure: Definition , Search for examples

CLEAR_IDENTIFIER: Definition , Search for examples

CLEAR_PENDING_AREA Procedure: Definition , Search for examples

CLEAR_PLSQL_TRACE Procedure: Definition , Search for examples

CLEAR_PROP_STATISTICS Procedure: Definition , Search for examples

CLOB: Definition , Search for examples

CLOB Datatype: Definition , Search for examples

CLOSE DATABASE LINK Clause: 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

CLOSE_PERSISTENT_CONN Procedure: Definition , Search for examples

CLOSE_PERSISTENT_CONNS Procedure: Definition , Search for examples

CLUSTER Clause: Definition , Search for examples

CLUSTER cluster: Definition , Search for examples

CLUSTER_DATABASE: Definition , Search for examples

CLUSTER_DATABASE_INSTANCES: Definition , Search for examples

CLUSTER_INTERCONNECTS: Definition , Search for examples

COALESCE: Definition , Search for examples

COALESCE Clause: Definition , Search for examples

COLUMN: Definition , Search for examples

COLUMN Clause: Definition , Search for examples

COLUMN DEFAULT: Definition , Search for examples

COLUMN_PRESENT Function: 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 Clause: Definition , Search for examples

COMMENT_ON_COLUMN_GROUP Procedure: Definition , Search for examples

COMMENT_ON_MVIEW_REPSITES 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

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_POINT_STRENGTH: 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

COMPATIBLE: Definition , Search for examples

COMPILE: Definition , Search for examples

COMPILE Clause: Definition , Search for examples

COMPILE_CURSORS_FROM_REMOTE Procedure: Definition , Search for examples

COMPILE_SCHEMA Procedure: Definition , Search for examples

COMPOSE: Definition , Search for examples

COMPUTE: Definition , Search for examples

CONCAT: Definition , Search for examples

CONCAT Function: Definition , Search for examples

CONNECT: Definition , Search for examples

CONNECT TO Clause: Definition , Search for examples

CONNECTION Type: Definition , Search for examples

CONNECT_TIME: Definition , Search for examples

CONSIDER FRESH: Definition , Search for examples

CONSTANT: Definition , Search for examples

CONTINUE Function: Definition , Search for examples

CONTROLFILE REUSE Clause: Definition , Search for examples

CONTROL_FILES: Definition , Search for examples

CONTROL_FILE_RECORD_KEEP_TIME: Definition , Search for examples

CONVERT: Definition , Search for examples

CONVERT Function: Definition , Search for examples

CONVERT_ANYDATA_TO_LCR_DDL Function: Definition , Search for examples

CONVERT_ANYDATA_TO_LCR_ROW 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_TEMPLATE Function: Definition , Search for examples

CORE_DUMP_DEST: Definition , Search for examples

CORR: Definition , Search for examples

COS: Definition , Search for examples

COSH: Definition , Search for examples

COUNT: Definition , Search for examples

COVAR_POP: Definition , Search for examples

COVAR_SAMP: Definition , Search for examples

CPU_COUNT: 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 CONTROLFILE: Definition , Search for examples

CREATE DATABASE: Definition , Search for examples

CREATE DATABASE LINK: Definition , Search for examples

CREATE DIMENSION: Definition , Search for examples

CREATE DIRECTORY: Definition , Search for examples

CREATE FUNCTION: Definition , Search for examples

CREATE INDEX: Definition , Search for examples

CREATE INDEXTYPE: Definition , Search for examples

CREATE JAVA: Definition , Search for examples

CREATE LIBRARY: 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 OUTLINE: Definition , Search for examples

CREATE PACKAGE: Definition , Search for examples

CREATE PACKAGE BODY: Definition , Search for examples

CREATE PFILE: Definition , Search for examples

CREATE PROCEDURE: Definition , Search for examples

CREATE PROFILE: Definition , Search for examples

CREATE ROLE: Definition , Search for examples

CREATE ROLLBACK SEGMENT: Definition , Search for examples

CREATE SCHEMA: Definition , Search for examples

CREATE SEQUENCE: Definition , Search for examples

CREATE SPFILE: Definition , Search for examples

CREATE SYNONYM: 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_APPLY Procedure: Definition , Search for examples

CREATE_AQ_AGENT Procedure: Definition , Search for examples

CREATE_BITMAP_AREA_SIZE: Definition , Search for examples

CREATE_CAPTURE Procedure: Definition , Search for examples

CREATE_CHANGE_TABLE Procedure: Definition , Search for examples

CREATE_CONSUMER_GROUP Procedure: Definition , Search for examples

CREATE_EDIT_TABLES Procedure: Definition , Search for examples

CREATE_EVALUATION_CONTEXT Procedure: Definition , Search for examples

CREATE_ID Procedure: Definition , Search for examples

CREATE_MASTER_REPGROUP Procedure: Definition , Search for examples

CREATE_MASTER_REPOBJECT Procedure: Definition , Search for examples

CREATE_MSGSYSTEM_LINK Procedure: Definition , Search for examples

CREATE_MVIEW_REPGROUP Procedure: Definition , Search for examples

CREATE_MVIEW_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_POLICY_GROUP Procedure: Definition , Search for examples

CREATE_PROPAGATION 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_RULE Procedure: Definition , Search for examples

CREATE_RULE_SET Procedure: Definition , Search for examples

CREATE_SIMPLE_PLAN Procedure: Definition , Search for examples

CREATE_STAT_TABLE Procedure: Definition , Search for examples

CREATE_STORED_OUTLINES: Definition , Search for examples

CREATE_TEMPLATE_OBJECT Function: Definition , Search for examples

CREATE_TEMPLATE_PARM Function: Definition , Search for examples

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

CUME_DIST: Definition , Search for examples

CURRENT_DATE: Definition , Search for examples

CURRENT_INSTANCE Function: Definition , Search for examples

CURRENT_TIMESTAMP: Definition , Search for examples

CURSOR Expressions: Definition , Search for examples

CURSOR_SHARING: Definition , Search for examples

CURSOR_SPACE_FOR_TIME: Definition , Search for examples