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 /tmp/spool.log

SQL>select * from dba_objects;
SQL>spool off

SQL>set markup html off

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s