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 : The SAVEPOINT procedure
• SAVEPOINT statement : The SAVEPOINT Statement
• savepoints
• • (see also ROLLBACK statement)
  • The ROLLBACK Statement
  • COMMIT statements and : The COMMIT Statement
  • creating : The SAVEPOINT Statement
• saving virtual REFs : Storage of Virtual REFs
• scalar datatypes : (see datatypes)
• scalar values and aggregates : Combining Scalar and Aggregate Values
• scale : Decimal numeric datatypes
• scheduling jobs
• • DBMS_JOB for
  • • DBMS_ JOB
    • Job scheduling with DBMS_ JOB
• schema evolution
• • object types and : Schema Evolution
  • object views and
  • • Object Views
    • Schema Evolution
• scope
• • Scoping with nested blocks
  • Scope of a Block
  • Nested blocks provide scope
  • cursor : Cursor scope
  • of cursor parameters : Scope of Cursor Parameters
  • of cursor variables : Scope of cursor object
  • of exceptions : Scope of an Exception
  • of local modules : Scope of Local Modules
  • of loops : Loop Scope
  • nested blocks and : Scope and nested blocks
• second : (see date; time)
• security
• • backups : (see backups)
  • encrypting code : Encrypting Stored Code
• SELECT COUNT(*) : Structured Code and Other Best Practices
• SELECT INTO statement : SELECT INTO from an Implicit Cursor
• select lists : PL/SQL Variables in a Cursor
• SELECT statement
• • assigning objects : Assignment via FETCH (with SELECT)
  • in cursor declarations : Declaring Cursors
  • cursors and : Cursors in PL/SQL
  • SELECT FOR UPDATE statement
  • • SELECT FOR UPDATE in Cursors
    • Managing a Work Queue with SELECT FOR UPDATE
  • SELECT INTO statement
  • • initializing collections : Initializing implicitly via fetch
  • THE function with : The THE Pseudo-function
• SELECT statements
• • (see also DML statements)
  • The VARCHAR2 and VARCHAR datatypes
  • Referencing a Record and its Fields
  • PL/SQL Tables and DML Statements
• SELF object
• • Some Simple Examples
  • SELF: The Implied Parameter
  • IN mode for : Dots in method invocations
• semicolon (;) : The Semicolon Delimiter
• SEND_MESSAGE function : The SEND_MESSAGE function
• sequential control structures : Sequential Control Statements
• • formatting : Formatting Control Structures
• sequential processing : Sequential Processing Against a Column's Value
• serializable isolation level : The SET TRANSACTION Statement
• servers, PL/SQL integration with (example) : Example: PL/SQL-to-Server Integration
• session, user : The USERENV function
• SET clause, functions in : Looking at the Problem
• SET TRANSACTION statements : The SET TRANSACTION Statement
• SET_BLOCK_PROPERTY : Using TO_CHAR to Create a Date Range
• SET_DEFAULTS procedure : The SET_DEFAULTS procedure
• SET_LABEL procedure : The SET_LABEL procedure
• SET_MLS_LABEL procedure : The SET_NLS_LABEL procedure
• SET_NLS procedure : The SET_NLS procedure
• SET_ROLE procedure : The SET_ROLE procedure
• SET_SQL_TRACE procedure : The SET_SQL_TRACE procedure
• SET_UP procedure : The SET_UP procedure
• SGA (System Global Area)
• • pinning critical code in : Pin Critical Code into the SGA
  • tuning shared pool size : Tune the Size of the Shared Pool of the SGA
• shared
• • functions : Executing Functions
  • procedures : Executing Procedures
• shared libraries
• • External procedures
  • for external procedures : Step 2: Identify or Create the Shared Library
• shared pool, SGA : Tune the Size of the Shared Pool of the SGA
• SIGN function : The SIGN function
• SIGNAL procedure : The SIGNAL procedure
• signed numbers
• • Binary integer datatypes
  • The PLS_INTEGER datatype
• simple loops
• • The Simple Loop
  • formatting : Formatting Loops
• SIN function : The SIN function
• SINH function : The SINH function
• size
• • database triggers : Keep Database Triggers Small
  • encrypted code file size : Impact of Encrypting Code
  • of PL/SQL code, analyzing : Analyzing the Size of PL/SQL Code
  • SGA shared pool, tuning : Tune the Size of the Shared Pool of the SGA
• SLEEP procedure : The SLEEP procedure
• SMALLINT subtype : Numeric Subtypes
• snapshots : DBMS_SNAPSHOT
• SOUNDEX function : The SOUNDEX function
• source code : (see coding)
• spaces : (see whitespace)
• sparsity of tables
• • Characteristics of PL/SQL Tables
  • Data-Smart Row Numbers in PL/SQL Tables
• specifcations, package : Center All Development Around Packages
• specification, package : (see packages, specification)
• SQL
• • ALTER SESSION commands : DBMS_SESSION
  • calliong PL/SQL functions in : Call PL/SQL Functions in SQL to Reduce I/O
  • client-side : Avoid Client-Side SQL
  • DDL statements : (see DDL)
  • DML statements : (see DML statements)
  • dynamic
  • • DBMS_SQL
    • Support for DDL and dynamic SQL
  • formatting statements : Formatting SQL Statements
  • I/O-intensive : Use PL/SQL to Improve Performance of IO-Intensive SQL
  • minimizing access to : Use Package Data to Minimize SQL Access
  • PL/SQL in : (see stored functions, PL/SQL)
  • PL/SQL loops versus : PL/SQL Loops Versus SQL Processing
  • statements, recursive processing in : Recursive Processing in a SQL Statement
  • static vs. dynamic : Types of Cursors
  • storing functions in : Stored functions in SQL
  • viewing stored objects : Using SQL to Examine Stored Objects
• SQL %FOUND attribute : Implicit SQL Cursor Attributes
• SQL %ISOPEN attribute : Implicit SQL Cursor Attributes
• SQL %NOTFOUND attribute : Implicit SQL Cursor Attributes
• SQL %ROWCOUNT attribute : Implicit SQL Cursor Attributes
• SQL*Plus
• • managing stored objects : Managing Stored Objects with SQL*Plus
  • viewing compilation errors : Viewing Compilation Errors in SQL*Plus
• SQL_TRACE utility : Analyzing Program Performance
• SQLCODE function
• • Named System Exceptions
  • Using SQLCODE and SQLERRM in WHEN OTHERS Clause
  • The SQLCODE function
• SQLERRM function
• • Using SQLCODE and SQLERRM in WHEN OTHERS Clause
  • The SQLERRM function
• SQRT function : The SQRT function
• standalone procedures
• • synonyms for : Creating Synonyms for Stored Objects
• STANDARD package : Named System Exceptions
• • pinning in SGA shared pool : Candidates for pinning in the shared pool
• START_QUEUE procedure : The START_QUEUE procedure
• static cursors : Types of Cursors
• static SQL : Types of Cursors
• status, module : Module Validation and Dependency Management
• STEP syntax : (see numeric FOR loops)
• STEP_ID function : The STEP_ID function
• STOP_QUEUE procedure : The STOP_QUEUE procedure
• STORAGE_ERROR exception : Named System Exceptions
• store tables : Types of Collections
• stored
• • code, encrypting : Encrypting Stored Code
  • functions, executing PL/SQL : Executing Functions
  • modules/packages : Stored procedures, functions, and packages
  • objects : Managing Code in the Database
  • • execute authority on : Execute Authority on Stored Objects
    • interdependency of : Interdependencies of Stored Objects
    • managing with SQL*Plus : Managing Stored Objects with SQL*Plus
    • synonyms for : Creating Synonyms for Stored Objects
    • viewing with SQL : Using SQL to Examine Stored Objects
  • procedures, PL/SQL Version 1.1 : Calling Stored Procedures from PL/SQL Version 1.1
  • virtual REFs : Storage of Virtual REFs
• stored functions, PL/SQL
• • Looking at the Problem
  • Realities: Calling PL/SQL Functions in SQL
  • calling packaged functions : Calling Packaged Functions in SQL
  • examples of : Examples of Embedded PL/SQL
  • name precedence and : Column/Function Name Precedence
  • package variable modification : Restrictions on PL/SQL Functions in SQL
  • read consistency and : Read Consistency Model Complications
  • requirements/restrictions : Requirements for Stored Functions in SQL
• strings
• • (see also literals)
  • Literals
  • adding characters to
  • • The RPAD function
    • The LPAD function
  • case of
  • • The UPPER function
    • The INITCAP function
    • The LOWER function
  • comparing
  • • The VARCHAR2 and VARCHAR datatypes
    • The SOUNDEX function
  • concatenating : The CONCAT function
  • converting
  • • between character sets : The CONVERT function
    • to/from dates
    • • Conversion Formats
      • The TO_CHAR function (date conversion)
      • The TO_DATE function
    • hexadecimal : The HEXTORAW function
    • to/from numbers
    • • Number Format Models
      • The TO_CHAR function (number conversion)
      • The TO_NUMBER function
      • Recursive Processing in a SQL Statement
    • to row numbers : Automatic Conversion of Row Number Expressions
  • datatypes for : Character Datatypes
  • extracting characters from : The SUBSTR function
  • finding substrings of : The INSTR function
  • functions for : Character Functions
  • justifying : Filling Text to Fit a Line
  • length of : The LENGTH function
  • parsing : Parsing a Name
  • replacing characters in
  • • The REPLACE function
    • The TRANSLATE function
  • searching for, in code : Displaying and Searching Source Code
  • stripping characters from
  • • The RTRIM function
    • The LTRIM function
  • variable-length : The VARCHAR2 and VARCHAR datatypes
  • verifying format of : Verifying String Formats with TRANSLATE
  • word wrap : Implementing Word Wrap for Long Text
• strong REF CURSOR type : (see cursor variables)
• structure, code : Structured Code and Other Best Practices
• structure, data : (see data structures)
• structured interface trace filtering : Structured Interface Filtering
• stub generation : Using Stubs to Talk to Server-Side PL/SQL
• stubs : Supporting top-down design of modules
• style, coding : Standardize Your PL/SQL Development Environment
• subblocks : (see nested blocks; nested modules)
• SUBMIT procedure : The SUBMIT procedure
• subqueries, correlated : Replacing Correlated Subqueries
• SUBSTR function
• • The SUBSTR function
  • The SUBSTR function
  • for declaring long strings : The CHAR datatype
• substrings
• • counting occurrences of : Counting Substring Occurrences in Strings
  • extracting from strings : The SUBSTR function
  • finding : The INSTR function
  • replacing
  • • The REPLACE function
    • The TRANSLATE function
• subtypes
• • Developer-defined subtypes
  • Developer-Defined Subtypes
• suppressing zeros/spaces : FM: Suppressing Blanks and Zeros
• symbols
• • != (not equals) : The PL/SQL Character Set
  • % (percent sign) : The PL/SQL Character Set
  • > (label delimeters) : The PL/SQL Character Set
  • >= (greater than) : The PL/SQL Character Set
  • <> (not equals) : The PL/SQL Character Set
  • <= (less than) : The PL/SQL Character Set
  • ** (double asterisk) : The PL/SQL Character Set
  • -- (comment indicator) : The PL/SQL Character Set
  • /* and */ (comment block delimiters) : The PL/SQL Character Set
  • ; (semicolon) : The PL/SQL Character Set
  • => (associational operator for positional notation) : The PL/SQL Character Set
  • \: (colon) : The PL/SQL Character Set
  • _ (underscore) : The PL/SQL Character Set
  • || (concatenation) operator : The PL/SQL Character Set
• synchronization : Synchronize Program and Data Structures
• synchronization with columns : Synchronization with database columns
• synonyms for stored objects : Creating Synonyms for Stored Objects
• SYS_NC_OID$ column : Object identifiers (OIDs)
• SYS_NC_ROWINFO$ column : Object identifiers (OIDs)
• SYSDATE function : The SYSDATE function
• • and NEW_TIME function : Using NEW_TIME in Client-Server Environments
• system
• • date : The SYSDATE function
  • exceptions : Named System Exceptions
• System Global Area (SGA)
• • pinning critical code into : Pin Critical Code into the SGA
  • tuning shared pool size : Tune the Size of the Shared Pool of the SGA