오라클의 listagg를 사용한 방법입니다.

with t (col1, col2, col3, col4, col5, col6) as (
select 'a', '01', 2, 0  , 0  , 5.8 from dual union all
select 'a', '02', 1, 100, 200, 5.8 from dual
)
select listagg(col3||'|'||col4||'|'||col5||'|'||col6, ':') within group(order by col2) 
  from t
 where col1 = 'a';

WITH t AS
(
SELECT 'a' grp, '01' seq, 2 v1, 0 v2, 0 v3, 5.8 v4 FROM dual
UNION ALL SELECT 'a', '02', 1, 100, 200, 5.8 FROM dual
)
SELECT grp
     , LISTAGG(v1 ||'|'|| v2 ||'|'|| v3 ||'|'|| v4, ';')
       WITHIN GROUP(ORDER BY seq) x
  FROM t
 GROUP BY grp
;