Re: Seeing double output in SELECT SYSDATE FROM DUAL;

From: Frank <fvanbortel_at_netscape.net>
Date: Thu, 02 Oct 2003 21:39:28 +0200
Message-ID: <blhugj$qoc$1_at_news1.tilbu1.nb.home.nl>


Yaroslav K. Kravchishin wrote:

> Oracle 7.0.1 Server
> When I type
> SQL> select sysdate from dual;
>
> SYSDATE
> ---------
> 01-OCT-03
> 01-OCT-03
>
> 2 rows selected.
>
> SQL>
>
> What's wrong? It's was Ok yesterday. I suppose that system.dual loads
> two times. How to fix it?
The usual way to deal with duplicates.
Or, as you only have 2 records, something like delete from dual where rowid =(select max(rowid) from dual);

-- 
Regards, Frank van Bortel
Received on Thu Oct 02 2003 - 21:39:28 CEST

Original text of this message