|
|
|
Re: Converting a string to comma seperated value [message #363166 is a reply to message #363163] |
Fri, 05 December 2008 04:58   |
anukriti
Messages: 3 Registered: December 2008 Location: India
|
Junior Member |
|
|
Hi
The version is oracle 10g.
SQl developer v1.0.14.22
One of the column in the table has the data like this i.e 1234 and i want to update this string as 1,2,3,4
so that it can be split into single digits.
without any delimiter i am not able to split this string into individual digits.Thats why i want to convert the string into comma seperated string.
Thanks
|
|
|
|
|
|
Re: Converting a string to comma seperated value [message #363174 is a reply to message #363168] |
Fri, 05 December 2008 05:17   |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
SQL> select rtrim(regexp_replace('1234','(.)','\1,'),',') from dual;
RTRIM(R
-------
1,2,3,4
1 row selected.
Regards
Michel
|
|
|
|
|
|