Oracle DBA FAQ‎ > ‎

How DBA can generate static HTML pages from SQL*Plus

posted Sep 10, 2010, 1:33 PM by Sachchida Ojha
One can generate static HTML pages from SQL*Plus (8.1.6 and above) by setting the MARKUP option to HTML ON. This can be done by specifying -MARKUP "HTML ON" from command line, or with the "SET MARKUP HTML ON" command. Look at this example SQL Script:
set markup HTML on
spool index.html
select * from tab;
spool off
set markup HTML off
Comments