Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to spool a HTML report

732607Nov 6 2009 — edited Nov 6 2009
Hi,
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
This post has been answered by Peter Gjelstrup on Nov 6 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2009
Added on Nov 6 2009
6 comments
676 views