Re: a basic question

From: Mark Will <Mark.Will_at_gems6.gov.bc.ca>
Date: Mon, 20 Sep 1999 13:54:42 -0700
Message-ID: <1Ja7Jvt+xAi+@vmsmail.gov.bc.ca>

It's just a "dummy" table that is always available so you can use the select statement to test functions (e.g., math, string, etc.) that don't necessarily need data from a table.

For example:

    select power(2,3) from dual;

let's you see how the power function works.

---

Mark Will
Mark.Will_at_gems6.gov.bc.ca.

paul cluiss <paul_cluiss_at_intervoice.com> wrote in message news:65147E123DB33F5E.42E3B155B2909B25.F596E455BFB0E46D_at_lp.airnews.net...
> Hello all,
>
> I have a basic Oracle question:
>
> What is 'dual'? I've done a bit if reading from general purpose (IE,
> non-Oracle specific) SQL books and they never mention the 'dual' table,
> but I see it cropping up again and again in computations, so please,
> enlighten me. What is dual? Mine currently has one field called
> 'dummy' and has a value of 'X'.
>
> Sincerely,
>
> Paul Cluiss
> Dallas, Texas
>
Received on Mon Sep 20 1999 - 15:54:42 CDT