Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\ui_custom_plsql.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Rendering HTML Using Custom PL/SQL</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:30Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Rendering HTML Using Custom PL/SQL" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-01" /> <link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="ui.htm" title="Controlling Page Layout" type="text/html" /> <link rel="up" href="ui_custom_plsql.htm" title="Rendering HTML Using Custom..." type="text/html" /> <link rel="prev" href="ui_file_del.htm" title="Previous" type="text/html" /> <link rel="next" href="themes.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="ui.htm" title="Controlling Page Layout">Controlling Page Layout</a> > Rendering HTML Using Custom...</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="ui_file_del.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="themes.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABGGACI" name="BABGGACI"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB06013|rendering HTML using custom PL/SQL"></a>Rendering HTML Using Custom <a id="sthref1549" name="sthref1549"></a><a id="sthref1550" name="sthref1550"></a>PL/SQL</h1> <p>If you need to generate specific HTML content not handled by Oracle Application Express forms, reports, and charts, you can use the PL/SQL region type. To generate HTML in this type of region, you need to use the PL/SQL Web Toolkit. You can reference session state using bind variable syntax. Keep in mind that when you generate HTML in this way, you do not get the same consistency and control provided with templates.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="http://www.oracle.com/pls/db112/lookup?id=ADFNS"><span class="italic">Oracle Database Advanced Application Developer's Guide</span></a> for information about developing Web applications with PL/SQL</p> </li> <li> <p><a href="http://www.oracle.com/pls/db112/lookup?id=ARPLS"><span class="italic">Oracle Database PL/SQL Packages and Types Reference</span></a> for information about htp packages</p> </li> </ul> </td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <p>To give you more control over HTML dynamically generated within a region, you can use PL/SQL. For example, to print the current date, you could create a region with the following source:</p> <pre xml:space="preserve" class="oac_no_warn"> htp.p(TO_CHAR(SYSDATE,'Day Month DD, YYYY')); </pre> <p>This next example accesses tables:</p> <pre xml:space="preserve" class="oac_no_warn"> DECLARE l_max_sal NUMBER; BEGIN SELECT max(sal) INTO l_max_sal FROM <span class="italic">emp</span>; htp.p('The maximum salary is: '||TO_CHAR(l_max_sal,'999,999.00')); END; </pre></div> <!-- class="sect1" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="ui_file_del.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="themes.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de