select from list of values (ie. select * from(1,2))

[scranton]

i'm trying to figure out how to write a query like the following, but in a way that works:

select * from (1,2)

or

select (1,2) ...

the result i'm aiming for is
1
2

can this be done?

[debasisdas]

use the following

select level from dual connect by level<=2

[smokewire]

try selecting it from dual(dummy table) it will work..Was a good question..keep posting...