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 dates (dt) AS
SELECT DATE '2024-09-23' FROM DUAL UNION ALL
SELECT DATE '2024-09-24' FROM DUAL UNION ALL
SELECT DATE '2024-09-25' FROM DUAL;
3 rows affected

CREATE TABLE seals (Dt, SECURITY_SEALS, NUM) AS
SELECT DATE '2024-09-23', 'SEAL_XXX', 133 FROM DUAL UNION ALL
SELECT DATE '2024-09-25', 'SEAL_XXX', 148 FROM DUAL UNION ALL
SELECT DATE '2024-09-24', 'SEAL_YYY', 123 FROM DUAL UNION ALL
SELECT DATE '2024-09-23', 'SEAL_ZZZ', 135 FROM DUAL UNION ALL
SELECT DATE '2024-09-24', 'SEAL_ZZZ', 147 FROM DUAL;
5 rows affected

SELECT d.dt,
       s.security_seals,
       LAST_VALUE(s.num) IGNORE NULLS OVER (
         PARTITION BY s.security_seals ORDER BY d.dt
       ) AS num
FROM   dates d
       LEFT OUTER JOIN seals s
       PARTITION BY (s.security_seals)
       ON (d.dt = s.dt);


DT
SECURITY_SEALS
NUM


2024-09-23 00:00:00
SEAL_XXX
133

2024-09-24 00:00:00
SEAL_XXX
133

2024-09-25 00:00:00
SEAL_XXX
148

2024-09-23 00:00:00
SEAL_YYY
null

2024-09-24 00:00:00
SEAL_YYY
123

2024-09-25 00:00:00
SEAL_YYY
123

2024-09-23 00:00:00
SEAL_ZZZ
135

2024-09-24 00:00:00
SEAL_ZZZ
147

2024-09-25 00:00:00
SEAL_ZZZ
147

DT	SECURITY_SEALS	NUM
2024-09-23 00:00:00	SEAL_XXX	133
2024-09-24 00:00:00	SEAL_XXX	133
2024-09-25 00:00:00	SEAL_XXX	148
2024-09-23 00:00:00	SEAL_YYY	null
2024-09-24 00:00:00	SEAL_YYY	123
2024-09-25 00:00:00	SEAL_YYY	123
2024-09-23 00:00:00	SEAL_ZZZ	135
2024-09-24 00:00:00	SEAL_ZZZ	147
2024-09-25 00:00:00	SEAL_ZZZ	147