Articles

Solved Oracle spool output to file

May 10, 2006 at 13:03:33
Specs: Unix, 1GB

Hi,

I'm trying to spool the output of my query in SQL Plus in Oracle to an output file. But, it includes column names before each row. Is there a way to spool the output to a file without column names included.

I'm using following set of commands:

SQL> Spool on
SQL> Spool c:\spooltext.txt
SQL> Query
SQL> Spool off

Please guide me as to what steps needs to be executed to avoid column headers.

Thanks,
Anil


See More: Oracle spool output to file

Report •


#1
June 1, 2006 at 11:00:40
✔ Best Answer

SQL> Spool on
SQL> set heading off <===
SQL> Spool c:\spooltext.txt
SQL> Query
SQL> Spool off

Luke Chi


Report •
Related Solutions


Ask Question