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