How find the difference between two dates in oracle?

Question

How to compare dates which are in different tables and find the difference between two dates?

Answer 1

take a look at this: http://psoug.org/reference/date_func.html

Answer 2

Some date operations are pretty straightforward in Oracle. To get the difference between two DATE values, subtract one from the other. The result is returned as a number of days, including fractional days. (e.g. .25 = 6 hours)

SELECT dateval1 - dateval2 AS days_diff FROM ...