查询每个月的第一天和最后一天

SQL > SELECT TO_DATE( ' 2008 ' || LPAD(RN, 2 , ' 0 ' ) || ' 01 ' , ' YYYY-MM-DD ' ) "FIRST_DAY",
  2          LAST_DAY(TO_DATE( ' 2008 ' || LPAD(RN, 2 , ' 0 ' ) || ' 01 ' , ' YYYY-MM-DD ' )) "LAST_DAY"
  3     FROM DUAL,
  4          (
  5           SELECT ROWNUM RN
  6             FROM DUAL
  7          CONNECT BY ROWNUM <= 12
  8          )OB
  9         ;