Script to spool SQL query output to HTML

set pages 5000
SET MARKUP HTML ON
SPOOL ON PREFORMAT OFF ENTMAP ON –
HEAD “<TITLE>EMPLOYEE REPORT</TITLE> –
<STYLE type=’text/css’> –
<!– BODY {background: #FFFFC6} –> –
</STYLE>” –
BODY “TEXT=’#FF00Ff'” –
TABLE “WIDTH=’90%’ BORDER=’5′”
spool db_info.html
Select name,open_mode from v$database;
spool off
Exit