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!

Generate all the quarters between start and end dates

961967Sep 13 2012 — edited Sep 13 2012

Hello all,

I have a query in which i have two dates that is Start Date and End Date and now i have to populates all the quarters date between the date range:

For eg:

Start Date : 1-Apr-2011

End Date: 1-Jul-2012

Now taking these two values i want the recors as displayed below

Apr 2011

Jul 2011

Oct 2011

Jan 2012

Apr 2012

Jul 2012

So how can write my PL/SQL query to accomplish this task

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2012

Added on Sep 13 2012

7 comments

2,357 views