TXT文件导入到ORACLE数据库中

--创建表 (sqlplus执行)
drop table cjw;
create table cjw (name varchar(222),phone number,province varchar(222),city varchar(222),born varchar(222),adressJob varchar(2222),mail varchar(222));

### txt导入到oracle
cat >load.ctl <<END
load data
append into table scott.cjw
fields terminated by '|'
TRAILING NULLCOLS
(name,
phone,
province,
city,
born,
adressJob,
mail)
END

### 导入数据 
sqlldr userid=USERNAME/PASSWORD control=load.ctl data=DATA.FILE rows=1000 bindsize=2560000