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>> SPOOL C:\dept.html
SQL>> SELECT * FROM dept;
SQL>> SPOOL OFF
0 responses so far ↓
There are no comments yet...Kick things off by filling out the form below.
Leave a Comment