RE: Magic Table

thanks for valuable information

----- Original Message -----
From: "Tony Andrews" <[email protected]>
To: "Oracle" <[email protected]>
Sent: Sunday, January 19, 2003 8:24 AM
Subject: [oracle] RE: Magic Table


> > Dual is not a table, it is an imaginary object, it does not exist, The
key
> word Dual is just used in place of a table.
>
> Actually, it IS a real table, owned by SYS.  One way to really screw up
> Oracle is to log in as SYS and insert another row into DUAL.  There is
> nothing really "magic" about DUAL, it is simply a table that is
> "guaranteed" to have exactly one row.  Any select that you can do with
DUAL
> you could just as well do with your own 1-row table (e.g. SELECT SYSDATE
> FROM my_one_row_table).
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or
> to unsubscribe send a blank email to %%email.unsub%%.
>


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].