Oracle的sqlldr使用例子

Oracle的sqlldr使用例子:................................................................................调用的shell脚本

sqlldr userid=hello/world control=/hello/world/shellscript.ctl data=/hello/world/wap.log log=/hello/world/logs/sqlldr_wap_bendi_$dd.log errors=600000................................................................................sqlldr的ctl脚本shellscript.ctl

load dataappendinto table TestTablefields terminated by ';' optionally enclosed by ' " 'TRAILING NULLCOLS(student_name ,create_time DATE 'yyyy-MM-dd HH24:mi:ss',create_editor CHAR(2000),return_state ,class_name ,mobile_code,qq_code,address,shool_id "func_TestTable(:student_name,0)",id "TestTable.Nextval") 

................................................................................注意:1. shool_id "func_TestTable(:student_name,0)", sqlldr里可以调用自定义函数给某个字段赋值。