This content has been marked as final. Show 3 replies
Yes u can append into 2 tables from SQLLDR.
Use the position clause in defining the columns
Suppose your flat file is :
and you want to insert data from column 1 from column 6 into table A and data from column cloumn 7 to cloumn 12 into table B, then u can write:
INTO TABLE A
col1 POSITION(01:06) CHAR
INTO TABLE B
col2 POSITION(07:12) CHAR
Thank you. To transfer data from Informix to Oracle do you reconne sqlldr would be best to use. As the data model are slightly different.
Please can you tell me how to skip a row in the ctl file. I tried giving skip 1 after load data it gives error.