This content has been marked as final. Show 6 replies
simple you can create the external table load the csv file,after based on columns you can insert the two tables....
I am not using external tables for this
in this case you have to write two control files...there is no other option in sql loader..
You should use external tables unless this is an academic exercise (which is what it seems like), external tables and http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_9014.htm#i2095116 means problem solved.
and if you really really cannot use external table, try http://bit.ly/Tf6NWL
The search result, which you have given also contains the same code which i posted in the forum.
Thanks for the post,
Try with the position option instead ... http://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_control_file.htm#i1005798
not sure if it will work, but worth a try anyway.
Edited by: rjamya on Jan 22, 2013 4:29 PM