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?
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?
use the following
select level from dual connect by level<=2
try selecting it from dual(dummy table) it will work..Was a good question..keep posting...
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.