📋Steps in this guide1/1

Spool sql query output to HTML

We can spool output of an sql query to html format:

oracle configurationintermediate

by OracleDba

12 views

Spool sql query output to HTML

We can spool output of an sql query to html format:

Code/Command (click line numbers to comment):

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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!