??????cmd???д?????????sqlldr customermanager/123@orcl control="E:CustomerDataexcelInputOracleinsert.ctl" log=E:CustomerDataexcelInputOraclelog.txt skip=1

?????????

????{

????sqlldr??sqlloader?????????

????customermanager/123@orcl????????????????/????@??????

????control???????? ?????????????

????log ??????????????

????skip????????У??????????????????????????????

?????????????????????????????  ????? insert.ctl???

???????e?excel????????csv??????

????}

????insert.ctl????????txt????????????????????????????????????

load data
CHARACTERSET ZHS16GBK
infile 'E:CustomerDataexcelInputOracle20130726.csv'
append into table ORIGINAL_DATA
fields terminated by '??'
optionally enclosed by '"'
trailing nullcols
(ZCRQ??
XQSLH??
LWDW??
FZ??
FJ??
FHR??
DZ??
DJ??
HZPM??
HZPL??
YSTZHZ??
QQCS??
QQLX??
PZCS??
PZCZ??
ZCCS??
ZCCZ??
YDJH??
YWC??
SHE??
JY??
HYSR??
HPSR??
JSJJ??
FQ??
DQ)