Oracle 21c

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

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
create table tbl9 ( dt, prin, int) AS
  SELECT DATE '2023-01-01', 100000, 1100 FROM DUAL UNION ALL
  SELECT DATE '2023-02-01', 100000, 1200 FROM DUAL UNION ALL
  SELECT DATE '2023-03-01', 100000, 1500 FROM DUAL UNION ALL
  SELECT DATE '2023-04-01', 100000, 2300 FROM DUAL;
4 rows affected

SELECT dt,
       prin,
       int,
       FIRST_VALUE(prin) OVER (ORDER BY dt)
         - SUM(int) OVER (ORDER BY dt) AS bal
FROM   tbl9;


DT
PRIN
INT
BAL


2023-01-01 00:00:00
100000
1100
98900

2023-02-01 00:00:00
100000
1200
97700

2023-03-01 00:00:00
100000
1500
96200

2023-04-01 00:00:00
100000
2300
93900


SELECT dt,
       prin,
       int,
       bal
FROM   (
  SELECT t.*,
         ROWNUM AS rn
  FROM   (SELECT * FROM tbl9 ORDER BY dt) t
)
MODEL
  DIMENSION BY (rn)
  MEASURES (dt, prin, int, 0 AS bal)  
  RULES (
    bal[1]    = prin[1] - int[1],
    bal[rn>1] = prin[CV(rn) - 1] - int[CV(rn)]
  )  


DT
PRIN
INT
BAL


2023-01-01 00:00:00
100000
1100
98900

2023-02-01 00:00:00
100000
1200
98800

2023-03-01 00:00:00
100000
1500
98500

2023-04-01 00:00:00
100000
2300
97700

DT	PRIN	INT	BAL
2023-01-01 00:00:00	100000	1100	98900
2023-02-01 00:00:00	100000	1200	97700
2023-03-01 00:00:00	100000	1500	96200
2023-04-01 00:00:00	100000	2300	93900