1.在C盘下建立数据文件C:/11.txt
内容:
123,456
789,890
2.在C盘下建立控制文件C:、12.ctl
内容:
load data
infile 'C:/11.txt'
append
into table mm(m1 position(1:3) char,
m2 position(5:7) char)
3.建立表mm
create table mm(id varchar2(10),mname varchar2(10));
4.在cmd下输入命令:
C:/Documents and Settings/hong>sqlldr scott/tiger control=c:/12.ctl data=c:/11.t
xt
提示:
C:/Documents and Settings/hong>sqlldr scott/tiger control=c:/12.ctl data=c:/11.t
xt
SQL*Loader: Release 10.2.0.1.0 - Production on 星期三 7月 21 23:57:52 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
达到提交点 - 逻辑记录计数 1
达到提交点 - 逻辑记录计数 2
SQL> select * from mm;
ID MNAME
---------- ----------
123 def
456 klm
2.对于不规则的逗号分隔的数据
在C盘下建立控制文件C:、12.ctl
内容:
load data
infile 'C:/11.txt'
append
into table mm(m1 char terminated by ",",---以逗号分隔的数据
m2 char terminated by ",")