Sql*Plus User’s Guide and Reference

Partners $13,500
********** --------------
sum $27,500
90 King $24,000
Kochhar $17,000
De Haan $17,000
********** --------------
sum $58,000
--------------
sum $98,500
COMPANY CONFIDENTIAL
6 rows selected.

---

7
Generating HTML Reports from SQL*Plus
7-1
7
 Generating HTML Reports from SQL*Plus
This chapter explains how to generate a HTML report containing your query results. 
This chapter covers the following topics:
■
Creating Reports using Command-line SQL*Plus
Creating Reports using Command-line SQL*Plus
In addition to plain text output, the SQL*Plus command-line interface enables you to 
generate either a complete web page, or HTML output which can be embedded in a 
web page. You can use SQLPLUS -MARKUP "HTML ON" or SET MARKUP HTML 
ON SPOOL ON to produce complete HTML pages automatically encapsulated with 
and tags. 
By default, data retrieved with MARKUP HTML ON is output in HTML, though you 
can optionally direct output to the HTML 
tag so that it displays in a web 
browser exactly as it appears in SQL*Plus. See the SQLPLUS 
MARKUP Options
 on 
page 3-7 and the 
SET
MARKUP command on page 12-88 for more information about 
these commands.
SQLPLUS -MARKUP "HTML ON" is useful when embedding SQL*Plus in
program scripts. On starting, it outputs the HTML and BODY tags before executing 
any commands. All subsequent output is in HTML until SQL*Plus terminates. 
The -SILENT and -RESTRICT command-line options may be effectively used with 
-MARKUP to suppress the display of SQL*Plus prompt and banner information, and 
to restrict the use of some commands.
SET MARKUP HTML ON SPOOL ON generates an HTML page for each subsequently 
spooled file. The HTML tags in a spool file are closed when SPOOL OFF is executed or 
SQL*Plus exits.
You can use SET MARKUP HTML ON SPOOL OFF to generate HTML output suitable 
for embedding in an existing web page. HTML output generated this way has no 
or  tags.