Symbols | A | B | C | D | E | F | G | H | I | J | L | M | N | O | P | Q | R | S | T | U | V | W | X

Index: S

• savepoints : Rules and Restrictions
• scalar values : Bulk Querying with the BULK COLLECT Clause
• SCHEMA column,*_CONTEXT data dictionary views : Context Data Dictionary Views
• schema parameter, CREATE CONTEXT statement : CREATE CONTEXT: Creating Contexts
• schema-level event triggers
• • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
  • Trapping system errors
  • Schema-Level Event Triggers
• schema_name, trigger syntax : Schema-Level Event Triggers
• scope of variables in dynamic SQL : Dynamic PL/SQL
• secondary_instance parameter, CREATE_QUEUE_TABLE procedure : CREATE_QUEUE_TABLE and MIGRATE_QUEUE_TABLE: Setting Version Compatibility and Queue Migration
• security
• • Installing DBMS_RLS
  • CREATE_QUEUE_TABLE and MIGRATE_QUEUE_TABLE: Setting Version Compatibility and Queue Migration
• SEL column, *_POLICIES data dictionary views : Context Data Dictionary Views
• SELECT INTO clause : Bulk Querying with the BULK COLLECT Clause
• SELECT statement : Some Rules and Restrictions
• SELECT...BULK COLLECT statement : Bulk Querying with the BULK COLLECT Clause
• SERIALIZABLE isolation level : Transaction Visibility
• SERVER_ERROR attribute, database-level event : Database-Level Event Triggers
• SERVERERROR events
• • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
  • New Trigger Features in Oracle8i
  • Database-Level Event Triggers
• SESSION_USER attribute, SYS_CONTEXT function : The SYS_CONTEXT Function
• SESSION_USERID attribute, SYS_CONTEXT function : The SYS_CONTEXT Function
• SET clause : Triggers on Nested Table View Columns
• SET TRANSACTION statement : Transaction Visibility
• SET_COMPILER procedure, DBMS_JAVA package : GET_, SET_, and RESET_COMPILER OPTIONS: Getting and Setting Compiler Options
• SET_COMPILER_OPTION procedure, DBMS_JAVA package : Using DBMS_JAVA and DBMS_JAVA_TEST
• SET_CONTEXT procedure : SET_CONTEXT: Setting Context and Attribute Values
• SET_CONTEXT procedure, DBMS_SESSION package : FGAC Components
• SET_OUTPUT procedure, DBMS_JAVA package
• • Using DBMS_JAVA and DBMS_JAVA_TEST
  • SET_OUTPUT: Enabling Output from Java
• SET_PLSQL_TRACE procedure, DBMS_TRACE package : DBMS_TRACE Programs
• SGA (System Global Area) : Binding Versus Concatenation
• showattr.sql file : Using Cursor Attributes
• showCol program, ndsutil.pkg file : NDS Utility Package
• SHUTDOWN events
• • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
  • New Trigger Features in Oracle8i
  • Database-Level Event Triggers
• software usage meter
• • Autonomous Transactions (Chapter 2, Choose Your Transaction!)
  • When to Use Autonomous Transactions
• space, temporary LOBs : DBMS_LOB: Working with Temporary LOBs
• SQL%BULK_ROWCOUNT cursor attribute
• • ROLLBACK Behavior with FORALL
  • Using Cursor Attributes
• SQL*Plus
• • Fine-Grained Access Control (Chapter 8, Deploying Fine-Grained Access Control)
  • The Advantages of Definer Rights
• SQL99 compliance
• • Miscellaneous New Features and Performance Improvements (Chapter 10, More Goodies for Oracle8i PL/SQL Developers)
  • SQL99 Compliance
• sql_statement, FORALL statement : Bulk DML with the FORALL Statement
• SQL_string, EXECUTE IMMEDIATE statment : The EXECUTE IMMEDIATE Statement
• SQL_string, OPEN FOR statement : The OPEN FOR Statement
• SQLCODE function : Trapping system errors
• SQLJ : What's in Oracle8i Release 8.1?
• START_PROFILER function, DBMS_PROFILER package : DBMS_PROFILER Programs
• STARTUP events
• • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
  • New Trigger Features in Oracle8i
  • Database-Level Event Triggers
• statement_types parameter, ADD_POLICY procedure : ADD_POLICY: Adding a Policy
• STOP_PROFILER function, DBMS_PROFILER package : DBMS_PROFILER Programs
• subprograms, passing parameters to : Using Cursor Attributes
• SUCCESS return code, DBMS_PROFILER package : Profiler Return Codes
• Sybase Transact-SQL : And Then There's Java
• SYS schema : Installing DBMS_RLS
• SYS_CONTEXT function
• • FGAC Components
  • SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information
• SYSEVENT attribute, database-level event
• • Database-Level Event Triggers
  • Schema-Level Event Triggers
• system errors, trapping : Trapping system errors
• System Global Area (SGA) : Binding Versus Concatenation
• system level access control : System-Level Access Control
• system memory, bulk collection : Restricting Bulk Collection with ROWNUM
• system-level events : Database-Level Event Triggers