Oracle PL/SQL Programming: Guide to Oracle8i Features

By Steven Feuerstein

savepoints 

scalar values 

SCHEMA column,*_CONTEXT data dictionary views 

schema parameter, CREATE CONTEXT statement 

schema-level event triggers  2nd  3rd 

schema_name, trigger syntax 

scope of variables in dynamic SQL 

secondary_instance parameter, CREATE_QUEUE_TABLE procedure 

security  2nd 

SEL column, *_POLICIES data dictionary views 

SELECT INTO clause 

SELECT statement 

SELECT...BULK COLLECT statement 

SERIALIZABLE isolation level 

SERVER_ERROR attribute, database-level event 

SERVERERROR events  2nd  3rd  4th  5th  6th 

SESSION_USER attribute, SYS_CONTEXT function 

SESSION_USERID attribute, SYS_CONTEXT function 

SET clause 

SET TRANSACTION statement 

SET_COMPILER procedure, DBMS_JAVA package 

SET_COMPILER_OPTION procedure, DBMS_JAVA package 

SET_CONTEXT procedure 

SET_CONTEXT procedure, DBMS_SESSION package 

SET_OUTPUT procedure, DBMS_JAVA package  2nd 

SET_PLSQL_TRACE procedure, DBMS_TRACE package 

SGA (System Global Area) 

showattr.sql file 

showCol program, ndsutil.pkg file 

SHUTDOWN events  2nd  3rd  4th 

software usage meter  2nd 

space, temporary LOBs 

SQL%BULK_ROWCOUNT cursor attribute  2nd 

SQL*Plus  2nd 

sql_statement, FORALL statement 

SQL_string, EXECUTE IMMEDIATE statment 

SQL_string, OPEN FOR statement 

SQL99 compliance  2nd 

SQLCODE function 

SQLJ 

START_PROFILER function, DBMS_PROFILER package 

STARTUP events  2nd  3rd  4th 

statement_types parameter, ADD_POLICY procedure 

STOP_PROFILER function, DBMS_PROFILER package 

subprograms, passing parameters to 

SUCCESS return code, DBMS_PROFILER package 

Sybase Transact-SQL 

SYS schema 

SYS_CONTEXT function  2nd 

SYSEVENT attribute, database-level event  2nd 

system errors, trapping 

System Global Area (SGA) 

system level access control 

system memory, bulk collection 

system-level events