This information for the guys who are new to SQL*Plus.

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 following two ways:

1. From command line when opening sqlplus specifying -MARKUP “HTML ON” as parameters

Example:

C:\>SQLPLUS -MARKUP “HTML ON”

2. From SQL*Plus, through “SET MARKUP HTML ON” command.

Example:

SQL> SET MARKUP HTML ON

SQL&gt> SPOOL C:\dept.html

SQL&gt> SELECT * FROM dept;

SQL&gt> SPOOL OFF