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

SAVE Function: Definition

SAVEPOINT: Definition

SAVEPOINT Procedure: Definition

SAVEPOINT Statement: Definition

SCHEDULE_PROPAGATION Procedure: Definition

SCHEDULE_PURGE Procedure: Definition

SCHEDULE_PUSH Procedure: Definition

SCHEMA Clause: Definition

SDO_CS Package: Definition

SDO_GEOM Package: Definition

SDO_LRS Package: Definition

SDO_MIGRATE Package: Definition

SDO_TUNE Package: Definition

SDO_UTIL Package: Definition

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

SELECT_OBJECT Procedure: Definition

SELF_CHECK Procedure: Definition

SEND_MESSAGE Function: Definition

SEND_OLD_VALUES Procedure: Definition

SERIALLY_REUSABLE Pragma: Definition

SERIAL_REUSE: Definition

SERVICE_NAMES: Definition

SESSIONS: Definition

SESSIONTIMEZONE: Definition

SESSION_CACHED_CURSORS: Definition

SESSION_MAX_OPEN_FILES: Definition

SET: Definition

SET APPI[NFO]{ON|OFF|text}: 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 BLO[CKTERMINATOR] {.|c|ON|OFF}: Definition

SET CMDS[EP] {;|c|ON|OFF}: Definition

SET COLSEP {_|text}: Definition

SET COM[PATIBILITY]{V7|V8|NATIVE}: Definition

SET CON[CAT] {.|c|ON|OFF}: Definition

SET COPYC[OMMIT] {0|n}: Definition

SET COPYTYPECHECK {ON|OFF}: Definition

SET DEF[INE] {&|c|ON|OFF}: Definition

SET ECHO {ON|OFF}: Definition

SET EDITF[ILE] file_name[.ext]: Definition

SET EMB[EDDED] {ON|OFF}: Definition

SET ESC[APE] {\|c|ON|OFF}: Definition

SET FEED[BACK] {6|n|ON|OFF}: Definition

SET FLAGGER {OFF|ENTRY |INTERMED[IATE]|FULL}: Definition

SET FLU[SH] {ON|OFF}: Definition

SET HEADS[EP] {||c|ON|OFF}: Definition

SET HEA[DING] {ON|OFF}: Definition

SET INSTANCE [instance_path|LOCAL]: Definition

SET LIN[ESIZE] {80|n}: Definition

SET LOBOF[FSET] {n|1}: Definition

SET LOGSOURCE [pathname]: Definition

SET LONG {80|n}: Definition

SET LONGC[HUNKSIZE] {80|n}: Definition

SET NEWP[AGE] {1|n|NONE}: Definition

SET NULL text: Definition

SET NUMF[ORMAT] format: Definition

SET NUM[WIDTH] {10|n}: Definition

SET PAGES[IZE] {24|n}: Definition

SET PAU[SE] {ON|OFF|text}: Definition

SET RECSEP {WR[APPED]|EA[CH]|OFF}: Definition

SET RECSEPCHAR {_|c}: 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 SQLP[ROMPT] {SQL>|text}: Definition

SET SQLT[ERMINATOR] {;|c|ON|OFF}: Definition

SET SUF[FIX] {SQL|text}: Definition

SET TAB {ON|OFF}: Definition

SET TERM[OUT] {ON|OFF}: Definition

SET TIMI[NG] {ON|OFF}: Definition

SET TI[ME] {ON|OFF}: Definition

SET TRIMS[POOL] {ON|OFF}: Definition

SET TRIM[OUT] {ON|OFF}: Definition

SET UND[ERLINE] {-|c|ON|OFF}: Definition

SET VER[IFY] {ON|OFF}: Definition

SET WRA[P] {ON|OFF}: Definition

SET APPINFO OFF: Definition

SET ARRAYSIZE: Definition

SET BUFFER: Definition

SET CLOSECURSOR: Definition

SET CONSTRAINT[S]: Definition

SET DATABASE Clause: Definition

SET DEFINE OFF: Definition

SET DOCUMENT: Definition

SET FLUSH OFF: Definition

SET MAXDATA: Definition

SET ROLE: Definition

SET SCAN: Definition

SET SERVEROUTPUT: Definition

SET SPACE: Definition

SET STATEMENT_ID Clause: Definition

SET TRANSACTION: Definition

SET TRANSACTION Statement: Definition

SET TRIMOUT ON: Definition

SET TRIMSPOOL ON: Definition

SET TRUNCATE: Definition

SET_ACTION Procedure: Definition

SET_AUTHENTICATION Procedure: Definition

SET_BODY_CHARSET Procedure: Definition

SET_BREAKPOINT Function: Definition

SET_CANCELLED Procedure: Definition

SET_CLIENT_INFO Procedure: Definition

SET_CLOSE_CACHED_OPEN_CURSORS Procedure: Definition

SET_COLUMNS Procedure: Definition

SET_COLUMN_STATS Procedure: Definition

SET_CONTEXT: Definition

SET_CONTEXT Procedure: Definition

SET_COOKIE_SUPPORT Procedure: Definition

SET_COOKIE_SUPPPORT Procedure: Definition

SET_COUNT Procedure: Definition

SET_DEFAULTS Procedure: Definition

SET_DETAILED_EXCP_SUPPORT Procedure: Definition

SET_DISABLED Procedure: Definition

SET_DML_HANDLER Procedure: Definition

SET_FILTER Procedure: Definition

SET_FOLLOW_REDIRECT Procedure: Definition

SET_GLOBAL_INSTANTIATION_SCN Procedure: Definition

SET_HEADER Procedure: Definition

SET_IDENTIFIER: Definition

SET_INDEX_STATS Procedure: Definition

SET_INITIAL_CONSUMER_GROUP Procedure: Definition

SET_KEY_COLUMNS Procedure: Definition

SET_LOG_LEVEL Procedure: Definition

SET_MAILHOST Procedure: Definition

SET_MAILPORT Procedure: Definition

SET_MODULE Procedure: Definition

SET_NLS Procedure: Definition

SET_OER_BREAKPOINT Function: Definition

SET_ORACLE_TRACE Procedure: Definition

SET_ORACLE_TRACE_IN_SESSION Procedure: Definition

SET_PARAMETER Procedure: Definition

SET_PARSE_ITEM Procedure: Definition

SET_PERSISTENT_CONN_SUPPORT Procedure: Definition

SET_PLSQL_TRACE Procedure: Definition

SET_PROXY Procedure: Definition

SET_RESPONSE_ERROR_CHECK Procedure: Definition

SET_ROLE Procedure: Definition

SET_SCHEMA_INSTANTIATION_SCN Procedure: Definition

SET_SENDFROM Procedure: Definition

SET_SESSION_LONGOPS Procedure: Definition

SET_SESSION_TIMEOUT Procedure: Definition

SET_SQL_TRACE 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_TIMEOUT Function: Definition

SET_TIMEOUT Procedure: Definition

SET_TIMEOUT_BEHAVIOR Procedure: Definition

SET_TRANSFER_TIMEOUT Procedure: Definition

SET_TRANSFORM_PARAM Procedure: Definition

SET_TRIGGER_FIRING_PROPERTY Procedure: Definition

SET_UPDATE_CONFLICT_HANDLER Procedure: Definition

SET_UP_QUEUE Procedure: Definition

SET_VALUE Function: Definition

SET_WALLET Procedure: Definition

SGA_MAX_SIZE: Definition

SHADOW_CORE_DUMP: Definition

SHARED: Definition

SHARED_MEMORY_ADDRESS: Definition

SHARED_POOL_RESERVED_SIZE: Definition

SHARED_POOL_SIZE: Definition

SHARED_SERVERS: Definition

SHARED_SERVER_SESSIONS: Definition

SHOW: Definition

SHOW LABEL: Definition

SHOW_BREAKPOINTS Procedure: Definition

SHOW_SOURCE Procedure: Definition

SHRINK Clause: Definition

SHUTDOWN: Definition

SHUTDOWN Clause: Definition

SHUTDOWN Procedure: Definition

SIGN: Definition

SIGNAL 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

SLEEP Procedure: Definition

SORT_AREA_RETAINED_SIZE: Definition

SORT_AREA_SIZE: Definition

SOUNDEX: Definition

SPACE_ERROR_INFO Function: Definition

SPACE_USAGE Procedure: Definition

SPECIFY_NEW_MASTERS Procedure: Definition

SPFILE: Definition

SPOOL: Definition

SQL: Definition

SQL Cursor: Definition

SQL Functions: Definition

SQL Operators: Definition

SQL Pseudocolumns: Definition

SQL Standards: Definition

SQL92_SECURITY: Definition

SQLCODE Function: Definition

SQLERRM Function: Definition

SQL_TRACE: Definition

SQRT: Definition

STANDBY_ARCHIVE_DEST: Definition

STANDBY_FILE_MANAGEMENT: Definition

START: Definition

STARTUP: Definition

STARTUP Procedure: Definition

STARTUP_EXTPROC_AGENT Procedure: Definition

START_APPLY Procedure: Definition

START_CAPTURE Procedure: Definition

START_LOGMNR Procedure: Definition

START_PROFILER Function: Definition

START_QUEUE Procedure: Definition

START_REDEF_TABLE Procedure: Definition

STAR_TRANSFORMATION_ENABLED: Definition

STATISTICS_LEVEL: Definition

STDDEV: Definition

STDDEV_POP: Definition

STDDEV_SAMP: Definition

STEP_ID Function: Definition

STOP_APPLY Procedure: Definition

STOP_CAPTURE Procedure: Definition

STOP_PROFILER Function: Definition

STOP_QUEUE Procedure: Definition

STORAGE Clauses: Definition

STORE: Definition

SUBMIT Procedure: Definition

SUBMIT_PENDING_AREA Procedure: Definition

SUBSCRIBE Procedure: Definition

SUBSTR: Definition

SUBSTR Function: Definition

SUBTRACT Procedure: Definition

SUM: Definition

SUSPEND | RESUME: Definition

SUSPEND_MASTER_ACTIVITY Procedure: 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_MVIEW_MASTER Procedure: Definition

SYNCHRONIZE Function: Definition

SYNC_INTERIM_TABLE Procedure: Definition

SYNC_UP_REP Procedure: Definition

SYS.ANYDATA: Definition

SYS.ANYDATASET: Definition

SYS.ANYTYPE: 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