sqlload.cmd
pausesqlldr [email protected] control.ctl skip=1 rows=2000 bindsize=8192000 pause
control.ctl
LOAD DATAINFILE 'Rating201001.csv'APPENDINTO TABLE "TBL_SELL"FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'--FIELDS TERMINATED BY ','-- 表的字段没有对应的值时允许为空TRAILING NULLCOLS-- 下面的字段顺序对应csv文件中逗号分隔后的字段顺序，可以用:字段名来引用其他列的值 ( SRC_TYPE_CODE, -- YEAR_MONTH "201002", 忽略第二列值而使用固定值 YEAR_MONTH, P_INDEX, PROVINCE, CITY, COUNTRY, SHOP_NAME "trim(:SHOP_NAME)", SHOP_CODE, BRAND_NAME, SELL_COUNT, SELL_MONEY, SHOP_RATING, TYPE_CODE "decode(:SRC_TYPE_CODE,10,5,:SRC_TYPE_CODE)" )