sql - Oracle: Can I select from a list of values? -

i know possible filter query list in select * table id in (1,2,3,4), possible select list?

for example, i'd select date , offset date list of offset hours:

select sysdate, sysdate - offset / 24 offsetsysdate dual, (1,2,3,4) offset 

i know can create table , populate values this, looking way on fly directly in query.

you can use database "table of number" type - either create 1 or use 1 handily exists sys.ku$_objnumset:

select sysdate, sysdate - offset.column_value / 24 offsetsysdate table (ku$_objnumset(1,2,3,4)) offset 

note above offset alias table, , there pseudo-column called column_value table types this. no need dual table.

if prefer create own type:

create type num_tab table of number; /  select sysdate, sysdate - offset.column_value / 24 offsetsysdate table(num_tab(1,2,3,4)) offset;