create or replace type vtyp as varray(10) of number;
/
drop table t;
create  table t (id integer, val vtyp);
insert into t values (1, vtyp(10,20,30));
insert into t values (2, vtyp(11,22));
insert into t values (3, vtyp(31));
commit;

SQL> col val format a30
SQL> select * from t;
        ID VAL
---------- ------------------------------
         1 VTYP(10, 20, 30)
         2 VTYP(11, 22)
         3 VTYP(31)

3 rows selected.

SQL> select id, x.column_value elem
  2  from t, table(val) x
  3  /
        ID       ELEM
---------- ----------
         1         10
         1         20
         1         30
         2         11
         2         22
         3         31

6 rows selected.

SQL> with 
  2    data as (
  3      select id, x.column_value elem,
  4             row_number() over (partition by id order by null) rn
  5      from t, table(val) x
  6    )
  7  select id,
  8         nvl(max(decode(rn, 1, elem)),0) v1,
  9         nvl(max(decode(rn, 2, elem)),0) v2,
 10         nvl(max(decode(rn, 3, elem)),0) v3
 11  from data
 12  group by id
 13  order by id
 14  /
        ID         V1         V2         V3
---------- ---------- ---------- ----------
         1         10         20         30
         2         11         22          0
         3         31          0          0

3 rows selected.