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!

Help with REGEXP_REPLACE upper replacement string

greg_cOct 4 2012 — edited Oct 5 2012

Hi All,

I am attempting to uppercase the replacement string from my reg expression without success:

SELECT regexp_replace('src=/i/uie_v2/js','(/uie_v2/)',upper('\1')) from dual

returns 'src=/i/uie_v2/js'

I understand that upper cannot be used .. just showing as an example. Any ideas on how to achieve this ?

Thanks in advance :)

Greg

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2012

Added on Oct 4 2012

15 comments

2,076 views