Here are the steps you should implement:
1) Intall oracle db, full or express
2) Create files
*.txt file with data (may be any extension) and *.ctl file, it's using for specify mapping with data in file and database fields
example test.txt :
Bob 12 1999
George 9 1977
example test.ctl:
-- loading data
OPTIONS (ERRORS=999999)
LOAD
infile *
INTO TABLE PEOPLES
REPLACE
{
persone_name POSITION(1:8) CHAR ,
persone_month POSITION(8:9) CHAR,
persone_year POSITION(12:14) CHAR,
}
In place of Replace you can use also APPEND - if data doesn't already exist,INSERT - it requires the table to be empty
3) Execute in the console
String command = "sqlldr userid=" + "oracleuser/oraclepassword" + " control=" + "test.ctl"+ " data=" + "test.txt";
Process process = Runtime.getRuntime().exec(command);
int exitVal = process.waitFor();
exitVal may be:
0 - successful
1 - failed
2 - warn
3 - fatal
