Regular Expression Function (10 Gb introduced)
Regexp_like ('s ', 'Re', 'O ')
S string or column expression to be searched
RegEx content
O parameter (optional)
Idle> select ename from emp where regexp_like (ename,'s ');
ENAME
----------
SMITH
JONES
SCOTT
ADAMS
JAMES
Idle> select ename from emp where regexp_like (ename, '^ S. * t ');
ENAME
----------
SMITH
SCOTT
Idle>
Idle> select ename from emp where regexp_like (ename, '^ s. * T $', 'I'); case insensitive
ENAME
----------
SCOTT
Idle>
Regexp_replace (S, 'Re', 'new ')
Idle> select ename, regexp_replace (ename,'s. T ',' = ') aaa from emp where regexp_like (ename,'s.. T ');
ENAME AAA
--------------------
SMITH = H
SCOTT = T
Idle>
Regexp_replace (S, 'Re', 'new ')
Idle> select ename, regexp_replace (ename,'s. * t', '=') aaa from emp where regexp_like (ename,'s. * t ');
ENAME AAA
--------------------
SMITH = H
SCOTT =
Idle>