RE: Magic Table

From asktom.oracle.com, about dual (magic) table:
http://asktom.oracle.com/pls/ask/f?p=4950:8:1887882::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:1562813956388,%7Bmagic%7D%20and%20%7Btable%7D



-----Original Message-----
From: Arun Kumar [mailto:[email protected]]
Sent: Thursday, January 16, 2003 10:58 PM
To: Oracle
Subject: [oracle] RE: Magic Table


Hi Sammy Msafiri,
Thanks for giving a Idea.
can u tell me that which table it refer as dual table ,
does we need to define any table to be used as dual table( magic table).
and what is scope and use of this functionality.
thanks
Arun
----- Original Message -----
From: "Sammy Msafiri" <[email protected]>
To: "Oracle" <[email protected]>
Sent: Tuesday, January 14, 2003 10:34 PM
Subject: [oracle] RE: Magic Table


> Most SQL statements in Oracle are based on a table.  There is some
> operations that does not access a table eg returning a system time or date
> or simply mathematical operations like adding two numbers etc.  All this
and
> other more operations are executed against the magic table which does not
> exist but atleast the sql statement will end with the key word "from Dual"
>
> eg
>
> select 40 + 50 as Results from Dual
>
> Cheers
>
> Sammy Msafiri
>
>
>
> ____________________________________________________________________
> - This email and any files transmitted with it are confidential and
>   intended solely for the use of the addressee. If you have received
>   this email in error you may not disclose, copy, distribute or act
>   upon its contents without the authors prior written consent. Please
>   can you notify the system manager at [email protected]
>   immediately and delete this email.
> - Any views or opinions expressed are those of the author and do not
>   necessarily represent those of Somak Travel Limited, Kenya.
> - This footnote also confirms that this email message has been swept
>   for the presence of computer viruses. No responsibility can be
>   accepted in the event that a virus is contained within it or any
>   attachments.
> - SOMAK TRAVEL LTD - KENYA
>   NAIROBI, PO BOX 48495. Tel: +(2542) 557832 Fax:+(2542) 535175
>   MOMBASA, PO BOX 90738. Tel: +(25411)5486197 Fax:+(25411)5487324
> ____________________________________________________________________
>
> ---
> 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.unsub%%.


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