How to compare dates in oracle sql?
- 1 Answers
- 1185 Views
- I also Faced
- E-Mail Answers
Answer / Sheelvant
To compare dates in Oracle SQL, you can use the comparison operators like = (equal to), > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to). For example, if you want to find all employees who joined after 01-JAN-2000, you can execute: `SELECT * FROM EMPLOYEES WHERE hire_date > TO_DATE('01-JAN-2000', 'DD-MON-YYYY')`
| Is This Answer Correct ? | 0 Yes | 0 No |
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
In which language oracle has been developed?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Is there a combination of "like" and "in" in sql?
How to create a stored procedure in oracle?
how to retrieve 1st and last row of table without using group functions??
Explain about functional dependency and its relation with table design?
What happens to the current transaction if a ddl statement is executed?
Can select statements be used on views in oracle?
What is an oracle table?
what is the use of system.effective.date variable in oracle?
After using set unused can we enable the column again to use? Please give me some answers....
Oracle General 
