LOAD DATA
INSERT--option(insert ,append,truncate)
INTO TABLE sqlloadertemp
--WHEN STATUS="1"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( name ,
url ,
status,
coment "decode(:status,1, '建设',2,'运行',3,'停止')" ,
rowid filler ,
time_loaded "to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')",
const "upper('a')"
)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28502651/viewspace-765217/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28502651/viewspace-765217/