Range

SQL query to check if a date range is between two dates in Oracle database