Create table a ( Objectid number, Value varchar2(2000);
/

Insert into a values (12, '2,3,4');
Insert into a values (13, '8,7,4');
Insert into a values (14, '3,8,9');
Insert into a values (15, '6,3,11');

SELECT   distinct objectid,  REGEXP_SUBSTR (value, '[^,]+', 1, LEVEL) pivot_char
      FROM a  CONNECT BY REGEXP_SUBSTR (value, '[^,]+', 1, LEVEL) IS NOT NULL