Oracle 23c

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

CREATE TABLE my_table (
  id integer, 
  order_date date, 
  total integer,
  ytd_total integer  
); 
insert into my_table values (123, to_date('2022-01-01', 'yyyy-mm-dd'), 50, null);
1 rows affected

insert into my_table values (123, to_date('2022-02-01', 'yyyy-mm-dd'), 25, null);
1 rows affected

insert into my_table values (123, to_date('2023-08-01', 'yyyy-mm-dd'), 60, null);
1 rows affected

insert into my_table values (123, to_date('2023-09-01', 'yyyy-mm-dd'), 50, null);
1 rows affected

insert into my_table values (123, to_date('2023-10-01', 'yyyy-mm-dd'), 20, null);
1 rows affected

select * from my_table


ID
ORDER_DATE
TOTAL
YTD_TOTAL


123
01-JAN-22
50
null

123
01-FEB-22
25
null

123
01-AUG-23
60
null

123
01-SEP-23
50
null

123
01-OCT-23
20
null


update my_table a
 set ytd_total = (select running_total
  from (
   select
    id, 
    order_date, 
    sum(total) over (partition by id, extract(year from order_date) order by order_date) as running_total
   from my_table
  )b
where a.id = b.id
 and a.order_date = b.order_date
);
   
5 rows affected

select *
from my_table


ID
ORDER_DATE
TOTAL
YTD_TOTAL


123
01-JAN-22
50
50

123
01-FEB-22
25
75

123
01-AUG-23
60
60

123
01-SEP-23
50
110

123
01-OCT-23
20
130

ID	ORDER_DATE	TOTAL	YTD_TOTAL
123	01-JAN-22	50	null
123	01-FEB-22	25	null
123	01-AUG-23	60	null
123	01-SEP-23	50	null
123	01-OCT-23	20	null