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

S Function: Definition
S Procedure: Definition
SAMPLE Function: Definition
SAMPLE Procedure: Definition
SAVE: Definition
SAVE Function: Definition
SAVEPOINT: Definition
SAVEPOINT Procedure: Definition
SAVEPOINT Statement: Definition
SCHEDULE_PROPAGATION Procedure: Definition
SCHEMAVALIDATE: Definition
SCN_TO_TIMESTAMP: Definition
SCN_TO_TIMESTAMP Function: Definition
SCRIPT Function: Definition
SCRIPT Procedure: Definition
SCRIPT_TUNING_TASK Function: Definition
SDO_CS: Definition
SDO_GCDR: Definition
SDO_GEOM: Definition
SDO_GEOMETRY: Definition
SDO_GEOR: Definition
SDO_GEORASTER: Definition
SDO_GEOR_UTL: Definition
SDO_LRS: Definition
SDO_MIGRATE: Definition
SDO_NET: Definition
SDO_NET_MEM: Definition
SDO_SAM: Definition
SDO_TOPO: Definition
SDO_TOPO_GEOMETRY: Definition
SDO_TOPO_MAP: Definition
SDO_TUNE: Definition
SDO_UTIL: Definition
SEED Procedures: Definition
SEGMENT_CORRUPT Procedure: Definition
SEGMENT_DROP_CORRUPT Procedure: Definition
SEGMENT_DUMP Procedure: Definition
SEGMENT_FIX_STATUS Procedure: Definition
SEGMENT_VERIFY Procedure: Definition
SELECT: Definition
SELECT INTO Statement: Definition
SELECTNODES Function: Definition
SELECTSINGLENODE Function: Definition
SELECT_CURSOR_CACHE Function: Definition
SELECT_OBJECT Procedure: Definition
SELECT_SQLSET Function: Definition
SELECT_WORKLOAD_REPOSITORY Functions: Definition
SELF_CHECK Procedure: Definition
SEND Procedure: Definition
SEND_ATTACH_RAW Procedure: Definition
SEND_ATTACH_VARCHAR2 Procedure: Definition
SEND_MESSAGE Function: Definition
SERIALLY_REUSABLE Pragma: Definition
SERV_MOD_ACT_STAT_DISABLE Procedure: Definition
SERV_MOD_ACT_STAT_ENABLE Procedure: Definition
SERV_MOD_ACT_TRACE_DISABLE Procedure: Definition
SERV_MOD_ACT_TRACE_ENABLE Procedure: Definition
SESSION _TRACE_DISABLE Procedure: Definition
SESSION _TRACE_ENABLE Procedure: Definition
SESSIONTIMEZONE: Definition
SESSION_TRACE_DISABLE Procedure: Definition
SESSION_TRACE_ENABLE Procedure: Definition
SET: Definition
SET: Definition
SET APPINFO OFF: Definition
SET APPI[NFO]{ON | OFF | text}: Definition
SET ARRAYSIZE: Definition
SET ARRAY[SIZE] {15 | n}: Definition
SET AUTOP[RINT] {ON | OFF}: Definition
SET AUTORECOVERY [ON | OFF]: Definition
SET AUTOT[RACE] {ON | OFF | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]: Definition
SET AUTO[COMMIT]{ON | OFF | IMM[EDIATE] | n}: Definition
SET CLOSECUR[SOR] {ON|OFF} (obsolete): Definition
SET COLSEP { | text}: Definition
SET COM[PATIBILITY]{V7 | V8 | NATIVE} (obsolete): Definition
SET CONSTRAINT[S]: Definition
SET COPYC[OMMIT] {0 | n}: Definition
SET COPYTYPECHECK {ON | OFF}: Definition
SET DEFINE OFF: Definition
SET DOC[UMENT] {ON|OFF} (obsolete): Definition
SET ECHO {ON | OFF}: Definition
SET EDITF[ILE] file_name[.ext]: Definition
SET EMB[EDDED] {ON | OFF}: Definition
SET FLAGGER {OFF | ENTRY | INTERMED[IATE] | FULL}: Definition
SET FLUSH OFF: Definition
SET FLU[SH] {ON | OFF}: Definition
SET HEA[DING] {ON | OFF}: Definition
SET LINESIZE: Definition
SET LOBOF[FSET] {1 | n}: Definition
SET LOGSOURCE [pathname]: Definition
SET LONG {80 | n}: Definition
SET LONGCHUNKSIZE: Definition
SET LONGC[HUNKSIZE] {80 | n}: Definition
SET NULL text: Definition
SET NUMF[ORMAT] format: Definition
SET NUM[WIDTH] {10 | n}: Definition
SET PAGESIZE: Definition
SET PAGES[IZE] {14 | n}: Definition
SET PAU[SE] {ON | OFF | text}: Definition
SET RECSEP {WR[APPED] | EA[CH] | OFF}: Definition
SET RECSEPCHAR { | c}: Definition
SET ROLE: Definition
SET SCAN {ON|OFF} (obsolete): Definition
SET SERVEROUTPUT: Definition
SET SHIFT[INOUT] {VIS[IBLE] | INV[ISIBLE]}: Definition
SET SHOW[MODE] {ON | OFF}: Definition
SET SQLBL[ANKLINES] {ON | OFF}: Definition
SET SQLCO[NTINUE] {> | text}: Definition
SET SQLC[ASE] {MIX[ED] | LO[WER] | UP[PER]}: Definition
SET SQLN[UMBER] {ON | OFF}: Definition
SET SQLPLUSCOMPAT[IBILITY] {x.y[.z]}: Definition
SET SQLPRE[FIX] {# | c}: Definition
SET SQLPROMPT: Definition
SET SQLP[ROMPT] {SQL> | text}: Definition
SET SUF[FIX] {SQL | text}: Definition
SET TAB: Definition
SET TAB {ON | OFF}: Definition
SET TERMOUT: Definition
SET TERM[OUT] {ON | OFF}: Definition
SET TIMI[NG] {ON | OFF}: Definition
SET TI[ME] {ON | OFF}: Definition
SET TRANSACTION: Definition
SET TRANSACTION Statement: Definition
SET TRIMOUT ON SET TRIMSPOOL ON: Definition
SET TRIMS[POOL] {ON | OFF}: Definition
SET TRIM[OUT] {ON | OFF}: Definition
SET TRU[NCATE] {ON|OFF} (obsolete): Definition
SET VER[IFY] {ON | OFF}: Definition
SET WRA[P] {ON | OFF}: Definition
SET XQUERY BASEURI {text}: Definition
SET XQUERY CONTEXT {text}: Definition
SET XQUERY NODE {BYVALUE | BYREFERENCE | DEFAULT}: Definition
SET XQUERY ORDERING {UNORDERED | ORDERED | DEFAULT}: Definition
SETACL Procedure: Definition
SETATTRIBUTE Procedures: Definition
SETATTRIBUTENODE Functions: Definition
SETBASEDIR: Definition
SETBATCHSIZE: Definition
SETBINDVALUE: Definition
SETCOLLIDATTRNAME: Definition
SETCOMMITBATCH: Definition
SETCONVERTSPECIALCHARS Procedure: Definition
SETDATA Procedures: Definition
SETDATAHEADER: Definition
SETDATEFORMAT: Definition
SETDOCTYPE: Definition
SETDOCTYPE Procedure: Definition
SETENCODINGTAG: Definition
SETERRORLOG: Definition
SETERRORLOG Procedure: Definition
SETERRORTAG: Definition
SETFTPPORT Procedure: Definition
SETHTTPPORT Procedure: Definition
SETIGNORECASE: Definition
SETKEYCOLUMN: Definition
SETMAXROWS: Definition
SETMAXROWS Procedure: Definition
SETMETAHEADER: Definition
SETNAMEDITEM Function: Definition
SETNODEVALUE Procedure: Definition
SETNULLHANDLING Procedure: Definition
SETPARAM Procedure: Definition
SETPREFIX Procedure: Definition
SETPRESERVEWHITESPACE: Definition
SETRAISEEXCEPTION: Definition
SETRAISENOROWSEXCEPTION: Definition
SETROWIDATTRNAME: Definition
SETROWIDATTRVALUE: Definition
SETROWSETTAG: Definition
SETROWSETTAG Procedure: Definition
SETROWTAG: Definition
SETROWTAG Procedure: Definition
SETSCHEMAVALIDATED: Definition
SETSKIPROWS: Definition
SETSKIPROWS Procedure: Definition
SETSQLTOXMLNAMEESCAPING: Definition
SETSTANDALONE Procedure: Definition
SETSTYLESHEETHEADER: Definition
SETTAGCASE: Definition
SETUPDATECOLUMN: Definition
SETVALIDATIONMODE: Definition
SETVALUE Procedure: Definition
SETVERSION Procedure: Definition
SETXSLT: Definition
SETXSLTPARAM: Definition
SET_ACTION Procedure: Definition
SET_ATTRIBUTE Procedure: Definition
SET_ATTRIBUTE_NULL Procedure: Definition
SET_AUTHENTICATION Procedure: Definition
SET_AUTHORIZATION Procedure: Definition
SET_BODY_CHARSET Procedures: Definition
SET_BREAKPOINT Function: Definition
SET_CACHE Procedure: Definition
SET_CANCELLED Procedure: Definition
SET_CLIENT_INFO Procedure: Definition
SET_COLUMN_STATS Procedures: Definition
SET_CONSUMER_GROUP_MAPPING Procedure: Definition
SET_CONSUMER_GROUP_MAPPING_PRI Procedure: Definition
SET_CONTEXT Procedure: Definition
SET_COOKIE_SUPPORT Procedures: Definition
SET_COUNT Procedure: Definition
SET_DAD_ATTRIBUTE Procedure: Definition
SET_DEFAULTS Procedure: Definition
SET_DEFAULT_SQLWKLD_PARAMETER Procedure: Definition
SET_DEFAULT_TASK_PARAMETER Procedures: Definition
SET_DETAILED_EXCP_SUPPORT Procedure: Definition
SET_DML_HANDLER Procedure: Definition
SET_ENQUEUE_DESTINATION Procedure: Definition
SET_EXECUTE Procedure: Definition
SET_EXPIRES Procedure: Definition
SET_FILTER Procedure: Definition
SET_FOLLOW_REDIRECT Procedures: Definition
SET_GLOBAL_ATTRIBUTE Procedure: Definition
SET_GLOBAL_INSTANTIATION_SCN Procedure: Definition
SET_HEADER Procedure: Definition
SET_IDENTIFIER: Definition
SET_INDEX_STATS Procedures: Definition
SET_INITIAL_CONSUMER_GROUP Procedure: Definition
SET_JOB_ANYDATA_VALUE Procedures: Definition
SET_JOB_ARGUMENT_VALUE Procedures: Definition
SET_KEY_COLUMNS Procedures: Definition
SET_LOG_LEVEL Procedure: Definition
SET_MAILHOST Procedure: Definition
SET_MAILPORT Procedure: Definition
SET_MESSAGE_NOTIFICATION Procedure: Definition
SET_MODULE Procedure: Definition
SET_NLS Procedure: Definition
SET_NOT_MODIFIED Procedure: Definition
SET_OER_BREAKPOINT Function: Definition
SET_PARALLEL Procedure: Definition
SET_PARAM Procedure: Definition
SET_PARAMETER Procedure: Definition
SET_PARAMETER Procedures: Definition
SET_PARSE_ITEM Procedure: Definition
SET_PERSISTENT_CONN_SUPPORT Procedure: Definition
SET_PLSQL_TRACE Procedure: Definition
SET_PROPERTY Procedure: Definition
SET_PROTECTION_REALM Procedure: Definition
SET_PROXY Procedure: Definition
SET_RESPONSE_ERROR_CHECK Procedure: Definition
SET_ROLE Procedure: Definition
SET_RULE_TRANSFORM_FUNCTION Procedure: Definition
SET_SCHEDULER_ATTRIBUTE Procedure: Definition
SET_SCHEMA_INSTANTIATION_SCN Procedure: Definition
SET_SENDFROM Procedure: Definition
SET_SESSION_LONGOPS Procedure: Definition
SET_SESSION_TIMEOUT Procedure: Definition
SET_SQLWKLD_PARAMETER Procedure: Definition
SET_SQL_TRACE Procedure: Definition
SET_SURROGATE_CONTROL Procedure: Definition
SET_SYSTEM_STATS Procedure: Definition
SET_TABLESPACE Procedure: Definition
SET_TABLE_INSTANTIATION_SCN Procedure: Definition
SET_TABLE_STATS Procedure: Definition
SET_TAG Procedure: Definition
SET_TASK_PARAMETER Procedure: Definition
SET_THRESHOLD Procedure: Definition
SET_TIMEOUT Function: Definition
SET_TIMEOUT Procedure: Definition
SET_TIMEOUT_BEHAVIOUR Procedure: Definition
SET_TRANSFER_TIMEOUT Procedure: Definition
SET_TRIGGER_FIRING_PROPERTY Procedure: Definition
SET_UPDATE_CONFLICT_HANDLER Procedure: Definition
SET_UP_QUEUE Procedure: Definition
SET_VALUE Function: Definition
SET_VALUE_DEPENDENCY Procedure: Definition
SET_WALLET Procedure: Definition
SET_WARNING_SETTING_STRING Procedure: Definition
SET_WATERMARK Procedure: Definition
SHOW: Definition
SHOWPAGE Procedure: Definition
SHOWSOURCE Procedure: Definition
SHOWWARNINGS: Definition
SHOWWARNINGS Procedure: Definition
SHOW_BREAKPOINTS Procedures: Definition
SHOW_FRAME_SOURCE Procedure: Definition
SHOW_SOURCE Procedures: Definition
SHUTDOWN: Definition
SHUTDOWN Procedure: Definition
SIGN: Definition
SIGNAL Procedure: Definition
SIGNATURE procedure: Definition
SILENT Option: Definition
SIN: Definition
SINH: Definition
SIZES Procedure: Definition
SKIP Procedure: Definition
SKIP_CORRUPT_BLOCKS Procedure: Definition
SKIP_ERROR Procedure: Definition
SKIP_TRANSACTION Procedure: Definition
SLEEP Procedure: Definition
SMALL Function: Definition
SMALL Procedure: Definition
SOUNDEX: Definition
SPACE_ERROR_INFO Function: Definition
SPACE_USAGE Procedure: Definition
SPLITTEXT Function: Definition
SPOOL: Definition
SQL Cursor: Definition
SQL Functions: Definition
SQL Functions: Definition
SQL Operators: Definition
SQL Pseudocolumns: Definition
SQL Standards: Definition
SQLCODE Function: Definition
SQLERRM Function: Definition
SQLTEXT_TO_SIGNATURE Function: Definition
SQRT: Definition
START: Definition
STARTUP: Definition
STARTUP Procedure: Definition
STARTUP_EXTPROC_AGENT Procedure: Definition
START_APPLY Procedure: Definition
START_CAPTURE Procedure: Definition
START_JOB Procedure: Definition
START_LOGMNR Procedure: Definition
START_PROPAGATION Procedure: Definition
START_QUEUE Procedure: Definition
START_REDEF_TABLE Procedure: Definition
START_SERVICE Procedure: Definition
STAR_TRANSFORMATION Hint: Definition
STATS_BINOMIAL_TEST: Definition
STATS_CROSSTAB: Definition
STATS_F_TEST: Definition
STATS_KS_TEST: Definition
STATS_MODE: Definition
STATS_MW_TEST: Definition
STATS_ONE_WAY_ANOVA: Definition
STATS_T_TEST_*: Definition
STATS_T_TEST_ONE: Definition
STATS_T_TEST_PAIRED: Definition
STATS_WSR_TEST: Definition
STATUS_LINE Procedure: Definition
STDDEV: Definition
STDDEV_POP: Definition
STDDEV_SAMP: Definition
STEP_ID Function: Definition
STOP_APPLY Procedure: Definition
STOP_CAPTURE Procedure: Definition
STOP_JOB Procedure: Definition
STOP_PROPAGATION Procedure: Definition
STOP_QUEUE Procedure: Definition
STOP_SERVICE Procedure: Definition
STORE: Definition
STORE_VALUES Procedure: Definition
STREAM2MULTI Procedure: Definition
STRIKE Function: Definition
STRIKE Procedure: Definition
STRING Function: Definition
STRING_TO_RAW Function: Definition
STRONG Function: Definition
STRONG Procedure: Definition
STYLE Function: Definition
STYLE Procedure: Definition
SUB Function: Definition
SUB Procedure: Definition
SUBMIT Procedure: Definition
SUBMIT_PENDING_AREA Procedure: Definition
SUBMULTISET Condition: Definition
SUBSCRIBE Procedure: Definition
SUBSTR: Definition
SUBSTR Function: Definition
SUBSTR Functions: Definition
SUBSTRINGDATA Function: Definition
SUM: Definition
SUMMARY Procedure: Definition
SUP Function: Definition
SUP Procedure: Definition
SWITCH_CONSUMER_GROUP_FOR_SESS Procedure: Definition
SWITCH_CONSUMER_GROUP_FOR_USER Procedure: Definition
SWITCH_CURRENT_CONSUMER_GROUP Procedure: Definition
SWITCH_PLAN Procedure: Definition
SYNCHRONIZE Function: Definition
SYNC_INTERIM_TABLE Procedure: Definition
SYS.AQ$_JMS_BYTES_MESSAGE Type: Definition
SYS.AQ$_JMS_EXCEPTION Type: Definition
SYS.AQ$_JMS_MAP_MESSAGE Type: Definition
SYS.AQ$_JMS_MESSAGE Type: Definition
SYS.AQ$_JMS_NAMESARRAY Type: Definition
SYS.AQ$_JMS_OBJECT_MESSAGE Type: Definition
SYS.AQ$_JMS_STREAM_MESSAGE Type: Definition
SYS.AQ$_JMS_TEXT_MESSAGE Type: Definition
SYS.AQ$_JMS_VALUE Type: Definition
SYS.MGW_BASIC_MSG_T Type: Definition
SYS.MGW_NAME_TYPE_ARRAY_T Type: Definition
SYS.MGW_NAME_VALUE_T Type: Definition
SYS.MGW_NUMBER_ARRAY_T Type: Definition
SYS.MGW_RAW_VALUE_T Type: Definition
SYS.MGW_TEXT_VALUE_T Type: Definition
SYS.MGW_TIBRV_FIELD_T Type: Definition
SYS.MGW_TIBRV_MSG_T Type: Definition
SYS.MSG_PROP_T Type: Definition
SYSDATE: Definition
SYSTEM.MVIEW_EVALUATIONS: Definition
SYSTEM.MVIEW_EXCEPTIONS: Definition
SYSTEM.MVIEW_FILTER: Definition
SYSTEM.MVIEW_FILTERINSTANCE: Definition
SYSTEM.MVIEW_LOG: Definition
SYSTEM.MVIEW_RECOMMENDATIONS: Definition
SYSTEM.MVIEW_WORKLOAD: Definition
SYSTIMESTAMP: Definition
SYS_CONNECT_BY_PATH: Definition
SYS_CONTEXT: Definition
SYS_DBURIGEN: Definition
SYS_EXTRACT_UTC: Definition
SYS_GUID: Definition
SYS_TYPEID: Definition
SYS_XMLAGG: Definition
SYS_XMLGEN: Definition