Quick Search:
 Oracle PL/SQL: SQL*Plus Spool Command Jump to:  
Category: >> Oracle PL/SQL >> SQL*Plus Spool Command  

<< lastnext >>

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.

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

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

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org