Oracle® Web Application Programming for PL/SQL® Developers

Unit 16.2. HTML Utilities

Unit Objectives

After this unit, you will know how to:

• Generate an HTML Select List from a SQL Query

• Generate a Signature Line on an HTML Document

• View the Source Code of a Procedure, Function, or Package in the Browser

• Print Out the HTML Output of a Procedure in SQL*Plus, SQL*DBA, or Oracle Server Manager

Generate an HTML Select List from a SQL Query

The owa_util.listprint procedure generates an HTML selection list form element from the output of a SQL query. The columns in the output of the query are handled as follows:

• The first column specifies the values to be used in the SELECT list. These values are supplied to the VALUE attribute of the OPTION tag.

• The second column specifies the displayed values; those that the ...