Skip to Main Content

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!

Please help me to solve this date comparision issue..

phani marellaMay 19 2009 — edited May 28 2009
Please help me to solve this issue..

If i have some data like the following..


ID           START DATE             END DATE

1             20080101              20080501
1             20080502              20080630
2             20080631              20080801
2             20080802              20080901
                                             ---------------> There is a break in date over here
2             20080930              20081029
2             20081030              20081130


I need to compare the End Date with the start date (These data will not be in order)
and find out if there is any break and should get the 
output date : *20080930*

I am trying to do this in SQL or PL/SQL.Please help me .

Thanks in advance.
phani
This post has been answered by Hoek on May 19 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 23 2009
Added on May 19 2009
26 comments
1,180 views