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

# Index: S

SAVEPOINT procedure : C.15.12. The SAVEPOINT procedure
SAVEPOINT statement : 6.1.3. The SAVEPOINT Statement
savepoints
  (see also ROLLBACK statement)
  6.1.2. The ROLLBACK Statement
  COMMIT statements and : 6.1.1. The COMMIT Statement
  creating : 6.1.3. The SAVEPOINT Statement
saving virtual REFs : 20.4.3. Storage of Virtual REFs
scalar datatypes : (see datatypes)
scalar values and aggregates : 17.8.2. Combining Scalar and Aggregate Values
scale : 4.2.1.2. Decimal numeric datatypes
scheduling jobs
  DBMS_JOB for
    C.5. DBMS_ JOB
    1.4.5.3. Job scheduling with DBMS_ JOB
schema evolution
  object types and : 18.6.3. Schema Evolution
  object views and
    20. Object Views
    20.6. Schema Evolution
scope
  1.6.5. Scoping with nested blocks
  2.7.2. Scope of a Block
  15.3.4.2. Nested blocks provide scope
  cursor : 15.3.5.4. Cursor scope
  of cursor parameters : 6.10.3. Scope of Cursor Parameters
  of cursor variables : 6.12.6.4. Scope of cursor object
  of exceptions : 8.4.1. Scope of an Exception
  of local modules : 15.7.5. Scope of Local Modules
  of loops : 7.6.2. Loop Scope
  nested blocks and : 15.3.5.2. Scope and nested blocks
second : (see date; time)
security
  backups : (see backups)
  encrypting code : 23.7. Encrypting Stored Code
SELECT COUNT(*) : 1.7.5. Structured Code and Other Best Practices
SELECT INTO statement : 9.5.2. SELECT INTO from an Implicit Cursor
select lists : 6.4.2. PL/SQL Variables in a Cursor
SELECT statement
  assigning objects : 18.4.1.3. Assignment via FETCH (with SELECT)
  in cursor declarations : 6.4. Declaring Cursors
  cursors and : 6.2. Cursors in PL/SQL
  SELECT FOR UPDATE statement
    6.11. SELECT FOR UPDATE in Cursors
    6.13.2. Managing a Work Queue with SELECT FOR UPDATE
  SELECT INTO statement
    initializing collections : 19.4.1.3. Initializing implicitly via fetch
  THE function with : 19.5.1. The THE Pseudo-function
SELECT statements
  (see also DML statements)
  4.2.3.2. The VARCHAR2 and VARCHAR datatypes
  9.1.5. Referencing a Record and its Fields
  10.3. PL/SQL Tables and DML Statements
SELF object
  18.1.2. Some Simple Examples
  18.3.5. SELF: The Implied Parameter
  IN mode for : 18.3.4.2. Dots in method invocations
semicolon (;) : 2.4. The Semicolon Delimiter
SEND_MESSAGE function : C.10.8. The SEND_MESSAGE function
sequential control structures : 5.2. Sequential Control Statements
  formatting : 3.3. Formatting Control Structures
sequential processing : 17.8.6. Sequential Processing Against a Column's Value
serializable isolation level : 6.1.4. The SET TRANSACTION Statement
servers, PL/SQL integration with (example) : 19.7. Example: PL/SQL-to-Server Integration
session, user : 13.3.9. The USERENV function
SET clause, functions in : 17.1. Looking at the Problem
SET TRANSACTION statements : 6.1.4. The SET TRANSACTION Statement
SET_BLOCK_PROPERTY : 14.3.4. Using TO_CHAR to Create a Date Range
SET_DEFAULTS procedure : C.2.4. The SET_DEFAULTS procedure
SET_LABEL procedure : C.12.4. The SET_LABEL procedure
SET_MLS_LABEL procedure : C.12.5. The SET_NLS_LABEL procedure
SET_NLS procedure : C.12.6. The SET_NLS procedure
SET_ROLE procedure : C.12.7. The SET_ROLE procedure
SET_SQL_TRACE procedure : C.12.8. The SET_SQL_TRACE procedure
SET_UP procedure : C.13.6. The SET_UP procedure
SGA (System Global Area)
  pinning critical code in : 25.2.2. Pin Critical Code into the SGA
  tuning shared pool size : 25.2.1. Tune the Size of the Shared Pool of the SGA
shared
  functions : 23.1.2. Executing Functions
  procedures : 23.1.1. Executing Procedures
shared libraries
  1.4.7.5. External procedures
  for external procedures : 21.2.2. Step 2: Identify or Create the Shared Library
shared pool, SGA : 25.2.1. Tune the Size of the Shared Pool of the SGA
SIGN function : 13.1.16. The SIGN function
SIGNAL procedure : C.2.5. The SIGNAL procedure
signed numbers
  4.2.1.1. Binary integer datatypes
  4.2.1.3. The PLS_INTEGER datatype
simple loops
  7.2. The Simple Loop
  formatting : 3.3.2. Formatting Loops
SIN function : 13.1.17. The SIN function
SINH function : 13.1.18. The SINH function
size
  database triggers : 25.3.7. Keep Database Triggers Small
  encrypted code file size : 23.7.3. Impact of Encrypting Code
  of PL/SQL code, analyzing : 23.6.3. Analyzing the Size of PL/SQL Code
  SGA shared pool, tuning : 25.2.1. Tune the Size of the Shared Pool of the SGA
SLEEP procedure : C.7.5. The SLEEP procedure
SMALLINT subtype : 4.2.2. Numeric Subtypes
snapshots : C.13. DBMS_SNAPSHOT
SOUNDEX function : 11.1.13. The SOUNDEX function
source code : (see coding)
spaces : (see whitespace)
sparsity of tables
  10.2. Characteristics of PL/SQL Tables
  10.9.2. Data-Smart Row Numbers in PL/SQL Tables
specifcations, package : 1.7.3. Center All Development Around Packages
specification, package : (see packages, specification)
SQL
  ALTER SESSION commands : C.12. DBMS_SESSION
  calliong PL/SQL functions in : 25.3.2. Call PL/SQL Functions in SQL to Reduce I/O
  client-side : 25.3.3. Avoid Client-Side SQL
  DDL statements : (see DDL)
  DML statements : (see DML statements)
  dynamic
    C.14. DBMS_SQL
    1.4.4.2. Support for DDL and dynamic SQL
  formatting statements : 3.2. Formatting SQL Statements
  I/O-intensive : 25.3.6. Use PL/SQL to Improve Performance of IO-Intensive SQL
  minimizing access to : 25.3.1. Use Package Data to Minimize SQL Access
  PL/SQL in : (see stored functions, PL/SQL)
  PL/SQL loops versus : 7.7.4. PL/SQL Loops Versus SQL Processing
  statements, recursive processing in : 17.8.7. Recursive Processing in a SQL Statement
  static vs. dynamic : 6.2.1. Types of Cursors
  storing functions in : 1.4.4.1. Stored functions in SQL
  viewing stored objects : 23.6. Using SQL to Examine Stored Objects
SQL %FOUND attribute : 6.9.5. Implicit SQL Cursor Attributes
SQL %ISOPEN attribute : 6.9.5. Implicit SQL Cursor Attributes
SQL %NOTFOUND attribute : 6.9.5. Implicit SQL Cursor Attributes
SQL %ROWCOUNT attribute : 6.9.5. Implicit SQL Cursor Attributes
SQL*Plus
  managing stored objects : 23.5. Managing Stored Objects with SQL*Plus
  viewing compilation errors : 23.5.4. Viewing Compilation Errors in SQL*Plus
SQL_TRACE utility : 25.1. Analyzing Program Performance
SQLCODE function
  8.3.1. Named System Exceptions
  8.6.3. Using SQLCODE and SQLERRM in WHEN OTHERS Clause
  13.3.5. The SQLCODE function
SQLERRM function
  8.6.3. Using SQLCODE and SQLERRM in WHEN OTHERS Clause
  13.3.6. The SQLERRM function
SQRT function : 13.1.19. The SQRT function
standalone procedures
  synonyms for : 23.2.2. Creating Synonyms for Stored Objects
STANDARD package : 8.3.1. Named System Exceptions
  pinning in SGA shared pool : 25.2.2.1. Candidates for pinning in the shared pool
START_QUEUE procedure : C.3.2.6. The START_QUEUE procedure
static cursors : 6.2.1. Types of Cursors
static SQL : 6.2.1. Types of Cursors
status, module : 23.3. Module Validation and Dependency Management
STEP syntax : (see numeric FOR loops)
STEP_ID function : C.15.18. The STEP_ID function
STOP_QUEUE procedure : C.3.2.7. The STOP_QUEUE procedure
STORAGE_ERROR exception : 8.3.1. Named System Exceptions
store tables : 19.1. Types of Collections
stored
  code, encrypting : 23.7. Encrypting Stored Code
  functions, executing PL/SQL : 23.1.2. Executing Functions
  modules/packages : 1.4.3.11. Stored procedures, functions, and packages
  objects : 23. Managing Code in the Database
    execute authority on : 23.2.1. Execute Authority on Stored Objects
    interdependency of : 23.3.1. Interdependencies of Stored Objects
    managing with SQL*Plus : 23.5. Managing Stored Objects with SQL*Plus
    synonyms for : 23.2.2. Creating Synonyms for Stored Objects
    viewing with SQL : 23.6. Using SQL to Examine Stored Objects
  procedures, PL/SQL Version 1.1 : B. Calling Stored Procedures from PL/SQL Version 1.1
  virtual REFs : 20.4.3. Storage of Virtual REFs
stored functions, PL/SQL
  17.1. Looking at the Problem
  17.7. Realities: Calling PL/SQL Functions in SQL
  calling packaged functions : 17.5. Calling Packaged Functions in SQL
  examples of : 17.8. Examples of Embedded PL/SQL
  name precedence and : 17.6. Column/Function Name Precedence
  package variable modification : 17.4. Restrictions on PL/SQL Functions in SQL
  read consistency and : 17.7.2. Read Consistency Model Complications
  requirements/restrictions : 17.3. Requirements for Stored Functions in SQL
strings
  (see also literals)
  2.3. Literals
  adding characters to
    11.1.11. The RPAD function
    11.1.8. The LPAD function
  case of
    11.1.16. The UPPER function
    11.1.4. The INITCAP function
    11.1.7. The LOWER function
  comparing
    4.2.3.2. The VARCHAR2 and VARCHAR datatypes
    11.1.13. The SOUNDEX function
  concatenating : 11.1.3. The CONCAT function
  converting
    between character sets : 14.2.2. The CONVERT function
    to/from dates
      14.1. Conversion Formats
      14.2.6. The TO_CHAR function (date conversion)
      14.2.8. The TO_DATE function
    hexadecimal : 14.2.3. The HEXTORAW function
    to/from numbers
      14.1.2. Number Format Models
      14.2.7. The TO_CHAR function (number conversion)
      14.2.9. The TO_NUMBER function
      17.8.7. Recursive Processing in a SQL Statement
    to row numbers : 10.5.1. Automatic Conversion of Row Number Expressions
  datatypes for : 4.2.3. Character Datatypes
  extracting characters from : 11.1.14. The SUBSTR function
  finding substrings of : 11.1.5. The INSTR function
  functions for : 11. Character Functions
  justifying : 11.2.3. Filling Text to Fit a Line
  length of : 11.1.6. The LENGTH function
  parsing : 11.2.1. Parsing a Name
  replacing characters in
    11.1.10. The REPLACE function
    11.1.15. The TRANSLATE function
  searching for, in code : 23.6.4. Displaying and Searching Source Code
  stripping characters from
    11.1.12. The RTRIM function
    11.1.9. The LTRIM function
  variable-length : 4.2.3.2. The VARCHAR2 and VARCHAR datatypes
  verifying format of : 11.2.5. Verifying String Formats with TRANSLATE
  word wrap : 11.2.2. Implementing Word Wrap for Long Text
strong REF CURSOR type : (see cursor variables)
structure, code : 1.7.5. Structured Code and Other Best Practices
structure, data : (see data structures)
structured interface trace filtering : 26.4. Structured Interface Filtering
stub generation : B.1. Using Stubs to Talk to Server-Side PL/SQL
stubs : 5.2.2.3. Supporting top-down design of modules
style, coding : 1.7.4. Standardize Your PL/SQL Development Environment
subblocks : (see nested blocks; nested modules)
SUBMIT procedure : C.5.8. The SUBMIT procedure
subqueries, correlated : 17.8.3. Replacing Correlated Subqueries
SUBSTR function
  C.6.14. The SUBSTR function
  11.1.14. The SUBSTR function
  for declaring long strings : 4.2.3.1. The CHAR datatype
substrings
  counting occurrences of : 11.2.4. Counting Substring Occurrences in Strings
  extracting from strings : 11.1.14. The SUBSTR function
  finding : 11.1.5. The INSTR function
  replacing
    11.1.10. The REPLACE function
    11.1.15. The TRANSLATE function
subtypes
  1.4.4.4. Programmer-defined subtypes
  4.6. Programmer-Defined Subtypes
suppressing zeros/spaces : 14.3.1. FM: Suppressing Blanks and Zeros
symbols
  != (not equals) : 2.1. The PL/SQL Character Set
  % (percent sign) : 2.1. The PL/SQL Character Set
  > (label delimeters) : 2.1. The PL/SQL Character Set
  >= (greater than) : 2.1. The PL/SQL Character Set
  <> (not equals) : 2.1. The PL/SQL Character Set
  <= (less than) : 2.1. The PL/SQL Character Set
  ** (double asterisk) : 2.1. The PL/SQL Character Set
  -- (comment indicator) : 2.1. The PL/SQL Character Set
  /* and */ (comment block delimiters) : 2.1. The PL/SQL Character Set
  ; (semicolon) : 2.1. The PL/SQL Character Set
  => (associational operator for positional notation) : 2.1. The PL/SQL Character Set
  \: (colon) : 2.1. The PL/SQL Character Set
  _ (underscore) : 2.1. The PL/SQL Character Set
  || (concatenation) operator : 2.1. The PL/SQL Character Set
synchronization : 1.7.2. Synchronize Program and Data Structures
synchronization with columns : 4.5.1.1. Synchronization with database columns
synonyms for stored objects : 23.2.2. Creating Synonyms for Stored Objects
SYS_NC_OID$ column : 18.4.2.1. Object identifiers (OIDs)
SYS_NC_ROWINFO$ column : 18.4.2.1. Object identifiers (OIDs)
SYSDATE function : 12.1.7. The SYSDATE function
  and NEW_TIME function : 12.2.2. Using NEW_TIME in Client-Server Environments
system
  date : 12.1.7. The SYSDATE function
  exceptions : 8.3.1. Named System Exceptions
System Global Area (SGA)
  pinning critical code into : 25.2.2. Pin Critical Code into the SGA
  tuning shared pool size : 25.2.1. Tune the Size of the Shared Pool of the SGA

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

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