sql Lloader

create table ban_ji(
id integer,
ban_ji varchar2(25)
)
insert into ban_ji values(1,'1-(1)');
insert into ban_ji values(2,'1-(2)');

c盘根目录
mydata.txt
3#1-(5)
4#2-(7)
5#3-(13)abc

 

c盘根目录

mycontrl.ctl
load data
infile 'mydata.txt'
append
into table ban_ji(
id char terminated by "#"
ban_ji char terminated by "#"
)
sqlldr jyc/jyc@orcl control=c:/mycontrl.ctl data=c:/mydata.txt