Output a html table : HTP « System Packages « Oracle PL/SQL Tutorial






SQL>
SQL>
SQL> CREATE OR REPLACE PROCEDURE p_test
  2  IS
  3  BEGIN
  4    htp.p('<HTML>');
  5    htp.p('<HEAD>');
  6    htp.p('<TITLE>Records</TITLE>');
  7    htp.p('</HEAD>');
  8    htp.p('<BODY>');
  9    htp.p('<H1>Records</H1>');
 10    htp.p('<TABLE BORDER="1 ">');
 11    htp.p('<TR><TH>Hierarchy</TH><TH>Org Long Name</TH></TR>');
 12    htp.p('<TR>');
 13    htp.p('<TD>Director</TD>');
 14    htp.p('<TD>Office of DirectorInc.</TD>');
 15    htp.p('</TR>');
 16    htp.p('<TR>');
 17    htp.p('<TD>Director</TD>');
 18    htp.p('<TD>Office</TD>');
 19    htp.p('</TR>');
 20    htp.p('</TABLE>');
 21    htp.p('</BODY>');
 22    htp.p('</HTML>');
 23  end;
 24  /

Procedure created.








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