Skip to Main Content

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!

how to replace '&' and '()' in sql query for oracle using regex

user649990Nov 21 2016 — edited Nov 22 2016

I have columns in my database which have & and ()

I want to replace '&' with word 'and' '()' with word 'bracket'

is it possible to do in oracle using regex?

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2016
Added on Nov 21 2016
5 comments
443 views