RafalSladek/12MonthsInOracle.sql

Created March 14, 2018 22:20

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/RafalSladek/fc8ffb5e00f8c2580f2136cbd0c2b6ab.js"></script>
Save RafalSladek/fc8ffb5e00f8c2580f2136cbd0c2b6ab to your computer and use it in GitHub Desktop.

Download ZIP

create 12 months in oracle

Raw

12MonthsInOracle.sql

select add_months(date '2018-01-01',rownum-1) mth from dual connect by level <= 12;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment