Correction! hehe.

select ename, to_char(hiredate, 'yyyy') hiredate, hiredate
from emp
where regexp_like(to_char(hiredate, 'yyyy'), '^198[0-3]$')
/

-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x24301689.[Email address protected]
Sent: Thursday, May 11, 2006 8:09 AM
To: LazyDBA Discussion
Subject: Oracle 10G Regular Expressions


Ahhhhhhh, yes! The old regular expressions! I tell you, yes! hehe. The Yankees (I mean the boys) are back in town! hehe.


select ename, sal, to_char(hiredate, 'yyyy') hiredate, sal
from emp
where regexp_like(to_char(hiredate, 'yyyy'), '^198[0-3]$')
/


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. 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]


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page