Database Reference
In-Depth Information
8
Using SQL*Plus
In this chapter:
What are environmental settings for SQL*Plus formatting?
How are variables used in SQL*Plus?
How are scripts used in SQL*Plus?
How are reports formatted in SQL*Plus?
How is iSQL*Plus used for reporting?
This chapter shows you how to use the environmental settings, vari-
ables, and special SQL*Plus commands to generate acceptable output and
reports. Examples in this topic use both SQL*Plus Worksheet and
SQL*Plus. SQL*Plus Worksheet is more of an end-user tool. A final part of
this chapter shows some brief example use of iSQL*Plus.
Let's start by looking at some environmental settings.
8.1
Environmental Settings
An environmental variable is set for the duration of a session using the SET
command or as a default.
Note:
Defaults can be set for SQL*Plus in the GLOGIN.SQL configura-
tion file in the $ORACLE_HOME/sqlplus/admin directory.
The SET command changes the value of an environmental variable, and
the SHOW command displays its value. Detailed information on available
environmental variables is available in Oracle documentation.