Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEUTL\sql_utl_exprt_imprt.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>Loading and Unloading Data from the Database</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="Loading and Unloading Data from the Database" /> <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="prev" href="sql_utl_exprt_imprt_choose.htm" title="Previous" type="text/html" /> <link rel="next" href="sql_utl_exprt_imprt_pg.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> > Loading and 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_exprt_imprt_choose.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="sql_utl_exprt_imprt_pg.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABJHFEC" name="BABJHFEC"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1><a name="AEUTL246" id="AEUTL246"></a>Loading and Unloading Data from the <a id="sthref260" name="sthref260"></a><a id="sthref261" name="sthref261"></a><a id="sthref262" name="sthref262"></a><a id="sthref263" name="sthref263"></a>Database</h1> <p>The Data Load/Unload wizards in Oracle Application Express enable you to easily load and unload delimited text data to and from the database. The step-by-step wizards have the following features:</p> <ul> <li> <p>You can load or unload XML files or delimited-field text files (such as comma-delimited (.<code>csv</code>) or tab-delimited files).</p> </li> <li> <p>You can load by copying and pasting from a spreadsheet.</p> </li> <li> <p>You can omit (skip) columns when loading or unloading.</p> </li> <li> <p>You can load into an existing table or create a new table from the loaded data.</p> </li> <li> <p>When loading into a new table, the primary key can be taken from the data or generated from a new or existing Oracle sequence.</p> </li> <li> <p>When loading into a new table, column names can be taken from the loaded data.</p> </li> <li> <p>Each time that you load from a file, file details are saved in a Text Data Load Repository. You can access these files from within the repository at any time.</p> </li> </ul> <p>Limitations include the following:</p> <ul> <li> <p>The wizards load and unload table data only. They do not load or unload other kinds of schema objects.</p> </li> <li> <p>You can load and unload to and from your own schema only. This is also true for users with administrator privileges.</p> </li> <li> <p>You can load or unload only a single table at a time.</p> </li> <li> <p>There are no data type limitations for unloading to text or XML files, or for loading from XML files. However, when loading from spreadsheets (through copy and paste) or from text files, only the following data types are supported: <code>NUMBER</code>, <code>DATE</code>, <code>VARCHAR2</code>, <code>CLOB</code>, <code>BINARY_FLOAT</code>, and <code>BINARY_DOUBLE</code>.</p> </li> </ul> <p>Supported unload formats include:</p> <ul> <li> <p>Text such as comma-delimited or tab-delimited data</p> </li> <li> <p>XML documents</p> </li> </ul> <a id="sthref264" name="sthref264"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="sql_utl_exprt_imprt_pg.htm#CEGHIFIF">Accessing the Data Load/Unload Page</a></p> </li> <li> <p><a href="sql_utl_imprt.htm#BCEDIEAH">Loading Data</a></p> </li> <li> <p><a href="sql_utl_exprt.htm#BCEFBDJA">Unloading Data</a></p> </li> <li> <p><a href="sql_utl_imprt_rep.htm#BABIECGA">Using Text Data Load Repository</a></p> </li> </ul> </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="sql_utl_exprt_imprt_choose.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="sql_utl_exprt_imprt_pg.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