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 : 5.25.7. Saving and restoring settings

savepoints : 20.2.3. Setting Savepoints

PLVlog : 21.1.5.2. How PLVlog manages the transaction

savesrc procedure : 5.15.8. Saving and restoring repository settings

savetrg procedure : 5.15.8. Saving and restoring repository settings

saving

message text : 9.2. Storing Message Text

PL/SQL objects : 11.3.4. Saving and Restoring the Current Object

repository settings

12.8. Saving and Restoring Settings

5.15.8. Saving and restoring repository settings

table settings : 5.25.7. Saving and restoring settings

viewing stored code : 5.29. PLVvu: Code and Error Viewing

saving_src function : 5.15.8. Saving and restoring repository settings

saving_trg function : 5.15.8. Saving and restoring repository settings

scanning strings : 5.16.2. Scanning PL/SQL strings

schema : (see DDL)

schema procedure : 5.8.3. Dumping the DDL

schemas, PLVdyn and : 19.5.10. Executing PLVdyn in Different Schemas

scope : 3.8. Broadening the Scope

scripts : (see code)

searching for help text : 17.5.2. Locating Text in the Data Dictionary

searching for source code : 15.4.1. How to Find Source Code

security : 1.6.1.5. Isolate volatile areas of functionality

access : (see access)

transaction integrity : 1.3.5. Guaranteeing Transaction Integrity

SELECT statement

1.6.1.5. Isolate volatile areas of functionality

12.4.1. Viewing the Current Source SELECT

sendto procedure

5.17.3. Selecting the log type

21.1.3. Selecting the Log Type

seq procedure : 5.8.3. Dumping the DDL

server, allowing file access to : 13.1.1. Enabling File Access in the Oracle Server

SET PAGESIZE command : 17.5.6. Page Pausing with PLVhlp.more

SET PAUSE ON command : 17.5.6. Page Pausing with PLVhlp.more

SET SERVEROUTPUT command : 7.1.2. Displaying Dates

set_author procedure

5.13.3. Setting the author

16.3.2. Setting the Code Author

set_context procedure : 22.3.3.2. Setting the context

set_datemask function : 6.2. Setting the PL/Vision Date Mask

set_datemask procedure : 5.3.3. Setting the date format mask

set_dbtab procedure

5.17.6. Managing the log

21.1.3.1. Defining the database log table

set_delim procedure

5.11.3. Setting the operating system delimiter

13.2.1. Setting the Operating System Delimiter

set_dir procedure

5.11.4. Setting the default directory or location

13.2.2. Setting the Default Directory

set_factor procedure

5.27.3. Setting the factoring value

14.3.3. Setting the Timing Factor

set_id_default procedure

5.12.2. Setting the PLVfk configuration

19.6.2.1. Setting column name defaults

set_indent procedure : 16.3.1. Indentation in PLVgen

set_line_limit procedure

5.15.5. Managing the source WHERE clause

12.4.3. Setting a Line Limit

set_linesep procedure

5.2.2. Setting the line separator

7.2. The Line Separator

set_name procedure : 11.3.1. Setting Individual Elements of Current Object

set_nm_default procedure

5.12.2. Setting the PLVfk configuration

19.6.2.1. Setting column name defaults

set_nullval function : 6.1. Null Substitution Value

set_nullval procedure : 5.3.4. Setting the NULL substitution value

set_object procedure : 15.4.1. How to Find Source Code

set_overlap procedure

5.29.2. Setting the overlap

15.2.2. Setting the Code Overlap

set_pagesize procedure

5.14.2. Setting the page size

17.4.2. Setting the Page Size

set_prefix procedure

5.2.3. Setting the line prefix

5.25.6. Setting the row prefix

7.3. The Output Prefix

8.5. Setting the Display Prefix

set_repeats procedure : 5.27.2. Setting the repetition value

set_savepoint procedure

5.23.4. Managing savepoints

20.2.3. Setting Savepoints

set_schema procedure : 11.3.1. Setting Individual Elements of Current Object

set_sp procedure

5.17.7. Rolling back in PLVlog

21.1.5.7. Setting the post-insert savepoint

set_srcwhere procedure

5.15.5. Managing the source WHERE clause

12.4.2. Changing the WHERE Clause

set_type procedure : 11.3.1. Setting Individual Elements of Current Object

set_vclen procedure

5.12.2. Setting the PLVfk configuration

19.6.2.2. Setting the default string length

setcase script : 18.1.2. A Script to Convert Programs

setcurr procedure : 11.3. Setting the Current Object

setsrc procedure

5.15.4. Managing the source repository

12.2.1. String Source or Target

12.3.1. Setting the Source

12.3.3. Using setsrc and initsrc

settrg procedure

5.15.6. Managing the target repository

12.5. Managing the Target Repository

setup.exe file : 4.3.3. Beginning the Installation

SGA (System Global Area)

1.4.3. The Memory-Resident Architecture of Packages

1.6.3. The Initialization Section

DBMS_PIPE package and : 1.5.1.1. Leveraging builtin packages

shared memory : (see memory)

SHARED_POOL_SIZE constant : 1.4.3.1. Managing packages in shared memory

sharing PL/Vision : 4.3.6. Granting Access to PL/Vision

SHOW ERRORS command : 15.1.2. What SHOW ERRORS Does

show procedure

17.4.1. Showing the Help Text

5.28.7. Displaying an activity trace

17.5.5. Constructing an Online Help Package

21.2.3. Tracing Code Execution

22.1.7.2. Showing errors

show_elapsed procedure

5.27.5. Retrieving and displaying elapsed time

14.3.2. show_elapsed Procedure

show_string procedure : 5.6.3. Other functions and procedures

show_table procedure : 5.6.3. Other functions and procedures

showblk procedure : 5.25.5. Toggle for showing blanks in row

showcurr procedure

5.20.4. Accessing the current object

11.3.3. Displaying the Current Object

showecs procedure

5.28.8. Accessing the PLVtrc execution call stack (ECS)

21.2.4.6. Displaying the stack

showerr procedure : (see err procedure)

showhdr procedure : 5.25.3. Toggle for showing header

showhelp procedure : 17.5.4. Building a SQL*Plus Help Script

showing function

5.9.1. Tracing PLVdyn activity

19.5.9. Tracing Use of Dynamic SQL

22.1.7.2. Showing errors

showing_header function : 5.25.3. Toggle for showing header

showing_row function : 5.25.4. Toggle for showing row numbers

showlog.sql script : 21.1.4.2. Retrieving log data from PL/SQL table

showrow procedure : 5.25.4. Toggle for showing row numbers

showsql procedure

5.9.1. Tracing PLVdyn activity

19.5.9. Tracing Use of Dynamic SQL

shutting down programs : 22.1.10. Bailing Out with PLVexc

size

message text : 9.5.1. Using PLVmsg in PL/Vision

online documentation page

17.4.2. Setting the Page Size

17.5.6.4. Maintaining the current page variables

online help page : 5.14.2. Setting the page size

package : 1.6.4. Working with Large Packages

source WHERE clause : 12.4.3. Setting a Line Limit

SLEEP procedure : 17.5.6.1. A futile first effort

"snapshot too old" error : 20.1.1.1. Commit processing challenges

snapshot_too_old exception : 5.10.2. Package-based exceptions

SNAPSHOT_TOO_OLD exception : 22.1.2. Package-Based Exceptions

software : (see code)

source code : (see code)

source repository

5.15.3. Source and target repository type functions

12.3. Managing the Source Repository

12.6. Reading From the Source

12.9.1. Closing the Source

source WHERE clause : 12.4. The Source WHERE Clause

sp_timer package

1.6.2. The Package Body

14. PLVtmr: Analyzing Program Performance

space : (see memory)

specification, package

1.4.1. The Package Specification

1.6. Building Packages

speed : (see performance)

SQL language

building applications on : 1.2. What Are the Types and Layers of Packages?

calling functions in : 1.6.5. Calling Packaged Functions in SQL

SQL statements : 1.6.1.5. Isolate volatile areas of functionality

SQL*Plus

compiling code in : 15.1. Compiling PL/SQL Code in SQL*Plus

help script : 17.5.4. Building a SQL*Plus Help Script

initializing : 4.4.2. A PL/Vision Initialization Script for SQL*Plus

scripts included on disk : 4.6. Summary of Files on Disk

SQLERRM function : 6.4.2. Obtaining the Error Message

src2trg procedure

5.15.9. Miscellaneous PLVio programs

12.7.2. Batch Transfer of Source to Target

srcselect function

5.15.4. Managing the source repository

12.4.1. Viewing the Current Source SELECT

stacks

5.24. PLVstk: Stack Manager

5.28.5. Accessing the PL/SQL call stack

ECS : 5.28.8. Accessing the PLVtrc execution call stack (ECS)

PLVtrc execution : 21.2.4. The PLVtrc Program Stack

PL/SQL call : 21.2.2. Accessing the PL/SQL Call Stack

standalone elements, bundling into packages : 1.6.1.1. Clean up a bewildering mass of standalone functions and procedures

standard output : 12.2.5. Standard Output Target

STANDARD package : 1.1. What Is a PL/SQL Package?

standards, coding : 4.1.1. The Benefits of PL/Vision

start time (timer) : 14.2. Capturing the Start Time

startcmnt function : 17.5.3.1. Functions to scan USER_SOURCE

starts_multiline_comment function : 5.16.1. Analyzing PL/SQL string content

startup procedure

5.28.6. Tracing PL/SQL code execution

21.2.4.1. startup

22.1.6.5. Integrating PLVexc with PLVtrc

std_delimiters constant : 5.21.1. Package constants

stdout constant : 5.3.1. PL/Vision constants

stg_with_ln function : 16.4.3.3. Modularization inside put_line

stop procedure

5.10.6. Exception handlers

22.1.6.2. The high-level handlers

22.1.9. Halting in PLVexc

stopping bailout process : 22.1.10.2. Starting and stopping the bailout

stopping programs : 22.1.9. Halting in PLVexc

stored code : 5.29. PLVvu: Code and Error Viewing

string constant : 5.3.1. PL/Vision constants

string procedure

5.4.2. Case-converting programs

5.4.2. Case-converting programs

5.21.4. Parsing strings

10.1.3.5. string procedures

18.1.1.2. Converting a string

string_repostype TYPE : 12.2.1. String Source or Target

strings : 5.16. PLVlex: Lexical Analysis

changing case of : (see capitalization)

code repository : 12.2.1. String Source or Target

converting : 6.4.1. Converting Boolean to String

counting atomics of : 10.1.3.3. numatomics function

output prefix : 7.3. The Output Prefix

parsing

5.21. PLVprs: String Parsing

10. PLVprs, PLVtkn, and PLVprsps: Parsing Strings

string functions : 16.2.3.3. Default values for string functions

SUBSTR function : A.2.5. Builtin Functions

wrapping : 10.1.4. Wrapping Strings into Paragraphs

stripped function : 5.6.3. Other functions and procedures

stubs

help text : 5.14.3. Help text stub generators

generating stubs : (see documentation, online help)

substitution value for NULL

5.3.4. Setting the NULL substitution value

6.1. Null Substitution Value

SUBSTR function

A.2.5. Builtin Functions

10.1.3.4. nth_atomic function

substrings (see strings)

suffixes

file : 2.4. Organizing Package Source Code

package element names : 2.3.3. Avoiding Superfluous Naming Elements

syn procedure : 5.8.3. Dumping the DDL

synonyms, package : 4.3.6. Granting Access to PL/Vision

System Global Area : (see SGA)

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