Book HomeBook HomeSearch this book

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)


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
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