Output Spooling in SQL*Plus in Oracle


What Is Output Spooling in SQL*Plus in Oracle?

✍: FYIcenter.com


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.


Save Query Output to a Local File in Oracle

Generate Query Output in HTML Format in Oracle

Introduction to Command-Line SQL*Plus Client Tool

⇑⇑ Oracle Database Tutorials

2020-07-15, 2240🔥, 0💬