Home

Help

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

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

SAVE: Definition

SAVE EXCEPTIONS: Definition

SAVEPOINT: Definition

SAVEPOINT (Executable Embedded SQL): Definition

SAVEPOINT Statement: Definition

SCHEMA: Definition

SCHEMA Clause: Definition

SCHEMA_NAMES: Definition

SCHEMA_NAMES Usage: Definition

SCN_TO_TIMESTAMP: Definition

SCOPE: Definition

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

SELECT: Definition

SELECT (Executable Embedded SQL): Definition

SELECT INTO Statement: Definition

SELECT_ERROR: Definition

SEQUENCE Clause: Definition

SERIALLY_REUSABLE Pragma: Definition

SESSIONTIMEZONE: 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 DESCRIPTOR: Definition

SET DESCRIPTOR (Executable Embedded SQL): 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 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 WALLET Clause: 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

SHARED: Definition

SHOW: Definition

SHRINK Clause: Definition

SHUTDOWN: Definition

SID: Definition

SIGN: Definition

SILENT Option: Definition

SIN: Definition

SINH: Definition

SIZE: Definition

SIZE Clause: Definition

SIZE integer: Definition

SKIP_UNUSABLE_INDEXES: Definition

SORT: Definition

SOUNDEX: Definition

SPECIFICATION: Definition

SPOOL: Definition

SQL: Definition

SQL Cursor: Definition

SQL Functions: Definition

SQL Operators: Definition

SQL Pseudocolumns: Definition

SQL Standards: Definition

SQLCA Contents: Definition

SQLCA Structure: Definition

SQLCHECK: Definition

SQLCODE Function: Definition

SQLERRM Function: Definition

SQLERROR: Definition

SQLSTATE Values: Definition

SQLWARNING: Definition

SQL_TRACE: Definition

SQRT: Definition

SRVCTL Commands: Definition

STANDBY: Definition

START: Definition

START Clause: Definition

START WITH Clause: Definition

STARTUP: Definition

START_SERVICE: 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_WSR_TEST: Definition

STDDEV: Definition

STDDEV_POP: Definition

STDDEV_SAMP: Definition

STOP: Definition

STOP Clause: Definition

STOP_SERVICE: Definition

STORAGE Clauses: Definition

STORE: Definition

STRING: Definition

SUBMULTISET Condition: Definition

SUBPARTITION Clause: Definition

SUBSTR: Definition

SUM: Definition

SUSPEND | RESUME: Definition

SWITCH LOGFILE Clause: Definition

SYSAUX Clause: Definition

SYSDATE: Definition

SYSTIMESTAMP: Definition

SYS_CONNECT_BY_PATH: Definition

SYS_CONTEXT: Definition

SYS_DBURIGEN: Definition

SYS_EXTRACT_UTC: Definition

SYS_GUID: Definition

SYS_INCLUDE: Definition

SYS_TYPEID: Definition

SYS_XMLAGG: Definition

SYS_XMLGEN: Definition