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

Index: S

• save procedure : Saving and restoring settings
• savepoints : Setting Savepoints
• • PLVlog : How PLVlog manages the transaction
• savesrc procedure : Saving and restoring repository settings
• savetrg procedure : Saving and restoring repository settings
• saving
• • message text : Storing Message Text
  • PL/SQL objects : Saving and Restoring the Current Object
  • repository settings
  • • Saving and Restoring Settings
    • Saving and restoring repository settings
  • table settings : Saving and restoring settings
  • viewing stored code : PLVvu: Code and Error Viewing
• saving_src function : Saving and restoring repository settings
• saving_trg function : Saving and restoring repository settings
• scanning strings : Scanning PL/SQL strings
• schema : (see DDL)
• schema procedure : Dumping the DDL
• schemas, PLVdyn and : Executing PLVdyn in Different Schemas
• scope : Broadening the Scope
• scripts : (see code)
• searching for help text : Locating Text in the Data Dictionary
• searching for source code : How to Find Source Code
• security : Isolate volatile areas of functionality
• • access : (see access)
  • transaction integrity : Guaranteeing Transaction Integrity
• SELECT statement
• • Isolate volatile areas of functionality
  • Viewing the Current Source SELECT
• sendto procedure
• • Selecting the log type
  • Selecting the Log Type
• seq procedure : Dumping the DDL
• server, allowing file access to : Enabling File Access in the Oracle Server
• SET PAGESIZE command : Page Pausing with PLVhlp.more
• SET PAUSE ON command : Page Pausing with PLVhlp.more
• SET SERVEROUTPUT command : Displaying Dates
• set_author procedure
• • Setting the author
  • Setting the Code Author
• set_context procedure : Setting the context
• set_datemask function : Setting the PL/Vision Date Mask
• set_datemask procedure : Setting the date format mask
• set_dbtab procedure
• • Managing the log
  • Defining the database log table
• set_delim procedure
• • Setting the operating system delimiter
  • Setting the Operating System Delimiter
• set_dir procedure
• • Setting the default directory or location
  • Setting the Default Directory
• set_factor procedure
• • Setting the factoring value
  • Setting the Timing Factor
• set_id_default procedure
• • Setting the PLVfk configuration
  • Setting column name defaults
• set_indent procedure : Indentation in PLVgen
• set_line_limit procedure
• • Managing the source WHERE clause
  • Setting a Line Limit
• set_linesep procedure
• • Setting the line separator
  • The Line Separator
• set_name procedure : Setting Individual Elements of Current Object
• set_nm_default procedure
• • Setting the PLVfk configuration
  • Setting column name defaults
• set_nullval function : Null Substitution Value
• set_nullval procedure : Setting the NULL substitution value
• set_object procedure : How to Find Source Code
• set_overlap procedure
• • Setting the overlap
  • Setting the Code Overlap
• set_pagesize procedure
• • Setting the page size
  • Setting the Page Size
• set_prefix procedure
• • Setting the line prefix
  • Setting the row prefix
  • The Output Prefix
  • Setting the Display Prefix
• set_repeats procedure : Setting the repetition value
• set_savepoint procedure
• • Managing savepoints
  • Setting Savepoints
• set_schema procedure : Setting Individual Elements of Current Object
• set_sp procedure
• • Rolling back in PLVlog
  • Setting the post-insert savepoint
• set_srcwhere procedure
• • Managing the source WHERE clause
  • Changing the WHERE Clause
• set_type procedure : Setting Individual Elements of Current Object
• set_vclen procedure
• • Setting the PLVfk configuration
  • Setting the default string length
• setcase script : Script to Convert Programs
• setcurr procedure : Setting the Current Object
• setsrc procedure
• • Managing the source repository
  • String Source or Target
  • Setting the Source
  • Using setsrc and initsrc
• settrg procedure
• • Managing the target repository
  • Managing the Target Repository
• setup.exe file : Beginning the Installation
• SGA (System Global Area)
• • The Memory-Resident Architecture of Packages
  • The Initialization Section
  • DBMS_PIPE package and : Leveraging builtin packages
• shared memory : (see memory)
• SHARED_POOL_SIZE constant : Managing packages in shared memory
• sharing PL/Vision : Granting Access to PL/Vision
• SHOW ERRORS command : What SHOW ERRORS Does
• show procedure
• • Showing the Help Text
  • Displaying an activity trace
  • Constructing an Online Help Package
  • Tracing Code Execution
  • Showing errors
• show_elapsed procedure
• • Retrieving and displaying elapsed time
  • show_elapsed Procedure
• show_string procedure : Other functions and procedures
• show_table procedure : Other functions and procedures
• showblk procedure : Toggle for showing blanks in row
• showcurr procedure
• • Accessing the current object
  • Displaying the Current Object
• showecs procedure
• • Accessing the PLVtrc execution call stack (ECS)
  • Displaying the stack
• showerr procedure : (see err procedure)
• showhdr procedure : Toggle for showing header
• showhelp procedure : Building a SQL*Plus Help Script
• showing function
• • Tracing PLVdyn activity
  • Tracing Use of Dynamic SQL
  • Showing errors
• showing_header function : Toggle for showing header
• showing_row function : Toggle for showing row numbers
• showlog.sql script : Retrieving log data from PL/SQL table
• showrow procedure : Toggle for showing row numbers
• showsql procedure
• • Tracing PLVdyn activity
  • Tracing Use of Dynamic SQL
• shutting down programs : Bailing Out with PLVexc
• size
• • message text : Using PLVmsg in PL/Vision
  • online documentation page
  • • Setting the Page Size
    • Maintaining the current page variables
  • online help page : Setting the page size
  • package : Working with Large Packages
  • source WHERE clause : Setting a Line Limit
• SLEEP procedure : futile first effort
• "snapshot too old" error : Commit processing challenges
• snapshot_too_old exception : Package-based exceptions
• SNAPSHOT_TOO_OLD exception : Package-Based Exceptions
• software : (see code)
• source code : (see code)
• source repository
• • Source and target repository type functions
  • Managing the Source Repository
  • Reading From the Source
  • Closing the Source
• source WHERE clause : The Source WHERE Clause
• sp_timer package
• • The Package Body
  • PLVtmr: Analyzing Program Performance
• space : (see memory)
• specification, package
• • The Package Specification
  • Building Packages
• speed : (see performance)
• SQL language
• • building applications on : What Are the Types and Layers of Packages?
  • calling functions in : Calling Packaged Functions in SQL
• SQL statements : Isolate volatile areas of functionality
• SQL*Plus
• • compiling code in : Compiling PL/SQL Code in SQL*Plus
  • help script : Building a SQL*Plus Help Script
  • initializing : PL/Vision Initialization Script for SQL*Plus
  • scripts included on disk : Summary of Files on Disk
• SQLERRM function : Obtaining the Error Message
• src2trg procedure
• • Miscellaneous PLVio programs
  • Batch Transfer of Source to Target
• srcselect function
• • Managing the source repository
  • Viewing the Current Source SELECT
• stacks
• • PLVstk: Stack Manager
  • Accessing the PL/SQL call stack
  • ECS : Accessing the PLVtrc execution call stack (ECS)
  • PLVtrc execution : The PLVtrc Program Stack
  • PL/SQL call : Accessing the PL/SQL Call Stack
• standalone elements, bundling into packages : Clean up a bewildering mass of standalone functions and procedures
• standard output : Standard Output Target
• STANDARD package : What Is a PL/SQL Package?
• standards, coding : The Benefits of PL/Vision
• start time (timer) : Capturing the Start Time
• startcmnt function : Functions to scan USER_SOURCE
• starts_multiline_comment function : Analyzing PL/SQL string content
• startup procedure
• • Tracing PL/SQL code execution
  • startup
  • Integrating PLVexc with PLVtrc
• std_delimiters constant : Package constants
• stdout constant : PL/Vision constants
• stg_with_ln function : Modularization inside put_line
• stop procedure
• • Exception handlers
  • The high-level handlers
  • Halting in PLVexc
• stopping bailout process : Starting and stopping the bailout
• stopping programs : Halting in PLVexc
• stored code : PLVvu: Code and Error Viewing
• string constant : PL/Vision constants
• string procedure
• • Case-converting programs
  • Case-converting programs
  • Parsing strings
  • string procedures
  • Converting a string
• string_repostype TYPE : String Source or Target
• strings : PLVlex: Lexical Analysis
• • changing case of : (see capitalization)
  • code repository : String Source or Target
  • converting : Converting Boolean to String
  • counting atomics of : numatomics function
  • output prefix : The Output Prefix
  • parsing
  • • PLVprs: String Parsing
    • PLVprs, PLVtkn, and PLVprsps: Parsing Strings
  • string functions : Default values for string functions
  • SUBSTR function : Builtin Functions
  • wrapping : Wrapping Strings into Paragraphs
• stripped function : Other functions and procedures
• stubs
• • help text : Help text stub generators
  • generating stubs : (see documentation, online help)
• substitution value for NULL
• • Setting the NULL substitution value
  • Null Substitution Value
• SUBSTR function
• • Builtin Functions
  • nth_atomic function
• substrings (see strings)
• suffixes
• • file : Organizing Package Source Code
  • package element names : Avoiding Superfluous Naming Elements
• syn procedure : Dumping the DDL
• synonyms, package : Granting Access to PL/Vision
• System Global Area : (see SGA)