Removing comma (,) from string
kumar73Jul 9 2012 — edited Jul 10 2012Hello Friends,
I have a string something of this nature
Sting : ',3456,45454,,45454,'
Need to have just comma seperated value : '3456,45454,45454'
Tried with replace but getting - '34564545445454'
select replace ( ltrim(RTRIM(replace(',3456,45454,,45454,', ',,', ','),',')),',', '') from dual;
Appreciate your help .
Thanks/Kumar