Wednesday 29 June 2011

Redirecting the output from Oracle SQL to a Text File

Steps:
i) Create a text file and copy that Location.
ii) In SQL Editor, to enable spooling the buffer to text file,
Give the Command like
SQL> SPOOL <File path>
SQL> Run your queries here
If You are finished with querying,
SQL> SPOOL off

Go, find the SQL query output in the text file.

No comments:

Post a Comment