Re: Select from dual return 3 rows !

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Rudy.Zung@xxxxxxx
  • Date: Tue, 8 Nov 2005 20:45:54 +0000

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 <>, there can
be only one row in sys.dual.

Try it.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: