Oracle 11g Release 2

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

create table numbers ( id_, value_ ) as
select '001',    125698 from dual union all
select '002',   5698233 from dual union all
select '001', 896398233 from dual ;
3 rows affected

select 
  numtodsinterval( sum( value_ ), 'second' ) 
from numbers
where id_ = '001'
;


NUMTODSINTERVAL(SUM(VALUE_),'SECOND')


+000010376 10:25:31.000000000


select
  extract( day from interval_ )    || ':' ||
  extract( hour from interval_ )   || ':' ||
  extract( minute from interval_ ) || ':' ||
  extract( second from interval_ ) dhms
from (
  select 
    numtodsinterval( sum( value_ ), 'second' ) interval_
  from numbers
  where id_ = '001'
)
;


DHMS


10376:10:25:31