A bozo's blog
select
distinct column_value from table(sys.odcinumberlist(1,1,2,3,3,4,4,5));
column_value from table(sys.dbms_debug_vc2coll(
'One'
,
'Two'
'Three'
'Four'
));