Re: Select from dual return 3 rows !

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