Oracle SQL Loader相关

怡木8302

　　在Window下，SQL Loader的命令SQLLDR，在UNIX下sqlldr/sqlload。
　　


OPTIONS (SKIP=1)
UNRECOVERABLE
LOAD DATA
CHARACTERSET JA16SJIS #AL32UTF8 #JA16SJISTILDE
TRUNCATE INTO TABLE TMC_OTHERS
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
KeyName,
Code,
Name,
DefaltFlg,
DataSort,
Ikou_Flag "nvl(:Ikou_Flag, '1')" ,
Ikou_Pgid "nvl(:Ikou_Pgid, '1')",
Ikou_Jobid "nvl(:Ikou_Jobid, '1')",
Ikou_Insert_Date SYSDATE,
Ikou_Update_Pgid,
Ikou_Update_Jobid,
Ikou_Update_Date,
IKOU_UPDATE_FLAG ,
IKOU_FLAG2
)

 　　
　　OPTIONS (skip=1,rows=100) 此处rows是控制提交的行数（即每100行提交一次）经验证必须和direct=true同时使用才能达到效果。 
　　如：sqlldr ikou/ikou@comdev2 c:\dat\ACKCK.CTRL direct=true