CLOB size matters!

Hi, Many developer and DBA has an idea about the storing clobs. Basic rule is “if length of clob is higher tan 4000 then it will be stored in lob segment not in table segment” which is correct but sometimes misinterpreted! if you have a clob column in your table, your data might be in

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 ( so if have a data like this in your text file: you need to do some extra work to accomplish this problem. In my example I have 4 rows but 2

Commit Time for an Inserted Row in Oracle

Hello everyone, This week, one of my customer have experienced a problem. They provide some Web Service to their suppliers and one of those web services creates some rows and then returns the response as successful operation but just after that, supplier queries the newly created those rows but they get “no rows”! When analyze