控制文件:
load DATA
INFILE 'C:\Users\Administrator\Desktop\ss\ss.csv'
APPEND INTO TABLE ss
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(ID,mycol1 filler,NAME,mycol2 filler)
数据文件:
5 s e d
6 s f d
表结构:
create table ss(id number,name varchar2(20));