CREATE TABLE T36
  (
    CUSTOMER_ID     VARCHAR2(5),
    DEVICE_SEQUENCE NUMBER(3),
    DEVICE_NAME     VARCHAR2(25)
  );

INSERT INTO T36 VALUES ('C1',1,'IPHONE 4S');
INSERT INTO T36 VALUES ('C1',2,'GALAXY TAB');
INSERT INTO T36 VALUES ('C1',3,'IPAD');
INSERT INTO T36 VALUES ('C2',1,'IPHONE 4G');
INSERT INTO T36 VALUES ('C2',2,'IPAD');

CUSTOMER_ID DEVICE_SEQUENCE DEVICE_NAME
C1	    1	            IPHONE 4S
C1	    2	            GALAXY TAB
C1	    3	            IPAD
C2	    1	            IPHONE 4G
C2	    2	            IPAD

CUSTOMER_ID  DEVICE_TYPE_1  DEVICE_TYPE_2  DEVICE_TYPE_3
C1           IPHONE 4S      GALAXY TAB     IPAD
C2           IPHONE 4G      IPAD           NULL

SELECT CUSTOMER_ID, 
       SUBSTR (DEVICE_NAME, 1, INSTR (DEVICE_NAME, ',', 1, 1)-1) AS DEVICE_TYPE_1,
       SUBSTR (DEVICE_NAME, 
               INSTR (DEVICE_NAME, ',', 1, 1) +1,
               (INSTR (DEVICE_NAME, ',', 1, 2)-1) - INSTR (DEVICE_NAME, ',', 1,1)) AS DEVICE_TYPE_2,
       SUBSTR (DEVICE_NAME, INSTR (DEVICE_NAME, ',', 1, 2)+1) AS DEVICE_TYPE_3              
FROM
(SELECT CUSTOMER_ID, LISTAGG (DEVICE_NAME, ',') WITHIN GROUP (ORDER BY DEVICE_SEQUENCE) AS DEVICE_NAME
FROM T36
GROUP BY CUSTOMER_ID);

CUSTOMER_ID  DEVICE_TYPE_1  DEVICE_TYPE_2  DEVICE_TYPE_3
C1           IPHONE 4S      GALAXY TAB     IPAD
C2           IPHONE 4G      NULL           IPHONE 4G,IPAD

SQL> select *
  2  from t36
  3  pivot (max(device_name)
  4         for device_sequence in
  5           (1 "DEVICE_TYPE_1",
  6            2 "DEVICE_TYPE_2",
  7            3 "DEVICE_TYPE_3"))
  8  order by customer_id
  9  /
CUSTO DEVICE_TYPE_1             DEVICE_TYPE_2             DEVICE_TYPE_3
----- ------------------------- ------------------------- -------------------------
C1    IPHONE 4S                 GALAXY TAB                IPAD
C2    IPHONE 4G                 IPAD

2 rows selected.