Oracle 11g Release 2

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

create table test (date1 date);
insert into test values (to_date('22-OCT-19', 'dd-mon-yyyy') );
1 rows affected

insert into test values (to_date('21-OCT-19', 'dd-mon-yyyy') );
1 rows affected

insert into test values (to_date('20-OCT-19', 'dd-mon-yyyy') );
1 rows affected

insert into test values (to_date('17-OCT-19', 'dd-mon-yyyy') );
1 rows affected

update test 
set date1 = 
(
    case date1
       when to_date('22-OCT-19', 'dd-mon-yyyy') THEN to_date('23-OCT-19', 'dd-mon-yyyy')
       else date1
    end
);
4 rows affected

select * from test;


DATE1


23-OCT-19

21-OCT-19

20-OCT-19

17-OCT-19