1、文件格式形如:6|1|2|3|14
2、写一个ctl文件,项目中此文件也可以从数据库读取值写入到文件中。
文件内容如下:
LOAD DATA
infile 'C:\file\local\APPLY_20150612.txt'
append
into table TMP_LOAD_DATA
fields terminated by '|'
trailing nullcols
(
CUST_NAME "trim(:CUST_NAME)",
BATCH_CODE "trim(:BATCH_CODE)"
)
3、写bat文件
SQLLDR userid=username/password@orcl CONTROL=D:\workspace\temp\LOAD20150612.ctl LOG=C:\temp_log.log errors=2000
pause
4、写java类调用bat文件
public class InvokeBat {
public void runbat(String batName) {
try {
Process ps = Runtime.getRuntime().exec(batName);
ps.waitFor();
} catch (IOException ioe) {