Basic Oracle Concepts and Programming Question:
Download Questions PDF

What Is Output Spooling in SQL*Plus?

Answer:

The output spooling a nice feature of the command-line SQL*Plus tool. If the spooling feature is turned on, SQL*Plus will send a carbon copy of the everything on your screen to a specified local file.

Output spooling is used mostly for quick dump of data to local files. Here are the commands to turn on and off output spooling in SQL*Plus:

* SPOOL fileName - Turning on output spooling with the specified file.
* SPOOL OFF - Turning off output spooling and close the spool file.


Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Generate Query Output in HTML Format?How To Save Query Output to a Local File?