SELECT SUM(AMT)
FROM T
WHERE BETWEEN LAST_DAY(ADD_MONTHS(SYSDATE,-1))+1 AND SYSDATE -1
by 글쓴이
[2009.12.07 10:26:39]
하핫...감사합니다~ ^^
by 선모
[2009.12.07 10:48:15]
SELECT TRUNC(LAST_DAY(ADD_MONTHS(SYSDATE,-1))+1) + (LEVEL-1) AS DATETIME
FROM dual CONNECT BY LEVEL <= TRUNC(SYSDATE-1) - TRUNC(LAST_DAY(ADD_MONTHS(SYSDATE,-1))+1)