Skip to main content

Oracle Spool Command (Output To File)

You can use Oracle SPOOL command to output of a query in SQL Plus in Oracle to an output file.


Below is an example.


SQL> Spool on
SQL> Spool c:\abc.log
SQL> Query
SQL> Spool off


Spool the output to a file without column names included.



SQL> Spool on
SQL> set heading off 
SQL> Spool c:\abc.log
SQL> Query
SQL> Spool off



Comments

Post a Comment

Popular posts from this blog

Setting ORACLE_SID

The  Oracle System ID  ( S ID ) is used to uniquely identify a particular database on a system How to set ORACLE_SID: Windows: set ORACLE_SID=orcl Unix/ Linux: export ORACLE_SID=orcl SID is case sensitive in Unix / Linux environments. How to check the current ORACLE_SID: Windows: Go to the commnand prompt and type as C:\> set ORACLE_SID (This will show if any ORACLE_SID is already set). C:\> set (To know all the parameters set) Unix/ Linux: echo $ORACLE_SID
1 comment
Read more