Hello Everyone, I just answered an OTN question about inserting multi line data using sqlldr and simply wanted to share it here (https://community.oracle.com/thread/4278952) so if have a data like this in your text file:
1 2 3 4 5 6 7 |
1,"this is two line data", 10 2,"this is three line data", 11 3,"this is one line data", 12 4,this, 13 |
you need to do some extra work to accomplish this problem. In my example I have 4 rows but 2 […]