• Oralce例子

SELECT REGEXP_REPLACE('20120202080259','(.{4})(..)(..)(..)(..)','\1-\2-\3 \4:\5:') "date" FROM DUAL;

date
-------------------
2012-02-02 08:02:59

SELECT REGEXP_REPLACE('A B C','(.*) (.*) (.*)','\3 \2 \1') "reverse" FROM DUAL;

reverse
-------
C B A