){2,}'', '','') AS RX_REPLACE FROM dual;
Select REGEXP_REPLACE(''aa bb cc'',''(.*) (.*) (.*)'', ''3, 2, 1'') FROM dual；
SQL> select * from test;
ID MC
-------------------- ------------------------------------------------------------
A AAAAA
a aaaaa
b bbbbb
SQL> select * from test where regexp_like(id,''b'',''i''); --不区分数据大小写
ID MC
-------------------- ------------------------------------------------------------
b bbbbb
#End
