OilSheikh Posted January 5, 2009 Share Posted January 5, 2009 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 Link to comment https://forums.phpfreaks.com/topic/139468-solved-sql-plus-oracle-sql-developer-help/ Share on other sites More sharing options...
Mark Baker Posted January 5, 2009 Share Posted January 5, 2009 WHERE HIREDATE BETWEEN TO_DATE('<date_format_mask>',a) AND TO_DATE('<date_format_mask>',b) Link to comment https://forums.phpfreaks.com/topic/139468-solved-sql-plus-oracle-sql-developer-help/#findComment-730008 Share on other sites More sharing options...
OilSheikh Posted January 7, 2009 Author Share Posted January 7, 2009 Thanks. Sort of helped. Link to comment https://forums.phpfreaks.com/topic/139468-solved-sql-plus-oracle-sql-developer-help/#findComment-731269 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.