Thursday, July 15, 2010

Oracle: Spool to Excel from SQLPlus

Spooling the output from SQLPlus to log file is often in unreadable format.

To Spool SQLPLus output to Excel (.xls) file, the trick is to turn On "MARKUP HTML"

SQL>set markup html on
SQL>set feedback off

SQL>spool c:\test.xls

SQL>select * from user_objects where rownum <= 20;
SQL>spool off

SQL>set markup html off
Labels:

11 comments:

  1. AnonymousAugust 17, 2011 at 7:24 PM

    thanks

    ReplyDelete
  2. Oracle DBAFebruary 8, 2012 at 5:08 PM

    same post here :

    http://chandu208.blogspot.com/2012/01/spool-command.html

    ReplyDelete
  3. ShonyFebruary 21, 2012 at 9:23 PM

    See some examples here..
    http://shonythomas.blogspot.in/2011/07/export-and-create-excel-file-from.html

    ReplyDelete
  4. Santosh KatrathandaAugust 7, 2012 at 2:03 AM

    excellent....Thanks a lot :)

    ReplyDelete
  5. AnonymousOctober 18, 2012 at 10:31 PM

    Much useful info. Thank you!!.

    ReplyDelete
  6. HildaFebruary 13, 2013 at 2:58 AM

    Thanks a lot!!! :)

    ReplyDelete
  7. AnonymousMarch 19, 2013 at 1:33 PM

    very helpful.. Thanks..

    ReplyDelete
  8. AnonymousMarch 31, 2013 at 8:47 AM

    But the file is saved in HTML format.
    Opening this file in Excel will not pose any problem because Excel can read HTML format, but other software will return invalid file format.

    I had to open this file in Excel, then click SAVE AS XLS again.

    ReplyDelete
  9. AnonymousMay 31, 2013 at 9:33 AM

    Great info, thanks!

    ReplyDelete
  10. AnonymousJune 5, 2013 at 4:07 PM

    Worked, thank you!

    ReplyDelete
  11. AnonymousNovember 21, 2013 at 5:06 AM

    thanks

    ReplyDelete

Subscribe to: Post Comments (Atom)