Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_instance005.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>REMOVE_SAVED_REPORTS Procedure</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:32:16Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="REMOVE_SAVED_REPORTS Procedure" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12510-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="apex_instance.htm" title="APEX_INSTANCE_" type="text/html" /> <link rel="up" href="apex_instance005.htm" title="REMOVE_SAVED_..." type="text/html" /> <link rel="prev" href="apex_instance004.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_instance006.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="apex_instance.htm" title="APEX_INSTANCE_">APEX_INSTANCE_</a> > REMOVE_SAVED_...</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="apex_instance004.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_instance006.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDBIIDD" name="CHDBIIDD"></a></p> <hr /> <div class="refsect1"> <h1>REMOVE_SAVED_REPORTS <a id="sthref770" name="sthref770"></a>Procedure</h1> <p>The <code>REMOVE_SAVED_REPORTS</code> procedure removes all user saved interactive report settings for a particular application or for the entire instance.</p> <a id="sthref771" name="sthref771"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_INSTANCE_ADMIN.REMOVE_SAVED_REPORTS( p_application_id IN NUMBER DEFAULT NULL); </pre> <a id="sthref772" name="sthref772"></a> <p class="subhead2">Parameters</p> <p><a href="#CHDHCIFI">Table: REMOVE_SAVED_REPORTS Parameters</a> describes the parameters available in the <code>REMOVE_SAVED_REPORTS</code> procedure.</p> <div class="tblformal"><a id="sthref773" name="sthref773"></a><a id="CHDHCIFI" name="CHDHCIFI"></a> <p class="titleintable">REMOVE_SAVED_REPORTS Parameters</p> <table class="Formal" title="REMOVE_SAVED_REPORTS Parameters" summary="This table describes the parameters available in the REMOVE_SCHEMA procedure." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t6">Parameter</th> <th align="left" valign="bottom" id="r1c2-t6">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t6" headers="r1c1-t6"> <p><code>p_application_id</code></p> </td> <td align="left" headers="r2c1-t6 r1c2-t6"> <p>The ID of the application for which to remove user saved interactive report information. If this parameter is left null, all user saved interactive reports for the entire instance will be removed.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref774" name="sthref774"></a> <p class="subhead2">Example</p> <p>The following example demonstrates how to use the <code>REMOVE_SAVED_REPORTS</code> procedure to remove user saved interactive report information for the application with an ID of 100.</p> <pre xml:space="preserve" class="oac_no_warn"> BEGIN APEX_INSTANCE_ADMIN.REMOVE_SAVED_REPORTS(100); END; </pre></div> <!-- class="refsect1" --> <!-- 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="apex_instance004.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_instance006.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