Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Help With Range Query

543079Oct 23 2007 — edited Nov 8 2007

Hi folks,

Let's say I have a table with this data:

START_DATE  END_DATE
----------- -----------
01-OCT-2007
02-OCT-2007 05-OCT-2007
02-OCT-2007
03-OCT-2007
03-OCT-2007
20-OCT-2007 21-OCT-2007

I would like a query that would give me each unique date including ones that fall between the start and end dates:

01-OCT-2007
02-OCT-2007
03-OCT-2007
04-OCT-2007
05-OCT-2007
20-OCT-2007
21-OCT-2007

Selecting the unique start date is of course not a problem. I am scratching my head on how to grab the list of dates that are within a range.

Please help. Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2007
Added on Oct 23 2007
9 comments
1,709 views