how to replace '&' and '()' in sql query for oracle using regex
Posted on 2016-11-21
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?
Eg. String: This is a test & temp ()
output like : This is a test and temp bracket.
thnks in advance.