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 : 2.4. Rules and Restrictions

scalar values : 5.3. Bulk Querying with the BULK COLLECT Clause

SCHEMA column,*_CONTEXT data dictionary views : 8.4.3. Context Data Dictionary Views

schema parameter, CREATE CONTEXT statement : 8.2. CREATE CONTEXT: Creating Contexts

schema-level event triggers

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)

6.2.1.3. Trapping system errors

6.3. Schema-Level Event Triggers

schema_name, trigger syntax : 6.3. Schema-Level Event Triggers

scope of variables in dynamic SQL : 4.6.3. Dynamic PL/SQL

secondary_instance parameter, CREATE_QUEUE_TABLE procedure : 7.6.1. CREATE_QUEUE_TABLE and MIGRATE_QUEUE_TABLE: Setting Version Compatibility and Queue Migration

security

7.3.1. Installing DBMS_RLS

7.6.1. CREATE_QUEUE_TABLE and MIGRATE_QUEUE_TABLE: Setting Version Compatibility and Queue Migration

SEL column, *_POLICIES data dictionary views : 8.4.3. Context Data Dictionary Views

SELECT INTO clause : 5.3. Bulk Querying with the BULK COLLECT Clause

SELECT statement : 3.2.2. Some Rules and Restrictions

SELECT...BULK COLLECT statement : 5.3. Bulk Querying with the BULK COLLECT Clause

SERIALIZABLE isolation level : 2.4.2. Transaction Visibility

SERVER_ERROR attribute, database-level event : 6.2. Database-Level Event Triggers

SERVERERROR events

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)

6. New Trigger Features in Oracle8i

6.2. Database-Level Event Triggers

SESSION_USER attribute, SYS_CONTEXT function : 8.4.1. The SYS_CONTEXT Function

SESSION_USERID attribute, SYS_CONTEXT function : 8.4.1. The SYS_CONTEXT Function

SET clause : 6.1. Triggers on Nested Table View Columns

SET TRANSACTION statement : 2.4.2. Transaction Visibility

SET_COMPILER procedure, DBMS_JAVA package : 9.7.2. GET_, SET_, and RESET_COMPILER OPTIONS: Getting and Setting Compiler Options

SET_COMPILER_OPTION procedure, DBMS_JAVA package : 9.7. Using DBMS_JAVA and DBMS_JAVA_TEST

SET_CONTEXT procedure : 8.3. SET_CONTEXT: Setting Context and Attribute Values

SET_CONTEXT procedure, DBMS_SESSION package : 8.1. FGAC Components

SET_OUTPUT procedure, DBMS_JAVA package

9.7. Using DBMS_JAVA and DBMS_JAVA_TEST

9.7.3. SET_OUTPUT: Enabling Output from Java

SET_PLSQL_TRACE procedure, DBMS_TRACE package : 7.2.2. DBMS_TRACE Programs

SGA (System Global Area) : 4.4.1. Binding Versus Concatenation

showattr.sql file : 5.4. Using Cursor Attributes

showCol program, ndsutil.pkg file : 4.7. NDS Utility Package

SHUTDOWN events

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)

6. New Trigger Features in Oracle8i

6.2. Database-Level Event Triggers

software usage meter

1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!)

2.3. When to Use Autonomous Transactions

space, temporary LOBs : 7.5.2. DBMS_LOB: Working with Temporary LOBs

SQL%BULK_ROWCOUNT cursor attribute

5.2.2. ROLLBACK Behavior with FORALL

5.4. Using Cursor Attributes

SQL*Plus

1.3.7. Fine-Grained Access Control (Chapter 8, Deploying Fine-Grained Access Control)

3.1.1. The Advantages of Definer Rights

SQL99 compliance

1.3.9. Miscellaneous New Features and Performance Improvements (Chapter 10, More Goodies for Oracle8i PL/SQL Developers)

10.3. SQL99 Compliance

sql_statement, FORALL statement : 5.2. Bulk DML with the FORALL Statement

SQL_string, EXECUTE IMMEDIATE statment : 4.2.1. The EXECUTE IMMEDIATE Statement

SQL_string, OPEN FOR statement : 4.2.2. The OPEN FOR Statement

SQLCODE function : 6.2.1.3. Trapping system errors

SQLJ : 1.1. What's in Oracle8i Release 8.1?

START_PROFILER function, DBMS_PROFILER package : 7.1.1. DBMS_PROFILER Programs

STARTUP events

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)

6. New Trigger Features in Oracle8i

6.2. Database-Level Event Triggers

statement_types parameter, ADD_POLICY procedure : 7.3.4. ADD_POLICY: Adding a Policy

STOP_PROFILER function, DBMS_PROFILER package : 7.1.1. DBMS_PROFILER Programs

subprograms, passing parameters to : 5.4. Using Cursor Attributes

SUCCESS return code, DBMS_PROFILER package : 7.1.4. Profiler Return Codes

Sybase Transact-SQL : 1.2. And Then There's Java

SYS schema : 7.3.1. Installing DBMS_RLS

SYS_CONTEXT function

8.1. FGAC Components

8.4. SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information

SYSEVENT attribute, database-level event

6.2. Database-Level Event Triggers

6.3. Schema-Level Event Triggers

system errors, trapping : 6.2.1.3. Trapping system errors

System Global Area (SGA) : 4.4.1. Binding Versus Concatenation

system level access control : 7.6.2. System-Level Access Control

system memory, bulk collection : 5.3.1. Restricting Bulk Collection with ROWNUM

system-level events : 6.2. Database-Level Event Triggers

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.