How to spool a HTML report
732607Nov 6 2009 — edited Nov 6 2009Hi,
could you show me how I can set sqlplus in order to get a html report?
For example I've tried to write
set pagesize 1000
set scan off
set markup html on spool on head ' - '
COLUMN field_1 HEADING "Field number one"
COLUMN field_2 HEADING "Field number two"
SPOOL c:\temp\report.html
SELECT
field_1, field_2
from table;
spool off;
and I get a HTML file.
But I don't know how set for example the text colour.
I've tried to write:
set pagesize 1000
set scan off
set markup html on spool on head ' - '
BODY 'TEXT="#FF00FF"' -
and I get
SP2-0735: unknown SET option beginning "TEXT="#FF0..."
<br>
SQL>
Can you help me with the right sintax to use?
Thanks