Home » SQL & PL/SQL » SQL & PL/SQL » Querying Dates missing in the table (Oracle10g)
Querying Dates missing in the table [message #318624] Wed, 07 May 2008 06:15 Go to next message
Messages: 87
Registered: November 2007
Location: chennai
I have columns name, taskname start_date and end_date in my table.

Name Task StartDate EndDate
abc task1 2008-04-01 2008-04-03
abc task2 2008-04-05 2008-04-15
abc task3 2008-04-08 2008-04-18
abc task4 2008-04-21 2008-04-25
abc task5 2008-04-19 2008-04-23
abc task6 2008-04-25 2008-04-30

I need to find out the dates for which there are no tasks planned for the person in the month excluding Saturdays and Sundays.

Is it possible to get the output in a single SQL itself, or else how could it be done in PL/SQL procedure ?
Re: Querying Dates missing in the table [message #318625 is a reply to message #318624] Wed, 07 May 2008 06:17 Go to previous message
Messages: 2818
Registered: May 2007
Location: Scotland
Senior Member
This has been asked many many times. Do a search on 'Missing Dates'
Previous Topic: doubt on exceptions
Next Topic: hi............
Goto Forum:

Current Time: Tue Oct 25 18:04:28 CDT 2016

Total time taken to generate the page: 0.12029 seconds