oracle regexp

select regexp_replace('abcdefg','[a-c]+','9') 正則替換,

       regexp_replace('abcdefg','[a-c]','9') 正則替換  from dual;

select regexp_replace('158178225z5','[^0-9]','0') 正則替換  from dual;

--字元串被逗號截取後的第三個字元串

select regexp_substr('aaa,bbb,ccc,ddd,eee','[^,]',1,3) 截取字元串  from dual;

SELECT REGEXP_INSTR ('World filled with love', 'with', 1, 1, 0, 'i')FROM dual;

select * from emp1 where regexp_like(name,'(am)'); --全模糊比對;

select * from emp1 where regexp_like(name,'(1|2|3)$'); --右模糊比對;

select * from emp1 where regexp_like(name,'^(n)'); --左模糊比對;