4 Replies Latest reply on Sep 23, 2019 4:21 PM by BPeaslandDBA

    Import CSV file using Oracle Procedure, Column data having comma

    c3bcdd38-c948-4821-a280-4ee306a67037

      Need to write a procedure to import csv file in the server. CSV file having multiple columns having data seperated by comma.

       

      Sample record given below.

       

      1,Hello,"Hai, How are you?"

      2,Hai,"Hello, this is Rajasekhar"

       

      Need to import those records into the table.

       

      Note: Column data might be 3000 characters in real time.