Display table names in user_tables in HTML format with HTP.PRINT : 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.PRINT('<HTML>');
  8     HTP.PRINT('<HEAD>');
  9     HTP.PRINT('<TITLE>Display a List Tables</TITLE>');
 11     HTP.PRINT('</HEAD>');
 12     HTP.PRINT('<BODY>');
 13     HTP.PRINT('<UL>');
 14        FOR cur_tables_rec IN cur_tables LOOP
 15           HTP.PRINT('<LI>' || cur_tables_rec.table_name);
 16        END LOOP;
 17     HTP.PRINT('</UL>');
 18     HTP.PRINT('</BODY>');
 19     HTP.PRINT('</HTML>');
 20  END list_tables;
 21  /

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