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.

⇒ 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, 4475🔥, 0💬

Revise and Rerun the Last SQL Command in Oracle
How To Revise and Re-Run the Last SQL Command in Oracle? If executed a long SQL statement, found a mistake in the statement, and you don't want enter that long statement again, you can use the input buffer commands to the correct last statement and re-run it. The following tutorial exercise gives yo... 2020-07-15, 7937🔥, 0💬

SQL*Plus Commands Stored in a File in Oracle
How Run SQL*Plus Commands That Are Stored in a Local File in Oracle? If you have a group of commands that you need to run them repeatedly every day, you can save those commands in a file (called SQL script file), and using the "@fileName" command to run them in SQL*Plus. If you want to try this, cre... 2020-06-08, 5738🔥, 0💬

Use SQL*Plus Built-in Timer in Oracle
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measure elapsed periods of time, you can SQL*Plus Built-in Timers with the following commands: TIMING - Displays number of timers. TIMING START [name] - Starts a new timer with or without a name. TIMING SH... 2020-06-08, 5377🔥, 0💬

Input Buffer in SQL*Plus in Oracle
What Is Input Buffer in SQL*Plus in Oracle? Input buffer is a nice feature of the command-line SQL*Plus tool. It allows you to revise a multiple-line command and re-run it with a couple of simple commands. By default, input buffer is always turned on in SQL*Plus. The last SQL statement is always sto... 2020-07-15, 5018🔥, 0💬

Save Query Output to a Local File in Oracle
How To Save Query Output to a Local File in Oracle? Normally, when you run a SELECT statement in SQL*Plus, the output will be displayed on your screen. If you want the output to be saved to local file, you can use the "SPOOL fileName" command to specify a local file and start the spooling feature. W... 2020-07-15, 4687🔥, 0💬

Generate Query Output in HTML Format in Oracle
How To Generate Query Output in HTML Format in Oracle? If you want your query output to be generated in HTML format, you can use the "SET MARKUP HTML ON" to turn on the HTML feature. The following tutorial exercise gives you a good example: SQL> connect HR/retneciyf SQL> SET MARKUP HTM... 2020-07-15, 4507🔥, 0💬

Output Spooling in SQL*Plus in Oracle
What Is Output Spooling in SQL*Plus in Oracle? 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 dat... 2020-07-15, 4476🔥, 0💬

SQL*Plus Environment Variables in Oracle
What Are SQL*Plus Environment Variables in Oracle? Behaviors of SQL*Plus are also controlled a some environment variables predefined on the local operating system. Here are some commonly used SQL*Plus environment variables: ORACLE_HOME - The home directory where your Oracle client application is ins... 2020-07-22, 4294🔥, 0💬

Run PL/SQL Statements in SQL*Plus in Oracle
How To Run PL/SQL Statements in SQL*Plus in Oracle? If you want to run a single PL/SQL statement in SQL*Plus, you need to use the EXECUTE command as shown in the following tutorial example: SQL> SET SERVEROUTPUT ON SQL> EXECUTE DBMS_OUTPUT.PUT_LINE('Welcome to FYIcenter!') Welcome to F... 2020-07-22, 4188🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.