oracle利用 sqlldr 導入文本數據
1.input.ctl
load data
load data
infile 'test.txt'
append into table temp_log
fields terminated by ','
(a, b)
2.test.txt
a,b
3.sqlldr userid=用戶名/密碼 control=input.ctl
2.test.txt
a,b
123,567
890,312
3.sqlldr userid=用戶名/密碼 control=input.ctl