Re: Uses of Dual

From: Phil Herring <revdoc_at_uow.edu.au>
Date: 1996/08/21
Message-ID: <4vg5i2$5sf_at_wabbit.its.uow.edu.au>#1/1

In article <01bb8f9a$f0fa6d60$80c270ce_at_rasta.access.one.net> Chad Brack, cbrack_at_us.oracle.com writes:
>Selecting from dual is used for the computing of any constant expression.
>Since dual only has one row, the result of the expression is returned only
>one. 'select :variable * 9000 from dual', 'select sysdate + 1 from dual',
>etc.

It's also common to get SYSDATE this way.

For a cruel practical joke, try adding an extra row to DUAL :-)

---

Copyright 1996 Phil Herring. This article may not be reproduced for profit.

---

Received on Wed Aug 21 1996 - 00:00:00 CEST