Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table "183400_Matches_Details"("183400_Matches_number" integer, "date" date);
alter session set nls_date_format = 'yyyy-mm-dd'
create or replace 
procedure reschedule_sat_sun_match_details(
          p_match_number in "183400_Matches_Details"."183400_Matches_number"%type 
        , p_rows_updated out number)
as
begin
    update "183400_Matches_Details"
       set "date" = case to_char("date", 'dy') 
                         when 'sat' then "date"-1        -- Sat update to Fri
                         when 'sun' then "date"+1        -- Sun update to Mon
                    end  
    where to_char("date", 'dy') in ('sat','sun') 
      and "183400_Matches_number" = p_match_number;
 

  p_rows_updated := sql%rowcount;

end reschedule_sat_sun_match_details;
/
insert into  "183400_Matches_Details" ("183400_Matches_number" , "date")
  select level, sysdate -level + (7*level) 
    from dual connect by level <= 7;
7 rows affected

select "183400_Matches_number", "date" Scheduled_on ,to_char("date",'Day') day_of_week  from "183400_Matches_Details";


183400_Matches_number
SCHEDULED_ON
DAY_OF_WEEK


1
2020-06-15
Monday

2
2020-06-21
Sunday

3
2020-06-27
Saturday

4
2020-07-03
Friday

5
2020-07-09
Thursday

6
2020-07-15
Wednesday

7
2020-07-21
Tuesday


-- test 
declare
    v_number "183400_Matches_Details"."183400_Matches_number"%type;
    v_total_filas number(8);
begin
   v_number := 1;
   while v_number <= 7 
   loop
       reschedule_sat_sun_match_details(v_number, v_total_filas); 
       dbms_output.put_line('Match# ' || to_char(v_number)
                           || ' There are '  || to_char(v_total_filas) 
                           || ' updated rows'
                           );
        v_number :=  v_number +1; 
  end loop;                             
end;
/
1 rows affected

dbms_output:
Match# 1 There are 0 updated rows
Match# 2 There are 1 updated rows
Match# 3 There are 1 updated rows
Match# 4 There are 0 updated rows
Match# 5 There are 0 updated rows
Match# 6 There are 0 updated rows
Match# 7 There are 0 updated rows

select "183400_Matches_number", "date" Scheduled_on ,to_char("date",'Day') day_of_week  from "183400_Matches_Details";


183400_Matches_number
SCHEDULED_ON
DAY_OF_WEEK


1
2020-06-15
Monday

2
2020-06-22
Monday

3
2020-06-26
Friday

4
2020-07-03
Friday

5
2020-07-09
Thursday

6
2020-07-15
Wednesday

7
2020-07-21
Tuesday

183400_Matches_number	SCHEDULED_ON	DAY_OF_WEEK
1	2020-06-15	Monday
2	2020-06-21	Sunday
3	2020-06-27	Saturday
4	2020-07-03	Friday
5	2020-07-09	Thursday
6	2020-07-15	Wednesday
7	2020-07-21	Tuesday

183400_Matches_number	SCHEDULED_ON	DAY_OF_WEEK
1	2020-06-15	Monday
2	2020-06-22	Monday
3	2020-06-26	Friday
4	2020-07-03	Friday
5	2020-07-09	Thursday
6	2020-07-15	Wednesday
7	2020-07-21	Tuesday