An Oracle blog – Amardeep Sidhu

June 16, 2007

Spool to a .xls (excel) file…

Filed under: Oracle Tips,SQL — Sidhu @ 12:14 am
Tags: ,

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

Theme: Rubric. Get a free blog at WordPress.com

%d bloggers like this: