Hi there, I couldn’t write anything for a while. Those days were busy. So I would talk to about direct path insert and conventional insert. Many people think that they are using “direct path insert” when used sqlldr utility but they are not. it is easy to confused batch insert and direct path insert. of […]
sqlldr
Insert multi line text data using sqlldr
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 […]