Re: Uses of Dual

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.

Chad Brack
adizon_at_mail.us.net wrote in article <20830.adizon_at_mail.us.net>...
> 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?
Received on Wed Aug 21 1996 - 00:00:00 CEST