create or replace type numberlist as table of number;
/

Тип создан.

Затрач.время: 00:00:00.04

with s as
(select 1 id, numberlist(1,3,4,5,6) c from dual union all
 select 2 id, numberlist(7,8,9) c from dual
)
select id, column_value
from s,
table(select cast(collect(column_value) as numberlist) from table(s.c));

        ID COLUMN_VALUE
---------- ------------
         1            1
         1            3
         1            4
         1            5
         1            6
         2            7
         2            8
         2            9

8 строк выбрано.

Затрач.время: 00:00:00.02

--table(select cast(collect(column_value) as numberlist) from table(s.c));
table((s.c));