Oracle Database Discussions

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!

CHR(44) to replace commas separating function arguments?

1112975Apr 30 2015 — edited Apr 30 2015

In Oracle SQL, is it possible to replace the commas which separate function arguments with chr(44)? A simple example using substr():

substr('aaaa', 1, 1) -- this returns 'a'

substr('aaaa' chr(44) 1 chr(44) 1) -- this should also return 'a'

Is there a way to make the second example work the same as the first? I've tried various escaping techniques, string concat, etc., and I haven't been successful. Is there a method for replacing the comma (',') character in the way I'm attempting or is this impossible?

Thanks

This post has been answered by John Stegeman on Apr 30 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2015

Added on Apr 30 2015

#general-database-discussions, #sql

2 comments

3,035 views