Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util023.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>EXPORT_USERS 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="EXPORT_USERS 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_util.htm" title="APEX_UTIL" type="text/html" /> <link rel="up" href="apex_util023.htm" title="EXPORT_USERS Procedure" type="text/html" /> <link rel="prev" href="apex_util022.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util024.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="apex_util.htm" title="APEX_UTIL">APEX_UTIL</a> > EXPORT_USERS Procedure</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_util022.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util024.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABCDACJ" name="BABCDACJ"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI121" id="AEAPI121"></a>EXPORT_USERS Procedure<a id="sthref127" name="sthref127"></a><a id="sthref128" name="sthref128"></a><a id="sthref129" name="sthref129"></a></h1> <p>When called from a page, this procedure produces an export file of the current workspace definition, workspace users, and workspace groups. To execute this procedure, the current user must have administrative privilege in the workspace.</p> <a id="sthref130" name="sthref130"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_UTIL.EXPORT_USERS( p_export_format IN VARCHAR2 DEFAULT 'UNIX'); </pre> <a id="sthref131" name="sthref131"></a> <p class="subhead2">Parameters</p> <p><a href="#BABDJCFG">Table: EXPORT_USERS Parameters</a> describes the parameters available in the <code>EXPORT_USERS</code> procedure.</p> <div class="tblformal"><a id="sthref132" name="sthref132"></a><a id="BABDJCFG" name="BABDJCFG"></a> <p class="titleintable">EXPORT_USERS Parameters</p> <table class="Formal" title="EXPORT_USERS Parameters" summary="This table describes the parameters available in EXPORT_USERS 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-t35">Parameter</th> <th align="left" valign="bottom" id="r1c2-t35">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t35" headers="r1c1-t35"> <p><code>p_export_format</code></p> </td> <td align="left" headers="r2c1-t35 r1c2-t35"> <p>Indicates how rows in the export file will be formatted. Specify <code>'UNIX'</code> to have the resulting file contain rows delimited by line feeds. Specify <code>'DOS'</code> to have the resulting file contain rows delimited by carriage returns and line feeds</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref133" name="sthref133"></a> <p class="subhead2">Example</p> <p>The following example shows how to use the <code>EXPORT_USERS</code> procedure. Call this procedure from a page to produce an export file containing the current workspace definition, list of workspace users and list of workspace groups. The file will be formatted with rows delimited by line feeds.</p> <pre xml:space="preserve" class="oac_no_warn"> BEGIN APEX_UTIL.EXPORT_USERS; 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_util022.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util024.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