<<Previous Next>>
Oracle - What
is Output Spooling in SQL*Plus? - April 10, 2009
at 11:00 AM
What is Output Spooling in
SQL*Plus?
The spooling feature facilitates copying of all the contents of
the command line SQL*Plus to a specified file. This feature is
called Spooling.
Syntax:
SPOOL filename: Turns on output spooling with the specified
file.
SPOOL OFF: Turns off output spooling
and close the spool file.
Also read
The SET command can be used to change the settings in the
SQl*PLUS environment : SET AUTOCOMMIT OFF: Turns off the auto-commit
feature, SET FEEDBACK OFF............
The behaviour of SQL PLUS depends on some environmental variables
predefined in the OS: ORACLE_HOME: This variable stores the home
directory where the Oracle client.............
The spooling feature facilitates copying of all the contents of
the command line SQL*Plus to a specified file. This feature is
called Spooling............
Input buffer feature of the command-line SQL*Plus tool allows a
revision of multiple-line command and rerunning it with a couple of simple commands. The last SQL statement
is............
|
