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!

I would like to use Oracle pl/sql to generate a year, qtr and month table

3417323Oct 13 2017 — edited Oct 13 2017

Hi,

I would like to use Oracle pl/sql to generate a year, quarter and month table like this, from year 1954 to 2020. Can someone provide me the code?

thank you so much for your help!

Cathy

YearQTRMONTH
1954195501195412
1955195501195501
1955195501195502
1955195502195503
1955195502195504
1955195502195505
1955195503195506
1955195503195507
1955195503195508
1955195504195509
1955195504195510
1955195504195511
1956195601195512
2019202001201912
2020202001202001
2020202001202002
2020202002202003
2020202002202004
2020202002202005
2020202003202006
2020202003202007
2020202003202008
2020202004202009
2020202004202010
2020202004202011
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2017
Added on Oct 13 2017
5 comments
647 views