Parsing CSV to Oracle columns
799060Sep 20 2010 — edited Sep 21 2010Hi Gurus,
Need a help from you. I have a table(say, INSERT_CSV) in which a column(say, CSVFILE) with CLOB datatype is present. That column consists of a file in CSV format stored in as a CLOB.
Another table(Say, RGDEMO) has three columns (Employee_name, employee_id, employer). These data are present in the CSV format. Need to parse the csv from the first table and store the same in the second. There aremore than 20K records in there.
(DB is 9i)
Your help is much appreciated
Thanks!
Edited by: 796057 on Sep 20, 2010 2:14 PM