sqlloder

2019独角兽企业重金招聘Python工程师标准>>>

sqlldr userid=WIS_ENTER/WIS_ENTER@DATABASENAME control=e:\input.ctl

input.ctl

load data
infile 'e:\device__2015_04_29.txt'
append into table device_phone  
Fields terminated by "|"

(device_id,phone_no);

转载于:https://my.oschina.net/liyonglee/blog/408698