Re: select * from dual in MOUNTED database returns 4 columns (one row)

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 9 Jul 2002 16:52:03 +1000
Message-ID: <ODvW8.31126$Hj3.93369@newsfeeds.bigpond.com>

Hi Vsevolod,

I must admit I've never tried to select from dual before with an unopened database so I'm not sure what you are actually accessing (I suspect some internal dual like object). What I do know is that you are not accessing the dual table/synonym as this is only accessible with an open database so I would strongly suspect they are not one and the same.

Regards

Richard
"Vsevolod Afanassiev" <vafanassiev_at_aapt.com.au> wrote in message news:4f7d504c.0207082214.506816ea_at_posting.google.com...
> If a database is mounted (not opened), then
>
> select * from dual
>
> returns 4 columns (one row).
> However, when the database is opened,
>
> select * from dual
>
> returns one column only.
>
> I checked DBA_OBJECTS - there are only two objects with name DUAL,
> both in SYS schema, table and synonym.
>
> Thanks,
> Sev
Received on Tue Jul 09 2002 - 01:52:03 CDT