sqlldr userid=liyongjie/liyongjie control=E:\Study\oracle\sqlload\score_ctrl.txt log=result.log
score_ctrl.txt 内容:
load data
infile 'E:\Study\oracle\sqlload\score.dat'
append into table score
fields terminated by ","
(name,course,mark)
score.dat文件内容:
TOM,English,81.00
TOM,math,75.00
JACK,English,76.00
JACK,Math,90.00
John,English,91.00
John,Math,100.00