Oracle PL/SQL: SQL*Plus Spool Command - To write the results of a query to a file.

Quick Search:

Oracle PL/SQL: SQL*Plus Spool Command

Jump to:

Snippet Name: SQL*Plus Spool Command

Description: To write the results of a query to a file.

Also see:
» SQL*Plus Configuration
» SQL*Plus SQL Prompt
» SQL*Plus Display commands
» SQL*Plus Describe
» SQL*Plus connect
» SQL*Plus formatting

Comment: It is important to 'spool off' when you are finished or you could write a very very large file.

Language:
Highlight Mode: PLSQL
Last Modified: March 07th, 2009

spool c:\temp\test1.txt
 
SELECT *
FROM user_tables;
 
spool off