Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEUTL\sql_utl_exprt.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>Unloading Data</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="Unloading Data" /> <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_exprt_imprt.htm" title="Loading and Unloading Data ..." type="text/html" /> <link rel="up" href="sql_utl_exprt.htm" title="Unloading Data" type="text/html" /> <link rel="prev" href="sql_utl_imprt.htm" title="Previous" type="text/html" /> <link rel="next" href="sql_utl_imprt_rep.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_exprt_imprt.htm" title="Loading and Unloading Data ...">Loading and Unloading Data ...</a> > Unloading Data</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_imprt.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="sql_utl_imprt_rep.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BCEFBDJA" name="BCEFBDJA"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEUTL252" id="AEUTL252"></a>Unloading <a id="sthref277" name="sthref277"></a><a id="sthref278" name="sthref278"></a>Data</h1> <p>You can use the Unload page to export the contents of a table to a text file or XML document.</p> <a id="sthref279" name="sthref279"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#BCEFEDEH">Unloading a Text File</a></p> </li> <li> <p><a href="#BCEDBFEG">Unloading to an XML Document</a></p> </li> </ul> <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> <a href="sql_utl_exprt_imprt_choose.htm#BCECBCEC">"Choosing the Right Import/Export/Load/Unload Option"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="BCEFEDEH" name="BCEFEDEH"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEUTL253" id="AEUTL253"></a>Unloading a Text File</h2> <p>Use the <a id="sthref280" name="sthref280"></a><a id="sthref281" name="sthref281"></a><a id="sthref282" name="sthref282"></a>Unload to Text Wizard to export the contents of a table to a text file. For example, you could export an entire table to a comma-delimited file (.csv).</p> <p>To unload a table to a text file:</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">Data Load/Unload.</span></p> </li> <li> <p>Click <span class="bold">Unload</span>.</p> </li> <li> <p>Click <span class="bold">Unload To Text</span>.</p> <p>The Unload to Text Wizard appears.</p> </li> <li> <p>Follow the on-screen instructions.</p> </li> </ol> <p>You select the schema and choose the table and columns to be exported. Additionally, you can specify the type of separator to be used to separate column values and also whether column text strings are identified using single or double quotation marks.</p> </div> <!-- class="sect3" --> <a id="BCEDBFEG" name="BCEDBFEG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEUTL254" id="AEUTL254"></a>Unloading to an XML <a id="sthref283" name="sthref283"></a>Document</h2> <p>Use the <a id="sthref284" name="sthref284"></a><a id="sthref285" name="sthref285"></a>Unload to XML Wizard to export the contents of a table to an XML document adhering to the Canonical XML specification.</p> <p>To unload a table to an XML document:</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">Data Load/Unload</span>.</p> </li> <li> <p>Click <span class="bold">Unload</span>.</p> </li> <li> <p>Click <span class="bold">Unload to XML</span>.</p> <p>The <a id="sthref286" name="sthref286"></a>Unload to XML Wizard appears.</p> </li> <li> <p>Follow the on-screen instructions.</p> </li> </ol> <p>You select the schema and choose the table and columns to be exported.</p> </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_imprt.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="sql_utl_imprt_rep.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