Mega Code Archive
Output a html table
<![CDATA[
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.
]]>