复制代码 代码如下:
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
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
