Oracle 11g Release 2

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

CREATE TABLE fish ( fish_id INT, fish_type VARCHAR2(3), fish_weight INT);
BEGIN
  INSERT INTO fish VALUES(1,'COD',20);
  INSERT INTO fish VALUES(1,'HAD',30);
  INSERT INTO fish VALUES(2,'COD',45);
  INSERT INTO fish VALUES(2,'HKE',10);
  INSERT INTO fish VALUES(2,'LIN',55);
  INSERT INTO fish VALUES(3,'CTY',90);
  INSERT INTO fish VALUES(3,'HAD',60);
  INSERT INTO fish VALUES(3,'COD',52);
END;  
/
1 rows affected

SELECT * 
  FROM fish e
 PIVOT
 (
  MAX(fish_weight) FOR fish_type IN ( 'COD' AS "COD",'CTY' AS "CTY",'HAD' AS "HAD",
                                      'HKE' AS "HKE",'LIN' AS "LIN" )
 )


FISH_ID
COD
CTY
HAD
HKE
LIN


1
20
null
30
null
null

2
45
null
null
10
55

3
52
90
60
null
null

FISH_ID	COD	CTY	HAD	HKE	LIN
1	20	null	30	null	null
2	45	null	null	10	55
3	52	90	60	null	null