Direct Path Insert &/vs Conventional Insert Mustafa, 2020-10-27 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… Continue Reading
Insert multi line text data using sqlldr Mustafa, 2019-07-052020-01-09 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: Oracle PL/SQL 1,"this is two line data", 10 2,"this is three line data", 11 3,"this is one line data", 12 4,this, 13 1234567 1,"this istwo line data", 102,"this isthree linedata", 113,"this is one line data", 124,this, 13 you need to do some extra work to accomplish this problem. In my example I… Continue Reading