Regular expression

Regular expression

 

  

Hello Gurus,
While trying to execute this query I am getting error.

select ename,REGEXP_INSTR(ename,'[aeiou][aeiou]') from scott.emp
*
ERROR at line 1:
ORA-00904: "REGEXP_INSTR": invalid identifier

Oracle version: 9i

Please suggest.

Thanks
Venkatesh


Oracle LazyDBA home page