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 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:
