Oracle and more - Amardeep Sidhu

My experiences with technology…

Archive for June 16th, 2007

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 »