Re: Oracle Beginner Help

<stevenplewis_at_gmail.com> a écrit dans le message de news: 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
|

• not beginner help but student homework help
• if asked is "before", it's surely not ">"
• i think you have a to_date function somewhere in your course

In addition, when you'll come back with an Oracle/SQL question, always post
- your Oracle version number

• OS type and version
• the actual error message as "it doesn't work" is not something returned by Oracle.

Regards
Michel Cadot Received on Mon Jan 16 2006 - 06:50:50 CET