Database Reference
In-Depth Information
Figure 8.26
Output in
iSQL*Plus Is
Different from
SQL*Plus.
The most apparent difference between SQL*Plus and iSQL*Plus is
appearance. Columns are formatted in an HTML table layout, not just as
plain text. The page breaks are simply displayed as a repetition of the col-
umn headings. Scroll to the end of the report, and you will see the record
count displayed after the end of the table of report records.
8.4.1
Embedding Scripts in HTML
A cool feature is the ability to create an HTML document that calls
iSQL*Plus and runs a predefined report. You have already created a report
in a file named CDREPORT.SQL previously in this chapter. You can
embed this report into your own customized HTML document. This can
be run by anyone who can access your HTTP Server.
The HTTP Server runs iSQL*Plus by accessing the iSQL*Plus Server
process that is automatically configured within it. The iSQL*Plus Server is
running whenever your HTTP Server is running. The architecture that
should be used for iSQL*Plus is called a three-tier architecture and is com-
monly used with Web-based applications. The client tier is your Web
browser; the middle tier is the HTTP Server; and the database tier is the
Oracle Database 10
g
Server. Each of the three tiers can be located on sepa-
