Home
Home
Customize
Customize
Help
Help
Contact us
Contact Us

SQL, PL/SQL, and SQL*Plus Syntax and Examples

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

CACHE Hint: Definition
CALENDARPRINT Procedures: Definition
CALL: Definition
CANCEL_TASK Procedure: Definition
CANCEL_TUNING_TASK Procedure: Definition
CANONICALIZE Procedure: Definition
CAN_REDEF_TABLE Procedure: Definition
CAPTURE_CURSOR_CACHE_SQLSET Procedure: Definition
CARDINALITY: Definition
CASE Expressions: Definition
CASE Expressions: Definition
CASE Statement: Definition
CAST: Definition
CAST_FROM_BINARY_DOUBLE Function: Definition
CAST_FROM_BINARY_FLOAT Function: Definition
CAST_FROM_BINARY_INTEGER Function: Definition
CAST_FROM_NUMBER Function: Definition
CAST_TO_BINARY_DOUBLE Function: Definition
CAST_TO_BINARY_FLOAT Function: Definition
CAST_TO_BINARY_INTEGER Function: Definition
CAST_TO_NUMBER Function: Definition
CAST_TO_NVARCHAR2 Function: Definition
CAST_TO_RAW Function: Definition
CAST_TO_VARCHAR2 Function: Definition
CEIL: Definition
CELLSPRINT Procedures: Definition
CENTER Function: Definition
CENTER Procedure: Definition
CENTERCLOSE Function: Definition
CENTERCLOSE Procedure: Definition
CENTEROPEN Function: Definition
CENTEROPEN Procedure: Definition
CFG_GET Function: Definition
CFG_REFRESH Procedure: Definition
CFG_UPDATE Procedure: Definition
CHANGE: Definition
CHANGE Procedure: Definition
CHANGEPRIVILEGES Function: Definition
CHANGE_JOIN_POS Procedure: Definition
CHAR Datatype: Definition
CHAR Datatype: Definition
CHARTOROWID: Definition
CHECKIN Function: Definition
CHECKOUT Procedure: Definition
CHECKPRIVILEGES Function: Definition
CHECKSUM Functions: Definition
CHECK_DB Function: Definition
CHECK_EXTERNAL Function: Definition
CHECK_OBJECT Procedure: Definition
CHOOSE_DATE Procedure: Definition
CHR: Definition
CITE Function: Definition
CITE Procedure: Definition
CLEANUP_GATEWAY Procedure: Definition
CLEANUP_INSTANTIATION_SETUP Procedure: Definition
CLEAR: Definition
CLEARKEYCOLUMNLIST: Definition
CLEARUPDATECOLUMNLIST: Definition
CLEAR_ALL_CONTEXT Procedure: Definition
CLEAR_CONTEXT Procedure: Definition
CLEAR_COOKIES Procedure: Definition
CLEAR_EXPRSET_STATS Procedure: Definition
CLEAR_IDENTIFIER Procedure: Definition
CLEAR_PENDING_AREA Procedure: Definition
CLEAR_PLSQL_TRACE Procedure: Definition
CLEAR_USED Procedure: Definition
CLIENT_ID_STAT_DISABLE Procedure: Definition
CLIENT_ID_STAT_ENABLE Procedure: Definition
CLIENT_ID_TRACE_DISABLE Procedure: Definition
CLIENT_ID_TRACE_ENABLE Procedure: Definition
CLOB Datatype: Definition
CLOB Datatype: Definition
CLOB2FILE Procedure: Definition
CLOB_TABLE: Definition
CLONENODE Function: Definition
CLONE_SIMPLE_TABLESPACE Procedure: Definition
CLONE_TABLESPACES Procedure: Definition
CLOSE Procedure: Definition
CLOSE Statement: Definition
CLOSECONTEXT: Definition
CLOSECONTEXT Procedure: Definition
CLOSE_ALL_CONNECTIONS Procedure: Definition
CLOSE_CONNECTION Procedure: Definition
CLOSE_CURSOR Procedure: Definition
CLOSE_DATABASE_LINK Procedure: Definition
CLOSE_ITERATOR Procedure: Definition
CLOSE_PERSISTENT_CONN Procedure: Definition
CLOSE_PERSISTENT_CONNS Procedure: Definition
CLOSE_WINDOW Procedure: Definition
CLUSTER Hint: Definition
CLUSTER_ID: Definition
CLUSTER_PROBABILITY: Definition
CLUSTER_SET: Definition
COALESCE: Definition
CODE Function: Definition
CODE Procedure: Definition
COLLECT: Definition
COLUMN: Definition
COLUMN NOPRINT: Definition
COLUMN_PRESENT Function: Definition
COLUMN_VALUE Procedure: Definition
COLUMN_VALUE Pseudocolumn: Definition
COLUMN_VALUE_LONG Procedure: Definition
COMMAND_REPLIES Function: Definition
COMMA_TO_TABLE Procedures: Definition
COMMENT: Definition
COMMENT Function: Definition
COMMENT Procedure: Definition
COMMIT: Definition
COMMIT Procedure: Definition
COMMIT Statement: Definition
COMMIT_COMMENT Procedure: Definition
COMMIT_FORCE Procedure: Definition
COMPARE Function: Definition
COMPARE Functions: Definition
COMPARE_OLD_VALUES Procedure: Definition
COMPATIBILITY Option: Definition
COMPATIBLE_10_1 Function: Definition
COMPATIBLE_10_2 Function: Definition
COMPATIBLE_9_2 Function: Definition
COMPILESCHEMA Procedure: Definition
COMPILE_FROM_REMOTE Procedure: Definition
COMPILE_SCHEMA Procedure: Definition
COMPOSE: Definition
COMPUTE: Definition
COMPUTE_CONFUSION_MATRIX Procedure: Definition
COMPUTE_LIFT Procedure: Definition
COMPUTE_ROC Procedure: Definition
CONCAT: Definition
CONCAT Function: Definition
CONFIGURE: Definition
CONFIGUREAUTOSYNC Procedure: Definition
CONNECT: Definition
CONNECTION Type: Definition
CONNECT_BY_ISCYCLE Pseudocolumn: Definition
CONNECT_BY_ISLEAF Pseudocolumn: Definition
CONNECT_BY_ROOT: Definition
CONSTRUCT Function: Definition
CONSUME_EVENT Function: Definition
CONSUME_PRIM_EVENTS Function: Definition
CONTINUE Function: Definition
CONVERT: Definition
CONVERT: Definition
CONVERT Function: Definition
CONVERT Functions: Definition
CONVERTTOBLOB Procedure: Definition
CONVERTTOCLOB Procedure: Definition
CONVERT_ANYDATA_TO_LCR_DDL Function: Definition
CONVERT_ANYDATA_TO_LCR_ROW Function: Definition
CONVERT_JMS_SELECTOR: Definition
CONVERT_LCR_TO_XML Function: Definition
CONVERT_RAW_VALUE Procedures: Definition
CONVERT_RAW_VALUE_NVARCHAR Procedure: Definition
CONVERT_RAW_VALUE_ROWID Procedure: Definition
CONVERT_XML_TO_LCR Function: Definition
COPIES Function: Definition
COPY: Definition
COPY Procedures: Definition
COPYEVOLVE Procedure: Definition
COPY_ATTRIBUTE_SET Procedure: Definition
COPY_FILE Procedure: Definition
COPY_JOB Procedure: Definition
COPY_TABLE_DEPENDENTS Procedure: Definition
CORR: Definition
CORR_*: Definition
CORR_K: Definition
CORR_S: Definition
COS: Definition
COSH: Definition
COUNT: Definition
COVAR_POP: Definition
COVAR_SAMP: Definition
CREATE CLUSTER: Definition
CREATE CONTEXT: Definition
CREATE CONTROLFILE: Definition
CREATE DATABASE: Definition
CREATE DATABASE LINK: Definition
CREATE DIMENSION: Definition
CREATE DIRECTORY: Definition
CREATE DISKGROUP: Definition
CREATE FUNCTION: Definition
CREATE INDEX: Definition
CREATE INDEXTYPE: Definition
CREATE JAVA: Definition
CREATE LIBRARY: Definition
CREATE MATERIALIZED VIEW: Definition
CREATE MATERIALIZED VIEW LOG: Definition
CREATE OPERATOR: Definition
CREATE OUTLINE: Definition
CREATE PACKAGE: Definition
CREATE PACKAGE BODY: Definition
CREATE PFILE: Definition
CREATE PROCEDURE: Definition
CREATE PROFILE: Definition
CREATE RESTORE POINT: Definition
CREATE ROLE: Definition
CREATE ROLLBACK SEGMENT: Definition
CREATE SCHEMA: Definition
CREATE SEQUENCE: Definition
CREATE SPFILE: Definition
CREATE SYNONYM: Definition
CREATE TABLE: Definition
CREATE TABLESPACE: Definition
CREATE TRIGGER: Definition
CREATE TYPE: Definition
CREATE TYPE BODY: Definition
CREATE USER: Definition
CREATE VIEW: Definition
CREATEATTRIBUTE Functions: Definition
CREATECDATASECTION Function: Definition
CREATECOMMENT Function: Definition
CREATEDATASTOREPREF Procedure: Definition
CREATEDOCUMENT Function: Definition
CREATEDOCUMENTFRAGMENT Function: Definition
CREATEELEMENT Functions: Definition
CREATEENTITYREFERENCE Function: Definition
CREATEFILTERPREF Procedure: Definition
CREATEFOLDER Function: Definition
CREATEINDEX Procedure: Definition
CREATELEXERPREF Procedure: Definition
CREATENONSCHEMABASEDXML: Definition
CREATEOIDPATH Function: Definition
CREATEPREFERENCES Procedure: Definition
CREATEPROCESSINGINSTRUCTION Function: Definition
CREATERESOURCE Functions: Definition
CREATESCHEMABASEDXML: Definition
CREATESECTIONGROUPPREF Procedure: Definition
CREATESTOPLISTPREF Procedure: Definition
CREATESTORAGEPREF Procedure: Definition
CREATETEMPORARY Procedures: Definition
CREATETEXTNODE Function: Definition
CREATEURI: Definition
CREATEWORLDLISTPREF Procedure: Definition
CREATEXML: Definition
CREATE_ALTER_TYPE_ERROR_TABLE Procedure: Definition
CREATE_APPLY Procedure: Definition
CREATE_AQ_AGENT Procedure: Definition
CREATE_ATTRIBUTE_SET Procedure: Definition
CREATE_AUTOLOG_CHANGE_SOURCE Procedure: Definition
CREATE_BIN_CAT Procedure: Definition
CREATE_BIN_NUM Procedure: Definition
CREATE_CALL Function: Definition
CREATE_CAPTURE Procedure: Definition
CREATE_CHAIN Procedure: Definition
CREATE_CHANGE_SET Procedure: Definition
CREATE_CHANGE_TABLE Procedure: Definition
CREATE_CLIP Procedure: Definition
CREATE_CONSUMER_GROUP Procedure: Definition
CREATE_DAD Procedure: Definition
CREATE_EDIT_TABLES Procedure: Definition
CREATE_ERROR_LOG Procedure: Definition
CREATE_EVALUATION_CONTEXT Procedure: Definition
CREATE_EVENT_SCHEDULE Procedure: Definition
CREATE_EVENT_STRUCTURE Procedure: Definition
CREATE_FILE Procedure: Definition
CREATE_FILE_GROUP Procedure: Definition
CREATE_HOTLOG_CHANGE_SOURCE Procedure: Definition
CREATE_ID Procedure: Definition
CREATE_INDEX_COST Procedure: Definition
CREATE_JOB Procedures: Definition
CREATE_JOB_CLASS Procedure: Definition
CREATE_MISS_CAT Procedure: Definition
CREATE_MISS_NUM Procedure: Definition
CREATE_MODEL Procedure: Definition
CREATE_NORM_LIN Procedure: Definition
CREATE_NP_QUEUE Procedure: Definition
CREATE_OBJECT Procedure: Definition
CREATE_OBJECT_DEPENDENCY Procedure: Definition
CREATE_OUTLINE Procedure: Definition
CREATE_PENDING_AREA Procedure: Definition
CREATE_PIPE Function: Definition
CREATE_PLAN Procedure: Definition
CREATE_PLAN_DIRECTIVE Procedure: Definition
CREATE_POLICY_GROUP Procedure: Definition
CREATE_PROGRAM Procedure: Definition
CREATE_PROPAGATION Procedure: Definition
CREATE_QUEUE Procedure: Definition
CREATE_QUEUE_TABLE Procedure: Definition
CREATE_RULE Procedure: Definition
CREATE_RULE_CLASS Procedure: Definition
CREATE_RULE_SET Procedure: Definition
CREATE_SCHEDULE Procedure: Definition
CREATE_SERVICE Function: Definition
CREATE_SERVICE Procedure: Definition
CREATE_SIMPLE_PLAN Procedure: Definition
CREATE_SQLWKLD Procedure: Definition
CREATE_STAT_TABLE Procedure: Definition
CREATE_STGTAB_SQLPROF Procedure: Definition
CREATE_STGTAB_SQLSET Procedure: Definition
CREATE_SUBSCRIPTION Procedure: Definition
CREATE_TABLE_COST Procedures: Definition
CREATE_TASK Procedures: Definition
CREATE_TRANSFORMATION Procedure: Definition
CREATE_TUNING_TASK Functions: Definition
CREATE_VERSION Procedure: Definition
CREATE_WINDOW Procedures: Definition
CREATE_WINDOW_GROUP Procedure: Definition
CREATE_WRAPPED Procedures: Definition
CRLF: Definition
CTX_ADM: Definition
CTX_CLS: Definition
CTX_DDL: Definition
CTX_DOC: Definition
CTX_OUTPUT: Definition
CTX_QUERY: Definition
CTX_REPORT: Definition
CTX_THES: Definition
CTX_ULEXER: Definition
CUME_DIST: Definition
CURRENT_DATE: Definition
CURRENT_INSTANCE Function: Definition
CURRENT_TIMESTAMP: Definition
CURSOR Expressions: Definition
CURSOR_SHARING_EXACT Hint: Definition
CV: Definition
HOST: Definition
SET: Definition
UNREGISTER DATABASE: Definition