Q:

How To Find First Date of All MOnths In A Year

Hello every One i am trying to get Ist date of All months in A year 
Like  if Curretn year is 2012 and i want to get folowing results from a query
like
1-JAN-2012
1-FEB-2012
1-APR-2012
.
.
.
.
.
.
1-DEC-2012

Is there any one who can solve my problem thanks in advance

A:

Just for completeness - here's a simpler version:
select ADD_MONTHS(TRUNC(SYSDATE,'Y'),ROWNUM-1)
from dual connect by level <= 12;

A:

A calendar table is easier to use.  Where I work, for example, you'd just run this query.
select cal_date
from calendar
where year_of_date = 2012
  and day_of_month = 1;

There's a lot to be said for a query being obvious.

A:

Please try the following. You may want to tweak the date format/timezone
select to_date('2012/'||l||'/01', 'yyyy/mm/dd') 
from (select level l from dual connect by level < 13)

EDIT: As provided by the op in the comments, the current year needs to be taken rather than hardcoding it. The updated query is
SELECT L || '/01/' || TO_CHAR (SYSDATE, 'YYYY') DATESS FROM 
(SELECT LEVEL L FROM DUAL CONNECT BY LEVEL < 13)

