Re: Select from dual return 3 rows !

On 11/8/05, Rudy Zung <Rudy.Zung@xxxxxxx> 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

Other related posts: