Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sequence returns multiple numbers
> DUAL doesn't "works almost like any other table" - it *is* just
> another normal table, and as such it behaves *exactly* as any other
> table. So you can do anything with it, you can insert, update, delete
> (with or without the where clause, so your assumption about DELETE
> FROM DUAL WHERE .... is not correct!), you could even drop it! But you
> need appropritae privileges for all that.
That's true, except for one tiny little difference:
The query-optimizer always knows that DUAL is a small table without checking
the table statistics.
--
Erwin Dondorp
<http://www.wxs.nl/~erwindon>
Received on Sun May 16 1999 - 16:00:02 CDT
![]() |
![]() |