Home
Home
Help
Help
Contact us
Contact Us

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

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
S is currently selected
T U V W X
S SA SC SD SE SH SI SK SL SM SO SP SQ ST SU SW SY

Statements, Keywords, Packages, and Functions

S Function: Definition

S Procedure: Definition

SAMPLE Function: Definition

SAMPLE Procedure: Definition

SAVE: Definition

SAVE EXCEPTIONS: Definition

SAVE Function: Definition

SAVEPOINT: Definition

SAVEPOINT Procedure: Definition

SAVEPOINT Statement: Definition

SCHEDULE_PROPAGATION Procedure: Definition

SCHEMA: Definition

SCHEMA Clause: Definition

SCHEMAVALIDATE: Definition

SCN_TO_TIMESTAMP: Definition

SCN_TO_TIMESTAMP Function: Definition

SCOPE: Definition

SCOPE REF Constraints: 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

SEQUENCE Clause: 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 DATABASE Clause: Definition

SET DEFAULT TABLESPACE Clause: 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 ENCRYPTION KEY Clause: Definition

SET ENCRYPTION WALLET Clause: 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 STATEMENT_ID Clause: 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 UNUSED Clause: 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

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

SHRINK Clause: Definition

SHUTDOWN: Definition

SHUTDOWN Procedure: Definition

SID: Definition

SIGN: Definition

SIGNAL Procedure: Definition

SIGNATURE procedure: Definition

SILENT Option: Definition

SIN: Definition

SINH: Definition

SIZE: Definition

SIZE Clause: Definition

SIZE integer: Definition

SIZES Procedure: Definition

SKIP Procedure: Definition

SKIP_CORRUPT_BLOCKS Procedure: Definition

SKIP_ERROR Procedure: Definition

SKIP_TRANSACTION Procedure: Definition

SKIP_UNUSABLE_INDEXES: Definition

SLEEP Procedure: Definition

SMALL Function: Definition

SMALL Procedure: Definition

SORT: Definition

SOUNDEX: Definition

SPACE_ERROR_INFO Function: Definition

SPACE_USAGE Procedure: Definition

SPECIFICATION: Definition

SPLITTEXT Function: Definition

SPOOL: Definition

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

SQL_TRACE: Definition

SQRT: Definition

STANDBY: Definition

START: Definition

START Clause: Definition

START WITH Clause: 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

STATIC Clause: 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 Clause: 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

STORAGE Clauses: 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

SUBPARTITION Clause: 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

SUSPEND | RESUME: Definition

SWITCH LOGFILE Clause: 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

SYSAUX Clause: 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