with t as(
select '1' seq, 'A' type, to_clob('aaa') col1, to_clob('') col2, to_clob('') col3 ,to_clob('') col4 from dual union all
select '1' , 'B' , to_clob(''), to_clob('bbb'),to_clob(''),to_clob('') from dual union all
select '1' , 'C' , to_clob(''), to_clob(''), to_clob('ccc'),to_clob('') from dual union all
SELECT '1' , 'D' , to_clob(''), to_clob(''), to_clob(''), to_clob('ddd') FROM dual 
)
SELECT seq,max(a),max(b),max(c),max(d) FROM (
SELECT seq,TYPE,to_char(col1)A,to_char(col2)b,to_char(col3)c,to_char(col4)d FROM t)
group by seq;

--필요한 부분일까 싶어서...올립니다.


clob 타입을 to_char로 변경해서 맥스지정하는부분임니당..

SELECT a.seq
     , a.col1
     , b.col2
     , c.col3
     , d.col4
  FROM (SELECT seq, col1 FROM t WHERE type = 'A') a
     , (SELECT seq, col2 FROM t WHERE type = 'B') b
     , (SELECT seq, col3 FROM t WHERE type = 'C') c
     , (SELECT seq, col4 FROM t WHERE type = 'D') d
 WHERE a.seq = b.seq
   AND a.seq = c.seq
   AND a.seq = d.seq
;