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

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