DECLARE cursor days IS SELECT
d
FROM
( SELECT TRUNC( TO_DATE( '2021-11-1', 'YYYY-mm-dd' ) ) + ROWNUM - 1 AS d FROM dual CONNECT BY ROWNUM <= 430 ) td
WHERE
TO_CHAR( td.D, 'd' ) IN ( 1, 7 );
BEGIN
FOR dc IN days
LOOP
INSERT INTO "HOLIDAYS"
VALUES
(sys_guid ( ), '管理员', 'superadmin', SYSDATE, NULL, NULL, NULL, dc.d );
END LOOP;
commit;
END;