Re: Select from dual return 3 rows !

On 11/8/05, Rudy Zung <Rudy.Zung_at_efi.com> wrote:
>
> DUAL, when you really come down to it, is really just a table into which
> Oracle defaults with just a single record. However, because it is just a
> simple table, additional records can be inserted into it, as you have just
> discovered.
>

That is version dependent.

At least as far back as 8.1.7.4 <http://8.1.7.4>, there can be only one row in sys.dual.

Try it.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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