d27m11y d27m11y
asked on
First day of every month of all twelve months in one query..
How do I get first day of every month of all twelve months in one single query
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT NEXT_DAY(ADD_MONTHS(TRUNC(
FROM DUAL
CONNECT BY LEVEL <= 12