Click here to Skip to main content
15,071,581 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

want a query in PL/SQL to select all YYYYMM between a date range like all the YYYYYMM between date range 20140101 to 201701201 (YYYYMMDD)
Output should be like table with two columns

Column1----- Column2

201401----- 20140131
201402----- 20140228
201403----- 20140331
. ------------- .
. ------------- .
. ------------- .
. ------------- .
. ------------- .
201711----- 20171130
201712----- 20171231

Thanks in advance

What I have tried:

I have tried query but not working
Posted
Updated 28-Nov-16 21:58pm
Comments
Maciej Los 29-Nov-16 3:53am
   
"Not working" is not informative at alll! What exactly have you tried?

1 solution

   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900