Re: Select from dual.

From: Kevin <kevin_at_pacificdbms.com.au>
Date: Wed, 29 Nov 2000 10:03:12 +1000
Message-ID: <3a244f82$0$19402$7f31c96c@news01.syd.optusnet.com.au>

Hi,

It is possible, without the join. I have seen a database where someone has inserted a record into dual. Every select from dual returned multiple rows. From an application development point of view you could trap it and provide a suitable message "Select from dual returned multiple rows - Contact your DBA on xxxxx"

Regards,

Kevin
screwbai_at_my-deja.com wrote in message <900amu$kqi$1_at_nnrp1.deja.com>...
>
>
>if you "select 'A' from dual union select 'B' from dual".
>
>
>In article <8toumr$13eo$1_at_reader4.wxs.nl>,
> "Nicky Terwel" <nickyterwel_at_hotmail.com> wrote:
>> Hello,
>>
>> I've got a question. Is it possible to make a select from dual that
returns
>> mutiple rows?
>>
>> Thanks in advance.
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Nov 28 2000 - 18:03:12 CST