Re: What is the table "dual"

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

dual is a small table with a single row and a single column. When you want to play around and just select a literal or pseudo-columns such as SysDate you can use dual as the table from which to "SELECT".

-- 
James "I'd rather fall off Ilustrada than ride any other horse" Petts