Spool to excel
Is there any ways to spool the results to an excel file format rather than a text format?
You can try with csv file and then open with excel...
select empno||';'||ename||';'||job||';'||mgr||';' from emp;
Or you can make an ODBC connection to your database via Excel to return the results directly to the spreadsheet.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
or you can go to asktom.oracle.com and search for sylk package it will do it for you. I have it somewhere home and I used it ok , works fine.........
CSV will do it too but sylk had the capability of changing fonts , colors, headers , etc.............a way cooler
Click Here to Expand Forum to Full Width