Database Reference
In-Depth Information
Figure 1.16
Invoking
(Opening) the
Editor.
until you turn it off, or until you exit SQL*Plus. This is a handy
way to record your work. In addition, in Chapter 8, you will find
out how to write reports using this spooling technique. Navigate
to a directory of your choosing, such as C:\TEMP in Windows,
and then type “testing” as the file name and click Save. The file
will automatically receive a suffix of “.LST” on Windows and of
“.lis” on UNIX and other operating systems.
11.
Type / (a forward slash) to run the query. The forward slash and
the semi-colon both tell SQL*Plus to execute a command. The
forward slash must be used alone on a line by itself, whereas the
semi-colon is used at the end of a line of code. The semi-colon
terminates and submits a single-line SQL command to the data-
base. The forward slash does the same and additionally compiles
and executes blocked sections of PL/SQL code.
12.
The results scroll into the window as before.
13.
Type the letter L and press Enter. This is the LIST command of
SQL*Plus. It displays whatever SQL command is currently in the
SQL*Plus buffer.
14.
Select File/Spool/Spool off to end the spooling of data to the file.
This closes the file that has been receiving data from the
SQL*Plus session. Your spool file will be empty until this com-
mand is executed or you exit SQL*Plus.
 
Search WWH ::




Custom Search