Topic: [SOLVED] SQL* PLUS Oracle SQL DEVELOPER Help

[OilSheikh]

It's been a long time sicne I cam here. Well, I finished my degree and went the tech support road rather than the Programming road for work. 

But, I m now back in uni and am once again doomed!

I need some help with SQL. Help would be much appreciated. Please tell me on how to fix the incorrect code I have.

1. A script that asks for two hire dates and enables finding employees between them. ( Yes, I already have a table! )
Output required:

EMPLOYEES     HIRE DATE
__________     ________
Empname, job  date




PROMPT Enter First Date
ACCEPT a DATE
PROMPT Enter Second Date
ACCEPT b DATE
SELECT ENAME, JOB, HIREDATE
FROM EMP
WHERE HIREDATE BETWEEN a AND b
COLUMN ENAME HEADING Employees
COLUMN ENAME FORMAT ENAME, JOB

[Mark Baker]

WHERE HIREDATE BETWEEN TO_DATE('<date_format_mask>',a) AND TO_DATE('<date_format_mask>',b)

[OilSheikh]

Thanks. Sort of helped.