SELECT rq,to_char(rq,'day')
FROM (SELECT trunc(SYSDATE, 'year') + ROWNUM - 1 rq
FROM dual
CONNECT BY ROWNUM <= (trunc(SYSDATE, 'year') + INTERVAL '1' YEAR) - trunc(SYSDATE, 'year'))
WHERE to_char(rq, 'd') IN (1, 7)
适用于oracle
SELECT rq,to_char(rq,'day')
FROM (SELECT trunc(SYSDATE, 'year') + ROWNUM - 1 rq
FROM dual
CONNECT BY ROWNUM <= (trunc(SYSDATE, 'year') + INTERVAL '1' YEAR) - trunc(SYSDATE, 'year'))
WHERE to_char(rq, 'd') IN (1, 7)
适用于oracle