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!

SQL: Query to display MonthYear column wise

Don07Jul 5 2016 — edited Jul 11 2016

Hello There,

I would like to have a SQL query which would display the Month and Year column wise. Input parameter will be the number of months to be shown (columns) to have:In the below example it is to display 8 months from sysdate

One          Two         Three        Four          Five            Six           Seven        Eight

------------    ------------   -------------   -------------   -------------     -------------   -------------    -------------

Jun-2016   Jul-2016   Aug-2016  Sep-2016  Oct-2016     Nov-2016   Dec-2016   Jan-2017

Any help, how this can be done?

Many thanks and regards,

Don
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2016
Added on Jul 5 2016
16 comments
5,613 views