DanBrother的部落格

One thing neat about SQL*Plus is that it can even generate HTML file in addition to text file.

Here's the example:

sqlplus_to_html.sql

>> 

------------------------------------------------------------------------------------------------------------------

SET FEEDBACK OFF

SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP OFF

SPOOL D:\report.html

select '<FONT COLOR="RED">'||table_name||'</FONT>' "TABLE_NAME",'<FONT COLOR="BLUE">'||owner||'</FONT>' "OWNER"

from all_tables where owner = 'SYS' and rownum <=10;

SPOOL OFF

------------------------------------------------------------------------------------------------------------------

SQL> @D:\sqlplus_to_html.sql

Double click on D:\report.html to view the result:

ps. "ENTMAP OFF" disables the substitution of HTML entities