SQLLDR应用举例.docVIP

SQLLDR应用举例 ? ? 1、普通装载? LOAD DATAINFILE *INTO TABLE DEPTREPLACEFIELDS TERMINATED BY , OPTIONALLY ENCLOSED BY ? (DEPTNO,?DNAME,?LOC)BEGINDATA10,Sales,USA20,Accounting,Virginia,USA?30,Consulting,Virginia40,Finance,Virginia50,Finance,,Virginia?--loc 列将为空60,Finance,,Virginia???--loc 列将为空 注：BEGINDATA后的数值前面不能有空格 ? 2、TERMINATED BY WHITESPACE 和 FIELDS TERMINATED BY x09 的情况? LOAD DATA? INFILE *? INTO TABLE DEPT? REPLACE? FIELDS TERMINATED BY WHITESPACE? --FIELDS TERMINATED BY x20? (DEPTNO,???DNAME,???LOC? )? BEGINDATA? 10 Sales Virginia ? 注：x20表示字符ASCII码的16进制数值 ??3、指定不装载那