Pattern Match Using Regualr Expression in Oracle

0


Select Regexp_Instr('EMP_ID',(Select '(^|\s)'||'EMP_ID'||'(\s|$)' From Dual)) From dual;


Select Regexp_Instr('EEMP_ID',(Select '(^|\s)'||'EMP_ID'||'(\s|$)' From Dual)) From dual;