SQL and PL/SQL 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

T

U

V

W

X

Y

Z

Statements, Keywords, Packages, and Functions

SAVE: Definition , Search for examples

SAVE EXCEPTIONS: Definition , Search for examples

SAVE Function: Definition , Search for examples

SAVEPOINT: Definition , Search for examples

SAVEPOINT: Definition , Search for examples

SAVEPOINT Procedure: Definition , Search for examples

SAVEPOINT Statement: Definition , Search for examples

SCHEDULE_PROPAGATION Procedure: Definition , Search for examples

SCHEDULE_PURGE Procedure: Definition , Search for examples

SCHEDULE_PUSH Procedure: Definition , Search for examples

SCHEMA Clause: Definition , Search for examples

SDO_CS Package: Definition , Search for examples

SDO_GEOM Package: Definition , Search for examples

SDO_LRS Package: Definition , Search for examples

SDO_MIGRATE Package: Definition , Search for examples

SDO_TUNE Package: Definition , Search for examples

SDO_UTIL Package: Definition , Search for examples

SEED Procedure: Definition , Search for examples

SEGMENT_CORRUPT Procedure: Definition , Search for examples

SEGMENT_DROP_CORRUPT Procedure: Definition , Search for examples

SEGMENT_DUMP Procedure: Definition , Search for examples

SEGMENT_FIX_STATUS Procedure: Definition , Search for examples

SEGMENT_VERIFY Procedure: Definition , Search for examples

SELECT: Definition , Search for examples

SELECT INTO Statement: Definition , Search for examples

SELECT_OBJECT Procedure: Definition , Search for examples

SELF_CHECK Procedure: Definition , Search for examples

SEND_MESSAGE Function: Definition , Search for examples

SEND_OLD_VALUES Procedure: Definition , Search for examples

SERIALLY_REUSABLE Pragma: Definition , Search for examples

SERIAL_REUSE: Definition , Search for examples

SERVICE_NAMES: Definition , Search for examples

SESSIONS: Definition , Search for examples

SESSIONTIMEZONE: Definition , Search for examples

SESSION_CACHED_CURSORS: Definition , Search for examples

SESSION_MAX_OPEN_FILES: Definition , Search for examples

SET: Definition , Search for examples

SET APPI[NFO]{ON|OFF|text}: Definition , Search for examples

SET ARRAY[SIZE] {15|n}: Definition , Search for examples

SET AUTOP[RINT] {ON|OFF}: Definition , Search for examples

SET AUTORECOVERY [ON|OFF]: Definition , Search for examples

SET AUTOT[RACE] {ON|OFF|TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]: Definition , Search for examples

SET AUTO[COMMIT]{ON|OFF|IMM[EDIATE]|n}: Definition , Search for examples

SET BLO[CKTERMINATOR] {.|c|ON|OFF}: Definition , Search for examples

SET CMDS[EP] {;|c|ON|OFF}: Definition , Search for examples

SET COLSEP {_|text}: Definition , Search for examples

SET COM[PATIBILITY]{V7|V8|NATIVE}: Definition , Search for examples

SET CON[CAT] {.|c|ON|OFF}: Definition , Search for examples

SET COPYC[OMMIT] {0|n}: Definition , Search for examples

SET COPYTYPECHECK {ON|OFF}: Definition , Search for examples

SET DEF[INE] {&|c|ON|OFF}: Definition , Search for examples

SET ECHO {ON|OFF}: Definition , Search for examples

SET EDITF[ILE] file_name[.ext]: Definition , Search for examples

SET EMB[EDDED] {ON|OFF}: Definition , Search for examples

SET ESC[APE] {\|c|ON|OFF}: Definition , Search for examples

SET FEED[BACK] {6|n|ON|OFF}: Definition , Search for examples

SET FLAGGER {OFF|ENTRY |INTERMED[IATE]|FULL}: Definition , Search for examples

SET FLU[SH] {ON|OFF}: Definition , Search for examples

SET HEADS[EP] {||c|ON|OFF}: Definition , Search for examples

SET HEA[DING] {ON|OFF}: Definition , Search for examples

SET INSTANCE [instance_path|LOCAL]: Definition , Search for examples

SET LIN[ESIZE] {80|n}: Definition , Search for examples

SET LOBOF[FSET] {n|1}: Definition , Search for examples

SET LOGSOURCE [pathname]: Definition , Search for examples

SET LONG {80|n}: Definition , Search for examples

SET LONGC[HUNKSIZE] {80|n}: Definition , Search for examples

SET NEWP[AGE] {1|n|NONE}: Definition , Search for examples

SET NULL text: Definition , Search for examples

SET NUMF[ORMAT] format: Definition , Search for examples

SET NUM[WIDTH] {10|n}: Definition , Search for examples

SET PAGES[IZE] {24|n}: Definition , Search for examples

SET PAU[SE] {ON|OFF|text}: Definition , Search for examples

SET RECSEP {WR[APPED]|EA[CH]|OFF}: Definition , Search for examples

SET RECSEPCHAR {_|c}: Definition , Search for examples

SET SHIFT[INOUT] {VIS[IBLE]|INV[ISIBLE]}: Definition , Search for examples

SET SHOW[MODE] {ON|OFF}: Definition , Search for examples

SET SQLBL[ANKLINES] {ON|OFF}: Definition , Search for examples

SET SQLCO[NTINUE] {> |text}: Definition , Search for examples

SET SQLC[ASE] {MIX[ED]|LO[WER]|UP[PER]}: Definition , Search for examples

SET SQLN[UMBER] {ON|OFF}: Definition , Search for examples

SET SQLPLUSCOMPAT[IBILITY] {x.y[.z]}: Definition , Search for examples

SET SQLPRE[FIX] {#|c}: Definition , Search for examples

SET SQLP[ROMPT] {SQL>|text}: Definition , Search for examples

SET SQLT[ERMINATOR] {;|c|ON|OFF}: Definition , Search for examples

SET SUF[FIX] {SQL|text}: Definition , Search for examples

SET TAB {ON|OFF}: Definition , Search for examples

SET TERM[OUT] {ON|OFF}: Definition , Search for examples

SET TIMI[NG] {ON|OFF}: Definition , Search for examples

SET TI[ME] {ON|OFF}: Definition , Search for examples

SET TRIMS[POOL] {ON|OFF}: Definition , Search for examples

SET TRIM[OUT] {ON|OFF}: Definition , Search for examples

SET UND[ERLINE] {-|c|ON|OFF}: Definition , Search for examples

SET VER[IFY] {ON|OFF}: Definition , Search for examples

SET WRA[P] {ON|OFF}: Definition , Search for examples

SET APPINFO OFF: Definition , Search for examples

SET ARRAYSIZE: Definition , Search for examples

SET BUFFER: Definition , Search for examples

SET CLOSECURSOR: Definition , Search for examples

SET CONSTRAINT[S]: Definition , Search for examples

SET DATABASE Clause: Definition , Search for examples

SET DEFINE OFF: Definition , Search for examples

SET DOCUMENT: Definition , Search for examples

SET FLUSH OFF: Definition , Search for examples

SET MAXDATA: Definition , Search for examples

SET ROLE: Definition , Search for examples

SET SCAN: Definition , Search for examples

SET SERVEROUTPUT: Definition , Search for examples

SET SPACE: Definition , Search for examples

SET STATEMENT_ID Clause: Definition , Search for examples

SET TRANSACTION: Definition , Search for examples

SET TRANSACTION Statement: Definition , Search for examples

SET TRIMOUT ON: Definition , Search for examples

SET TRIMSPOOL ON: Definition , Search for examples

SET TRUNCATE: Definition , Search for examples

SET_ACTION Procedure: Definition , Search for examples

SET_AUTHENTICATION Procedure: Definition , Search for examples

SET_BODY_CHARSET Procedure: Definition , Search for examples

SET_BREAKPOINT Function: Definition , Search for examples

SET_CANCELLED Procedure: Definition , Search for examples

SET_CLIENT_INFO Procedure: Definition , Search for examples

SET_CLOSE_CACHED_OPEN_CURSORS Procedure: Definition , Search for examples

SET_COLUMNS Procedure: Definition , Search for examples

SET_COLUMN_STATS Procedure: Definition , Search for examples

SET_CONTEXT: Definition , Search for examples

SET_CONTEXT Procedure: Definition , Search for examples

SET_COOKIE_SUPPORT Procedure: Definition , Search for examples

SET_COOKIE_SUPPPORT Procedure: Definition , Search for examples

SET_COUNT Procedure: Definition , Search for examples

SET_DEFAULTS Procedure: Definition , Search for examples

SET_DETAILED_EXCP_SUPPORT Procedure: Definition , Search for examples

SET_DISABLED Procedure: Definition , Search for examples

SET_DML_HANDLER Procedure: Definition , Search for examples

SET_FILTER Procedure: Definition , Search for examples

SET_FOLLOW_REDIRECT Procedure: Definition , Search for examples

SET_GLOBAL_INSTANTIATION_SCN Procedure: Definition , Search for examples

SET_HEADER Procedure: Definition , Search for examples

SET_IDENTIFIER: Definition , Search for examples

SET_INDEX_STATS Procedure: Definition , Search for examples

SET_INITIAL_CONSUMER_GROUP Procedure: Definition , Search for examples

SET_KEY_COLUMNS Procedure: Definition , Search for examples

SET_LOG_LEVEL Procedure: Definition , Search for examples

SET_MAILHOST Procedure: Definition , Search for examples

SET_MAILPORT Procedure: Definition , Search for examples

SET_MODULE Procedure: Definition , Search for examples

SET_NLS Procedure: Definition , Search for examples

SET_OER_BREAKPOINT Function: Definition , Search for examples

SET_ORACLE_TRACE Procedure: Definition , Search for examples

SET_ORACLE_TRACE_IN_SESSION Procedure: Definition , Search for examples

SET_PARAMETER Procedure: Definition , Search for examples

SET_PARSE_ITEM Procedure: Definition , Search for examples

SET_PERSISTENT_CONN_SUPPORT Procedure: Definition , Search for examples

SET_PLSQL_TRACE Procedure: Definition , Search for examples

SET_PROXY Procedure: Definition , Search for examples

SET_RESPONSE_ERROR_CHECK Procedure: Definition , Search for examples

SET_ROLE Procedure: Definition , Search for examples

SET_SCHEMA_INSTANTIATION_SCN Procedure: Definition , Search for examples

SET_SENDFROM Procedure: Definition , Search for examples

SET_SESSION_LONGOPS Procedure: Definition , Search for examples

SET_SESSION_TIMEOUT Procedure: Definition , Search for examples

SET_SQL_TRACE Procedure: Definition , Search for examples

SET_SYSTEM_STATS Procedure: Definition , Search for examples

SET_TABLESPACE Procedure: Definition , Search for examples

SET_TABLE_INSTANTIATION_SCN Procedure: Definition , Search for examples

SET_TABLE_STATS Procedure: Definition , Search for examples

SET_TAG Procedure: Definition , Search for examples

SET_TIMEOUT Function: Definition , Search for examples

SET_TIMEOUT Procedure: Definition , Search for examples

SET_TIMEOUT_BEHAVIOR Procedure: Definition , Search for examples

SET_TRANSFER_TIMEOUT Procedure: Definition , Search for examples

SET_TRANSFORM_PARAM Procedure: Definition , Search for examples

SET_TRIGGER_FIRING_PROPERTY Procedure: Definition , Search for examples

SET_UPDATE_CONFLICT_HANDLER Procedure: Definition , Search for examples

SET_UP_QUEUE Procedure: Definition , Search for examples

SET_VALUE Function: Definition , Search for examples

SET_WALLET Procedure: Definition , Search for examples

SGA_MAX_SIZE: Definition , Search for examples

SHADOW_CORE_DUMP: Definition , Search for examples

SHARED: Definition , Search for examples

SHARED_MEMORY_ADDRESS: Definition , Search for examples

SHARED_POOL_RESERVED_SIZE: Definition , Search for examples

SHARED_POOL_SIZE: Definition , Search for examples

SHARED_SERVERS: Definition , Search for examples

SHARED_SERVER_SESSIONS: Definition , Search for examples

SHOW: Definition , Search for examples

SHOW LABEL: Definition , Search for examples

SHOW_BREAKPOINTS Procedure: Definition , Search for examples

SHOW_SOURCE Procedure: Definition , Search for examples

SHRINK Clause: Definition , Search for examples

SHUTDOWN: Definition , Search for examples

SHUTDOWN Clause: Definition , Search for examples

SHUTDOWN Procedure: Definition , Search for examples

SIGN: Definition , Search for examples

SIGNAL Procedure: Definition , Search for examples

SILENT Option: Definition , Search for examples

SIN: Definition , Search for examples

SINH: Definition , Search for examples

SIZE: Definition , Search for examples

SIZE Clause: Definition , Search for examples

SIZE integer: Definition , Search for examples

SIZES Procedure: Definition , Search for examples

SKIP Procedure: Definition , Search for examples

SKIP_CORRUPT_BLOCKS Procedure: Definition , Search for examples

SKIP_ERROR Procedure: Definition , Search for examples

SKIP_TRANSACTION Procedure: Definition , Search for examples

SLEEP Procedure: Definition , Search for examples

SORT_AREA_RETAINED_SIZE: Definition , Search for examples

SORT_AREA_SIZE: Definition , Search for examples

SOUNDEX: Definition , Search for examples

SPACE_ERROR_INFO Function: Definition , Search for examples

SPACE_USAGE Procedure: Definition , Search for examples

SPECIFY_NEW_MASTERS Procedure: Definition , Search for examples

SPFILE: Definition , Search for examples

SPOOL: Definition , Search for examples

SQL: Definition , Search for examples

SQL Cursor: Definition , Search for examples

SQL Functions: Definition , Search for examples

SQL Functions: Definition , Search for examples

SQL Operators: Definition , Search for examples

SQL Pseudocolumns: Definition , Search for examples

SQL Standards: Definition , Search for examples

SQL92_SECURITY: Definition , Search for examples

SQLCODE Function: Definition , Search for examples

SQLERRM Function: Definition , Search for examples

SQL_TRACE: Definition , Search for examples

SQRT: Definition , Search for examples

STANDBY_ARCHIVE_DEST: Definition , Search for examples

STANDBY_FILE_MANAGEMENT: Definition , Search for examples

START: Definition , Search for examples

STARTUP: Definition , Search for examples

STARTUP Procedure: Definition , Search for examples

STARTUP_EXTPROC_AGENT Procedure: Definition , Search for examples

START_APPLY Procedure: Definition , Search for examples

START_CAPTURE Procedure: Definition , Search for examples

START_LOGMNR Procedure: Definition , Search for examples

START_PROFILER Function: Definition , Search for examples

START_QUEUE Procedure: Definition , Search for examples

START_REDEF_TABLE Procedure: Definition , Search for examples

STAR_TRANSFORMATION_ENABLED: Definition , Search for examples

STATISTICS_LEVEL: Definition , Search for examples

STDDEV: Definition , Search for examples

STDDEV_POP: Definition , Search for examples

STDDEV_SAMP: Definition , Search for examples

STEP_ID Function: Definition , Search for examples

STOP_APPLY Procedure: Definition , Search for examples

STOP_CAPTURE Procedure: Definition , Search for examples

STOP_PROFILER Function: Definition , Search for examples

STOP_QUEUE Procedure: Definition , Search for examples

STORAGE Clauses: Definition , Search for examples

STORE: Definition , Search for examples

SUBMIT Procedure: Definition , Search for examples

SUBMIT_PENDING_AREA Procedure: Definition , Search for examples

SUBSCRIBE Procedure: Definition , Search for examples

SUBSTR: Definition , Search for examples

SUBSTR Function: Definition , Search for examples

SUBTRACT Procedure: Definition , Search for examples

SUM: Definition , Search for examples

SUSPEND | RESUME: Definition , Search for examples

SUSPEND_MASTER_ACTIVITY Procedure: Definition , Search for examples

SWITCH LOGFILE Clause: Definition , Search for examples

SWITCH_CONSUMER_GROUP_FOR_SESS Procedure: Definition , Search for examples

SWITCH_CONSUMER_GROUP_FOR_USER Procedure: Definition , Search for examples

SWITCH_CURRENT_CONSUMER_GROUP Procedure: Definition , Search for examples

SWITCH_MVIEW_MASTER Procedure: Definition , Search for examples

SYNCHRONIZE Function: Definition , Search for examples

SYNC_INTERIM_TABLE Procedure: Definition , Search for examples

SYNC_UP_REP Procedure: Definition , Search for examples

SYS.ANYDATA: Definition , Search for examples

SYS.ANYDATASET: Definition , Search for examples

SYS.ANYTYPE: Definition , Search for examples

SYSDATE: Definition , Search for examples

SYSTEM.MVIEW_EVALUATIONS: Definition , Search for examples

SYSTEM.MVIEW_EXCEPTIONS: Definition , Search for examples

SYSTEM.MVIEW_FILTER: Definition , Search for examples

SYSTEM.MVIEW_FILTERINSTANCE: Definition , Search for examples

SYSTEM.MVIEW_LOG: Definition , Search for examples

SYSTEM.MVIEW_RECOMMENDATIONS: Definition , Search for examples

SYSTEM.MVIEW_WORKLOAD: Definition , Search for examples

SYSTIMESTAMP: Definition , Search for examples

SYS_CONNECT_BY_PATH: Definition , Search for examples

SYS_CONTEXT: Definition , Search for examples

SYS_DBURIGEN: Definition , Search for examples

SYS_EXTRACT_UTC: Definition , Search for examples

SYS_GUID: Definition , Search for examples

SYS_TYPEID: Definition , Search for examples

SYS_XMLAGG: Definition , Search for examples

SYS_XMLGEN: Definition , Search for examples

Copyright © 2002 Oracle Corporation
All Rights Reserved.