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 (DY)';
CREATE TABLE t_video 
(
  video_id       NUMBER NOT NULL ENABLE, 
  video_duration INTERVAL DAY(0) TO SECOND(0), 
  object_video   VARCHAR2(1000 BYTE), 
  CONSTRAINT T_VIDEO_PK PRIMARY KEY ( VIDEO_ID )
);
INSERT INTO t_video (video_id, video_duration, object_video)
VALUES (1, INTERVAL '00:12:20' HOUR TO SECOND,'song');
1 rows affected

INSERT INTO t_video (video_id, video_duration, object_video)
VALUES (2, INTERVAL '02:50:30' HOUR TO SECOND,'film');
1 rows affected

SELECT video_id,                               
       SUM(
         EXTRACT(HOUR   FROM video_duration) * 60 * 60
       + EXTRACT(MINUTE FROM video_duration) * 60
       + EXTRACT(SECOND FROM video_duration)
       ) * INTERVAL '1' SECOND AS total_duration
FROM   t_video
GROUP BY ROLLUP(video_id);


VIDEO_ID
TOTAL_DURATION


1
+000000000 00:12:20.000000000

2
+000000000 02:50:30.000000000

null
+000000000 03:02:50.000000000


SELECT video_id,                               
       CAST(
         SUM(
           EXTRACT(HOUR   FROM video_duration) * 60 * 60
         + EXTRACT(MINUTE FROM video_duration) * 60
         + EXTRACT(SECOND FROM video_duration)
         ) * INTERVAL '1' SECOND
         AS INTERVAL DAY(1) TO SECOND (0)
       ) AS total_duration
FROM   t_video
GROUP BY ROLLUP(video_id);


VIDEO_ID
TOTAL_DURATION


1
+0 00:12:20

2
+0 02:50:30

null
+0 03:02:50

VIDEO_ID	TOTAL_DURATION
1	+000000000 00:12:20.000000000
2	+000000000 02:50:30.000000000
null	+000000000 03:02:50.000000000