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