Oracle中查询本月星期5的所有日期列表的语句

代码如下:

SELECT * 
FROM (SELECT TRUNC(SYSDATE, 'mm') + ROWNUM - 1 DAYS 
FROM (SELECT LEVEL 
FROM DUAL 
CONNECT BY LEVEL <= 
TRUNC(LAST_DAY(SYSDATE)) - TRUNC(SYSDATE, 'mm') + 1)) 
WHERE TO_CHAR(DAYS, 'd') = '6' 

作者 scorpio3k