Re: Uses of Dual

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

I didn't know what DUAL was just a minute ago...

DUAL is a table consisting of a single row. It's purpose is to let you execute functions which do not rely on any "real" data in a table.

Therefore, you can do anything to DUAL - as long as you don't get or put data in it.

A strange concept indeed.
Happy trails,
Roderick... Received on Wed Aug 21 1996 - 00:00:00 CEST