Re: Several rows from Dual

From: Joel <johowar1_at_gmail.com>
Date: Fri, 13 Feb 2009 03:02:32 -0800 (PST)
Message-ID: <15b46676-724e-4338-95c5-96eefbc9784b_at_d32g2000yqe.googlegroups.com>

On Feb 13, 3:56 am, Hans Mayr <mayr1..._at_gmx.de> wrote:
> Hi Maxim,
>
> Thanks. This is an elegant solution. However I wonder if there is a
> possibility which does not involve creating anything, just a plain
> "one sql statement solution" ...
>
> Best,
>
> Hans

does this count as a one sql statement solution?

select 123 as abc from dual
union
select 456 from dual
union
select 789 from dual; Received on Fri Feb 13 2009 - 05:02:32 CST