SQLLDR

create user User1 identified by "PassWord";
grant connect,resource to User1;
GRANT CREATE VIEW TO User1;

-------------------------------
sqlldr userid=user/pass@ctrl control=load.ctl data=data.txt log=mylog.log bad=mybad.bad discard=myDiscard.log Errors=20000000 direct=true parallel=true
---------------------------
LOAD DATA
--CHARACTERSET AL32UTF8--原始碼要判斷是否為UTF8
APPEND
INTO TABLE tablename
fields terminated by ","
--optionally enclosed by '"'
(
  COM "trim(:COM)",--1
  SDATE "TO_DATE(:SDATE,'YYYY-MM-DD HH24:MI:SS')",--7
  NOTE filler  
)
--"to_date(:STARTTIME1||:STARTTIME發佈文章, 'yyyy/mm/dd,hh24:mi:ss')"