Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

need to find date range

AteeqNov 17 2022 — edited Nov 17 2022

Oracle 11.2.0.4
Forms 6i

A user enters the date range From and To and the query needs to show which properties are vacant during this date range.
I have two tables SERVICE_UNITS and OCCUPANCY.
Service units table has property_code and Property_address while Occupancy table has property_code, status (Active,New), start_date and End_date
Suppose a property is active from 16-NOV-2022 till 20-NOV-2022 and an advance booking has been done for same property from 25-NOV-2022 till 30-NOV-2022.
how can i show the properties which aren't booked during any given range.

Best Regards,
This post has been answered by BEDE on Nov 17 2022
Jump to Answer

Comments

Post Details

Added on Nov 17 2022
#oracle
5 comments
204 views
1 mention