如何在oracle中删除计算日期的周末

CREATE OR REPLACE PROCEDURE delete_weekend_dates(start_date IN DATE, end_date IN DATE) IS
  v_date DATE := start_date;
BEGIN
  WHILE v_date <= end_date LOOP
    IF TO_CHAR(v_date, 'Dy', 'NLS_DATE_LANGUAGE=American') IN ('Sat', 'Sun') THEN
      DELETE FROM your_table WHERE date_column = v_date;
    END IF;
    v_date := v_date + 1;
  END LOOP;
  COMMIT;
END;

BEGIN
  delete_weekend_dates(TO_DATE('2022-01-01', 'YYYY-MM-DD'), TO_DATE('2022-12-31', 'YYYY-MM-DD'));
END;