Hi,
ive a string like the below:
i. 'Y,MN,,1,',
ii. 'Y,TX,500,T55,james@yahoo.com',
iii. 'abcd,123,defoifcd,87765'
Now iam trying to split these "," delimited strings into columns which can be 5 or more.
Iam using Frank's suggestion in the link below but it doesn't work correctly:
https://community.oracle.com/tech/developers/discussion/2348338/divide-the-comma-separated-string-into-columns
you can see my output below
any suggesting is appreciated.
Oracle 11g
thanks