SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

to Strip comma from String

862489Mar 19 2014 — edited Mar 19 2014

Will you please help me providing sql statement to strip commas from the String as below. The below string is dynamic, it may contain multiple commas up tp 5 commas

"213, KEATON AVENUE,WATER ST,SOUTHAFRICA"

This is throwing no data found error when passed as csv as below

12,456,"213, KEATON AVENUE,WATER ST,SOUTHAFRICA"

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2014

Added on Mar 19 2014

#from, #to

2 comments

416 views