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 protected].