Oracle Beginner Help

From: <stevenplewis_at_gmail.com>
Date: 15 Jan 2006 21:26:14 -0800
Message-ID: <1137389174.777650.71290_at_g49g2000cwa.googlegroups.com>

[Quoted] I'm trying to display data for employees that have the job as a clerk and where hired before 1981. I write the following query

select ename from emp where hiredate > ('01-JAN-81') and job = 'clerk';

however it doesn't work. Any suggestions Received on Mon Jan 16 2006 - 06:26:14 CET