start page | rating of books | rating of authors | reviews | copyrights

Book HomeTITLE OF BOOKSearch this book

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


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

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference