Oracle: How can I get the difference between two date columns?

Question

SELECT EMP_NAME, SSN FROM EMP WHERE HIER_DATE = TO_DATE('03-NOV-1999','DD-MON-YYYY');

Answer 1

This Example Query Will Find the No of Days In between the Two Dates.

SELECT DateField1NAME - DateField2NAME FROM TABLENAME