I was once asked by a fellow colleague if it was possible to have an SQL statement that would not allow employees from being registered to events that occur simultaneously.
Scenario
Consider a database that stores a list of persons and a list of events. Employees would eventually be registered as event attendees. It is possible that multiple events occur at the same time and therefore it is required that the SQL statement prevent any persons from being registered as attendees of conflicting events. It was required that the solution be all in one SQL statement for some reason whatsoever.
The SQL solution is found attached together with a supporting report! As always all feedback and queries are welcome!
Excellent Post, I truly appreciate your effort in publishing this.
Thank you so much
Good one Frankie! Is there some free or trial version of Oracle SQL Developer IDE? Another thing, did you use something else other than MS Word to create the document?
Hi Alex,
Oracle SQL Developer IDE is free you can download it from the following link: http://goo.gl/iflT5 In a previous posting I provide a guide of setting up Oracle Express Edition and configuring Oracle SQL Developer, you can find it here: http://goo.gl/x6bUp I am not using Microsoft products for a long while, I used iWorks on my MacBook Pro :D!!!!
Regards