Converting Reports to HTML
Both Oracle Reports 6.0/6.i and SQL*Plus are capable of creating Web-based reports.
Listing 6.2 enhances the ST_INVENTORY_DETAIL report shown in Listing 6.1 by adding just a couple of lines. Notice the final SET command, SET MARKUP HTML ON. This takes the output report and puts it in HTML format. The only other change to this program over that of Listing 6.1 is the SPOOL command; notice the .htm suffix, this will make the file easily accessable by web browsers. Figure 6.22 illustrates what the output looks like in a Web browser.
Figure 6.22. SQL*Plus Web Report ST_INVENTORY_DETAIL.
Listing 6.2. Web-Based ST_INVENORY_DETAIL.SQL ...
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
