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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,822 views