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.

Query Help - Trying to get single date field into Date Range

689401Mar 5 2009 — edited Mar 6 2009

Greetings,

I was wondering if someone could possibly help. I am trying to get the following data in to the format below it via a query.

id group sub-group Value date
1 abc def 10 01-jan-2009
1 abc def 10 02-jan-2009
1 abc def 10 03-jan-2009
1 abc def 10 04-jan-2009
1 abc def 10 05-jan-2009
1 abc def 10 06-jan-2009
1 abc def 10 07-jan-2009
1 abc def 10 08-jan-2009
1 abc def 10 09-jan-2009
1 abc def 20 10-jan-2009
1 abc def 20 11-jan-2009
1 abc def 20 12-jan-2009
1 abc def 20 13-jan-2009
1 abc def 20 14-jan-2009
1 abc def 20 15-jan-2009
1 abc def 10 16-jan-2009
1 abc def 10 17-jan-2009
1 abc def 10 18-jan-2009
1 abc def 10 19-jan-2009
1 abc def 20 20-jan-2009
1 abc def 20 21-jan-2009

I need to query to get this output
id group sub-group value start_date end_date
1 abc def 10 01-jan-2009 09-jan-2009
1 abc def 20 10-jan-2009 15-jan-2009
1 abc def 10 16-jan-2009 19-jan-2009
1 abc def 20 20-jan-2009 21-jan-2009

Any help would be appreciated!

-Bill

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2009

Added on Mar 5 2009

8 comments

5,039 views