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');
-- //www.freelists.org/webpage/oracle-l