用sqlldr命令导入txt/csv文件问题总结

1.去掉文件字段的双引号问题

在ctl文件里控制

load data
CHARACTERSET ZHS16GBK
INTO TABLE CM_GROUP append
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
trailing nullcols
(
   ID         ,
  DEALDATE constant '20180314'      
)

起作用的：OPTIONALLY ENCLOSED BY '"'

2.去掉文件字段的单引号问题

在ctl文件里控制

load data
CHARACTERSET ZHS16GBK
INTO TABLE CM_GROUP append
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '\''
trailing nullcols
(
   ID         ,
  DEALDATE constant '20180314'      
)

起作用的：OPTIONALLY ENCLOSED BY '''