Re: What is the table "dual"

>I have seen a sql-scripr that looks like this:
>
>select to_number (':FraMnd'||'01') StartDato from dual;
>
>what is "dual".
>-

DUAL is a table with one column (DUMMY VARCHAR2(1)) usually owned by SYS.

Usually used to retrurn just one value from a function like
SELECT sysdate FROM dual;
or
SELECT my_sequence.nextval FROM dual;

John Received on Fri Nov 21 1997 - 00:00:00 CST