Re: Select from dual return 3 rows !

From: Yechiel Adar <adar76@xxxxxxxxxxxx>
Date: Wed, 09 Nov 2005 12:39:07 +0200

What Jared was saying is that even you can have more then one record in dual you still get only one record back. And Rudy proved that you get only the first record, whatever it is.

Adar Yechiel
Rechovot, Israel

Igor Neyman wrote:

Nope. What Jared was saying is that starting with particular version of Oracle, there is no way to create second (or third,...) row in dual. I.e., under 10.1 if you issue: insert into dual values('Y');

--
http://www.freelists.org/webpage/oracle-l

References:

RE: Select from dual return 3 rows !
From: Igor Neyman

Other related posts:

» Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !