Jun 21, 2016 01:03 PM|aoshi_kh|LINK
I have added to Datatable as well. but it was for checking the source_no. I have the text file as below, but without header, so I load it into datatable and take the first line source_no to verify the whole file, if any row not same source_no i stop to insert.
My text file will like this, but without header; each row should have 3 column, if less than or more than 3 column will have to fail whole file not to be inserted.
I tested many way and search around almost 2weeks but still unable to solve, can you share with me how to bulk copy the data to Oracle? and able to let me verify the source_no it's same in the same text file? and also the source_no is not exist in database
Thanks in advances