Re: Uses of Dual
From: Venkateswara R Polisetti <vrao_at_sctcorp.com>
Date: 1996/08/21
Message-ID: <1996Aug21.151135.8490_at_mcrcr6>#1/1
Date: 1996/08/21
Message-ID: <1996Aug21.151135.8490_at_mcrcr6>#1/1
<adizon_at_mail.us.net> wrote:
>I know I can get the user's name by doing 'select user from dual' and I can
>also get the next sequence number with 'select seq.nextval form dual'. Are
>there any more uses of dual aside from these?
>Thanks.
>Lito Dizon
>adizon_at_us.net
You can as well use it for getting the sysdate, evaluating expressions, to test for a condition which involves date calculations etc. All that the dual table has is one column and one row.
Venkateswara Rao Received on Wed Aug 21 1996 - 00:00:00 CEST