REGEX_REPLACE does not work as expected in oracle 10g

Question

I am using the method REGEX_REPLACE

in Oracle 10g, but it doesn't replace strings.

Here's what I'm (unsuccessfully) trying:

Select REGEX_REPLACE('Mathew, Sajan K ext (E IT S US 1)','\\([^\\)]+\\)','') "REGEXP_REPLACE"

+1

sql oracle10g regex

udaya726 Jun 28. 12 at 5:22 am

source to share

1 answer

ohaal · Accepted Answer · 2012-06-28T05:48:07+0000

Try the following:

Select REGEX_REPLACE('Mathew, Sajan K ext (E IT S US 1)','\([^\)]+\)','') "REGEXP_REPLACE"

Note that I just removed the extra escape characters \

, some languages seem to require doubling the escape code and some don't.

Ref: Oracle SQL Database Reference REGEX_REPLACE