Re: Seeing double output in SELECT SYSDATE FROM DUAL
From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 1 Oct 2003 11:55:57 -0700
Message-ID: <4b5394b2.0310011055.3a3180b9_at_posting.google.com>
Date: 1 Oct 2003 11:55:57 -0700
Message-ID: <4b5394b2.0310011055.3a3180b9_at_posting.google.com>
gremmy_at_mail.ru (Yaroslav K. Kravchishin) wrote in message news:<c67afe59.0310010515.45aabc1b_at_posting.google.com>...
> 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 was Ok yesterday. I suppose that system.dual loads
> two times. How to fix it?
Somebody inserted another row into dual.
Delete it.
Ed Prochak Received on Wed Oct 01 2003 - 20:55:57 CEST