Oracle: select from list of values

select distinct column_value from table(sys.odcinumberlist(1,1,2,3,3,4,4,5));

or

select column_value from table(sys.dbms_debug_vc2coll('One', 'Two', 'Three', 'Four'));