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, 410👍, 0💬

Popular Posts:

CAST() - Converting ...

How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...

ROUND() - Rounding V...

How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...

Counting Rows with t...

How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...

What Is SQL in MySQL...

What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...