Using REGEXP_REPLACE in Oracle

Question

Am trying to use backreference expression to take out three subexpressions from a search, and reposition each subexpression as follows:

 SELECT REGEXP_REPLACE('AAA 123 ppp','(^[[:alpha:]]+) ([[:digit:]]) ([[:alpha:]]+)','\3 \1 \2') from dual

However am getting the result as AAA 123 ppp where expecting ppp AAA 123 Where am i getting it wrong?

David דודו Markovitz · Accepted Answer · 2017-04-15 10:42:52Z

0

Missing + after [[:digit:]]

select  regexp_replace('AAA 123 ppp','(^[[:alpha:]]+) ([[:digit:]]+) ([[:alpha:]]+)','\3 \1 \2') 
from    dual

ppp AAA 123

answered Apr 15, 2017 at 10:42

3,27414 silver badges21 bronze badges

1 Answer 1