Database Reference
In-Depth Information
Figure 8.23
The Report
Displays a Count of
Songs per CD.
Figure 8.23 shows part of the results. Because we did not specify a label,
the word “count” is displayed in the first column, and the count is listed in
the column that was counted (SONGTITLE).
You have seen how to generate a report with summaries, breaks, custom-
ized headings, and variables. Now let's examine the report-generating possi-
bilities in another SQL*Plus tool, iSQL*Plus.
8.4
Using iSQL*Plus
As you know, iSQL*Plus is the Web-based version of SQL*Plus. It gives
you a way to write queries and other SQL commands via the Internet or
across a network, in a Web browser. An Oracle installation comes with a
miniature Web server, called HTTP Server, and is configured automatically
by Oracle Installer.
The HTTP Server that is provided as part of Oracle is usually automati-
cally started when you start up your computer. If not, you can start it up
yourself. In Windows, on the task bar, click
Start/Programs/Oracle -
OraHome10/Oracle HTTP Server/Start HTTP Server powered by
