Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEUTL\sql_utl_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>PL/SQL Reports</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:10:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="PL/SQL Reports" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12511-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" title="Home" type="text/html" /> <link rel="up" href="sql_utl.htm" title="Using Oracle Application Ex..." type="text/html" /> <link rel="up" href="sql_utl_obj_rpt.htm" title="Viewing Object Reports" type="text/html" /> <link rel="up" href="sql_utl_plsql.htm" title="PL/SQL Reports" type="text/html" /> <link rel="prev" href="sql_utl_sec.htm" title="Previous" type="text/html" /> <link rel="next" href="sql_utl_excp_rpt.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="sql_utl.htm" title="Using Oracle Application Ex...">Using Oracle Application Ex...</a> > <a href="sql_utl_obj_rpt.htm" title="Viewing Object Reports">Viewing Object Reports</a> > PL/SQL Reports</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="sql_utl_sec.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="sql_utl_excp_rpt.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABDHEBE" name="BABDHEBE"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEUTL260" id="AEUTL260"></a>PL/SQL Reports</h1> <p>Use the PL/SQL reports to view program unit arguments or unit line counts and also to search PL/SQL source code.</p> <a id="sthref300" name="sthref300"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#CBHBAGGC">Program Unit Arguments</a></p> </li> <li> <p><a href="#CBHJIFBI">Unit Line Counts</a></p> </li> <li> <p><a href="#CBHHIFFE">Search PL/SQL Source Code</a></p> </li> </ul> <a id="CBHBAGGC" name="CBHBAGGC"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEUTL261" id="AEUTL261"></a>Program Unit <a id="sthref301" name="sthref301"></a><a id="sthref302" name="sthref302"></a>Arguments</h2> <p>Use the Program Unit Arguments report to view package input and output parameters.</p> <p>To view the PL/SQL Unit Arguments report:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Utilities</span> icon.</p> </li> <li> <p>Click <span class="bold">Object Reports</span>.</p> <p>The Object Reports page appears.</p> </li> <li> <p>In the PL/SQL Reports section, click <span class="bold">Program Unit Argument</span><span class="bold">s</span>.</p> </li> <li> <p>To filter the report, enter a query in PL/SQL Package or Program Unit and click <span class="bold">Go</span>.</p> </li> <li> <p>To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="CBHJIFBI" name="CBHJIFBI"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEUTL262" id="AEUTL262"></a>Unit Line<a id="sthref303" name="sthref303"></a><a id="sthref304" name="sthref304"></a> Counts</h2> <p>Use the Unit Line Counts report to view the number of lines of code for each object. Use this report to identify larger PL/SQL program units.</p> <p>To view the Unit Line Counts report:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Utilities</span> icon.</p> </li> <li> <p>Click <span class="bold">Object Reports</span>.</p> <p>The Object Reports page appears.</p> </li> <li> <p>In the PL/SQL Reports section, click <span class="bold">Unit Line Counts</span>.</p> </li> <li> <p>To filter the report, enter an object name and click <span class="bold">Go</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="CBHHIFFE" name="CBHHIFFE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEUTL263" id="AEUTL263"></a>Search PL/SQL Source<a id="sthref305" name="sthref305"></a><a id="sthref306" name="sthref306"></a> Code</h2> <p>Use the Search PL/SQL Source code page to search the text within your PL/SQL code. Use this report to find references to tables or functions you might be thinking of deleting. You can also use this page to locate code when you can only recall a code snippet.</p> <p>To search for PL/SQL source code:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Utilities</span> icon.</p> </li> <li> <p>Click <span class="bold">Object Reports</span>.</p> <p>The Object Reports page appears.</p> </li> <li> <p>In the PL/SQL Reports section, click <span class="bold">Search PL/SQL Source Code</span>.</p> </li> <li> <p>To filter the report:</p> <ol> <li> <p>In Object Name, enter a query.</p> </li> <li> <p>In Text, enter the PL/SQL code you want to search for.</p> </li> <li> <p>In From/To Line, enter the range of lines you want to search.</p> </li> <li> <p>Click <span class="bold">Go</span>.</p> </li> </ol> </li> <li> <p>To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.</p> </li> </ol> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <!-- 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="sql_utl_sec.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="sql_utl_excp_rpt.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