Regular expressions only work in Oracle 10G.





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Saravanan Venkatesh
[mailto:oracledba-ezmlmshield-x38187375.[Email address protected]
Sent: Monday, May 07, 2007 10:55 AM
To: LazyDBA Discussion
Subject: 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



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page