Monday, 11 May 2015

Pattern Match Using Regualr Expression in Oracle



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;



No comments:

Post a Comment