ORACLE - 365 DAYS | Document - Extract and Share

In order to form an immaculate member of a flock of sheep one must, above
all, be a sheep.

— Albert Einstein

ORACLE - 365 DAYS

Sun, 11/21/2010 - 17:55 |

Juraj Maslik

How to select all the days from this year in ORACLE?

SQL>SELECT 
  TRUNC(CURRENT_DATE,'YEAR')- 1 + LEVEL AS DAY
FROM 
  DUAL 
CONNECT BY LEVEL<=365;

DAY
---------
01-JAN-10
02-JAN-10
03-JAN-10
04-JAN-10
05-JAN-10
...