Spool sql query output to HTML - Oracle Database Script. -- We can spool output of an sql query to html format: 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 report.html Select * from scott.emp; spool off exit
-- We can spool output of an sql query to html format: 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 report.html Select * from scott.emp; spool off exit