http://blog.itpub.net/27042095/viewspace-748002/
http://blog.chinaunix.net/uid-27126319-id-3502468.html
LOAD DATA
INFILE 'C:\Users\jack\Desktop\test\sqlldr4.txt' "str X'3B'"
INTO TABLE T1
REPLACE
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(
ID,
FUND_ACC,
FUND_CODE,
FUND_NAME,
SG_FEE,
SH_FEE,
ZH_FEE,
NOW_VOL,
TOUZI_FEE,
FUND_VALUE,
YINGKUI_FEE,
TRADE_VOL,
DIV_TYPE,
COMPANY_NAME,
DIV_NAME,
DIV_CONTROL,
INSERT_TIME,
REDEEM_NAV "REPLACE(:REDEEM_NAV,'\\N',null)"
)
select utl_raw.cast_to_raw(';') from dual;换行确定函数
http://blog.chinaunix.net/uid-27126319-id-3502468.html
LOAD DATA
INFILE 'C:\Users\jack\Desktop\test\sqlldr4.txt' "str X'3B'"
INTO TABLE T1
REPLACE
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(
ID,
FUND_ACC,
FUND_CODE,
FUND_NAME,
SG_FEE,
SH_FEE,
ZH_FEE,
NOW_VOL,
TOUZI_FEE,
FUND_VALUE,
YINGKUI_FEE,
TRADE_VOL,
DIV_TYPE,
COMPANY_NAME,
DIV_NAME,
DIV_CONTROL,
INSERT_TIME,
REDEEM_NAV "REPLACE(:REDEEM_NAV,'\\N',null)"
)
select utl_raw.cast_to_raw(';') from dual;换行确定函数
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29620572/viewspace-1811624/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29620572/viewspace-1811624/