insert

[tanaka]

Hi ,

I have a variable which stores a string like..

str -> 'abc,1234,xyz'

Now i want to break this string at the commas and then insert the sepate strings in diffrent columns of a single table.The length of str is not fixed.

Help needed.

[balajiyes]

try using DBMS_UTILITY.COMMA_TO_TABLE
Cheers!