Create HTML List tags : HTP « System Packages « Oracle PL/SQL Tutorial

SQL>
SQL>
SQL> CREATE OR REPLACE PROCEDURE list_tables IS
  2     CURSOR cur_tables IS
  3        SELECT table_name
  4        FROM   user_tables
  5        ORDER BY table_name;
  6  BEGIN
  7     HTP.HTMLOPEN;
  8     HTP.HEADOPEN;
  9     HTP.TITLE('Display a List');
 10     HTP.HEADCLOSE;
 11     HTP.BODYOPEN;
 12     HTP.ULISTOPEN;
 13        FOR cur_tables_rec IN cur_tables LOOP
 14           HTP.LISTITEM(cur_tables_rec.table_name);
 15        END LOOP;
 16     HTP.ULISTCLOSE;
 17     HTP.BODYCLOSE;
 18     HTP.HTMLCLOSE;
 19  END list_tables;
 20  /

Procedure created.

SQL>

31.37.HTP
	31.37.1.	Create HTML List tags
	31.37.2.	Display table names in user_tables in HTML format with HTP.PRINT
	31.37.3.	Use HTP package to create HTML page structure
	31.37.4.	HTP.PRINT with to_char method
	31.37.5.	Using HTP.PRINT and HTF.BR to output a HTML
	31.37.6.	Build query form with HTP
	31.37.7.	Display employee in HTML format using HTP package
	31.37.8.	Output a html table
	31.37.9.	Display records in a HTML table
	31.37.10.	Display records in a HTML table with parameters
	31.37.11.	output a form with action