Oracle 23c

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

create table tbl9 ( dt date, prin varchar2(20), int varchar2(20));
insert into tbl9 values(to_date('01-01-2023','dd-mm-yyyy'),100000, 1100);
1 rows affected

insert into tbl9 values(to_date('01-02-2023','dd-mm-yyyy'),100000, 1200);
1 rows affected

insert into tbl9 values(to_date('01-03-2023','dd-mm-yyyy'),100000, 1500);
1 rows affected

insert into tbl9 values(to_date('01-04-2023','dd-mm-yyyy'),100000, 2300);
1 rows affected

SELECT dt,prin, int, prin - SUM(int) OVER(PARTITION BY prin ORDER BY dt) bal
FROM tbl9


DT
PRIN
INT
BAL


01-JAN-23
100000
1100
98900

01-FEB-23
100000
1200
97700

01-MAR-23
100000
1500
96200

01-APR-23
100000
2300
93900

DT	PRIN	INT	BAL
01-JAN-23	100000	1100	98900
01-FEB-23	100000	1200	97700
01-MAR-23	100000	1500	96200
01-APR-23	100000	2300	93900