All,
How do One convert a comma separated column from a text file into rows in oracle. I have a scenario where the list of comma separated values changes dynamically.
It is like:
abc, ttt, 1,2,34,56,67,,
afg, ttt, 3,4,5,6,,,,,
try, ttt, 4,5,,
I need to load this data into a oracle table which has columns like this:
name time ...