Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\doc\ohj\wbdod10560.htm

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\doc\ohj\wbdod10560.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="ja" lang="ja">
<script src="./callback.js" type="text/javascript"></script>
<noscript>??????????????avaScript???????????????????????????????????????????????JavaScript??????????</noscript>
</head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Script-Type" content="text/javascript" />

<meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" />
<meta name="date" content="2009-06-04T0:46:14Z" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="SQL*Loader Properties" />
<meta name="relnum" content="11g Release 2 (11.2)" />
<meta name="partnum" content="E10582-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="prev" href="f1_file_wiz_structure.htm" title="Previous" type="text/html" />
<link rel="next" href="wbdod10561.htm" title="Next" type="text/html" />
<title>SQL*Loader????????</title>
</head>
<body>
<div class="zz-skip-header"><a href="#BEGIN">??????????????</a></div>
<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="f1_file_wiz_structure.htm"> <img src="./dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a>&nbsp;</td>
<td align="center"><a href="wbdod10561.htm"> <img src="./dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</span></a></td>
</tr>
</table>
<p><a id="BABEAAJG" name="BABEAAJG"></a><a id="WBDOD10560" name="WBDOD10560"></a></p>
<div class="sect3">
<h1>SQL*Loader????????</h1>
<a name="BEGIN" id="BEGIN"></a>
<p><a id="sthref62" name="sthref62"></a><a id="sthref63" name="sthref63"></a>???????????????????????????????????????QL*Loader?????????????????????????????????????????????????????????????????????????QL*Loader???????????????????????????????????QL*Loader?????????????<a href="#BABIIHBB">????????</a>??<a href="#BABHAEFE">???????</a>??<a href="#BABEBGCE">???????</a>??<a href="#BABDDHJJ">??????????</a>??<a href="#BABCDGGC">????????</a>??<a href="#BABGEBJG">??ULLIF??</a>?????<a href="#BABHFFFB">??EFAULTIF??</a>????????????????????????????????????????????????????<a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=CNCPT','newWindow').focus()"><span class="italic">Oracle Database???</span></a>????????????????</p>
<a id="BABIIHBB" name="BABIIHBB"></a><a id="WBDOD90709" name="WBDOD90709"></a>
<p class="subhead2">?????</p>
<p>SQL*Loader???????????????????????????????????????????????<code>CHAR</code>??<code>DATE</code>??<code>DECIMAL</code> <code>EXTERNAL</code>??<code>FLOAT EXTERNAL</code>??<code>INTEGER EXTERNAL</code>??<code>ZONED</code>?????<code>ZONED EXTERNAL</code>???????????????????????????????QL*Loader????????????????????????????<a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=SQLRF00222','newWindow').focus()"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=SUTIL','newWindow').focus()"><span class="italic">Oracle Database???????????</span></a>????????????????</p>
<a id="BABHAEFE" name="BABHAEFE"></a><a id="WBDOD90710" name="WBDOD90710"></a>
<p class="subhead2">???</p>
<p>???????????????????????QL*Loader????????????????????????????????</p>
<a id="BABEBGCE" name="BABEBGCE"></a><a id="WBDOD90711" name="WBDOD90711"></a>
<p class="subhead2">???</p>
<p>?????????????????????????????????????????????????????????????????<a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=SUTIL1151','newWindow').focus()"><span class="italic">Oracle Database???????????</span></a>????????????????</p>
<a id="BABDDHJJ" name="BABDDHJJ"></a><a id="WBDOD90712" name="WBDOD90712"></a>
<p class="subhead2">??????</p>
<p>????????????????????????????????????????????????????????????????????<a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=SUTIL1511','newWindow').focus()"><span class="italic">Oracle Database???????????</span></a>????????????????</p>
<a id="BABCDGGC" name="BABCDGGC"></a><a id="WBDOD90713" name="WBDOD90713"></a>
<p class="subhead2">?????</p>
<p>SQL*Loader??????????????????????????D-Mon-YY???????????????????????????????°???????????????????????????????????????????????????????QL*Loader???????????????DD-Mon-YYYY???????????????????????????????????????????????????????</p>
<a id="BABGEBJG" name="BABGEBJG"></a><a id="WBDOD90714" name="WBDOD90714"></a>
<p class="subhead2">NULLIF</p>
<p>SQL*Loader?????????????????????????????????????????ULLIF??????????????????????????????????????????????????????????????????????????????????????ULL?????????????????QL*Loader????????????????????????????????????<span class="italic">=BLANKS??='quoted string'??=X'ff'</span>??16??????????????????<span class="italic">!= </span>???????????????????????????</p>
<a id="BABHFFFB" name="BABHFFFB"></a><a id="WBDOD90715" name="WBDOD90715"></a>
<p class="subhead2">DEFAULTIF</p>
<p>SQL*Loader?????????????????????????????????????????EFAULTIF?????????????????????????????DATE??????????????????????????QL*Loader?????????????????????????????????????????????????????EFAULTIF???????????<span class="italic">=BLANKS</span>???????????QL*Loader??????????????????????????????????????????????????????????????????????????????????????<span class="italic">=BLANKS??='quoted string'??=X'ff'</span>??16????????????????<span class="italic">!=</span>???????????????????????????</p>
</div>

<div class="footer">
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td align="left" width="86%"><a href="topicid:help_legalnotices_html"> <span class="copyrightlogo">Copyright&nbsp;(C)&nbsp;2009,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;All&nbsp;rights&nbsp;reserved.</span></a>
</td>
</tr>
</table>
</div>
</body>
</html>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de