Oracle - Output Spooling in SQL*Plus in Oracle

Output Spooling in SQL*Plus in Oracle

Q

What Is Output Spooling in SQL*Plus in Oracle?

✍: FYIcenter.com

A

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.

⇒Introduction to Command-Line SQL*Plus Client Tool

⇒⇒Oracle Database Tutorials

2016-10-17, 192👍, 0💬

Popular Posts:

Ending Stored Proced...

How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...

OUTPUT - Defining Ou...

How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored p...

CONTINUE to Next Loo...

How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...

Selecting Some Speci...

How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...