DROPTABLE WEEKEND;CREATETABLE WEEKEND
(WEEK_END DATE);
DECLARE
W DATE := TO_DATE('2016-12-01','YYYY-MM-DD');
W_D CHAR;
BEGIN
LOOP
SELECT TO_CHAR(W, 'D') INTO W_D FROM DUAL;
IF W_D = 1 OR W_D = 7 THEN
INSERTINTO WEEKEND VALUES (W);ENDIF;
W := W + 1;
IF TO_CHAR(W,'YYYY-MM-DD') = '2016-12-30' THEN
EXIT;
ENDIF;END LOOP;END;
/