Spool to a .xls (excel) file…
Posted by Sidhu on 16th June 2007
A small tip, I read on OTN about spooling to a .xls (excel) file:
It goes like this
set feed off markup html on spool onspool c:\salgrade.xls select * from salgrade; spool offset markup html off spool off
And the xls it makes shows up like:
Sidhu
Posted in Oracle Tips, SQL | 7 Comments »