SELECT (StartDt + LEVEL -1) YMD,
DECODE(TO_CHAR((StartDt + LEVEL -1),'D'),
'7','六','6','五','5','四','4','三','3','二','2','一','1','日',
'') WK
FROM (
SELECT TRUNC(SYSDATE,'MM') StartDt , TRUNC(Last_day(sysdate),'DD') EndDt
FROM DUAL
)t1
CONNECT BY StartDt - EndDt + LEVEL <= 1;
文章標籤
全站熱搜
留言列表
