Re: Seeing double output in SELECT SYSDATE FROM DUAL

From: Yaroslav K. Kravchishin <gremmy_at_mail.ru>
Date: 2 Oct 2003 05:35:09 -0700
Message-ID: <c67afe59.0310020435.7f54e423_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

Ok. I found that later and have done:

SQL> truncate table dual;
SQL> insert into dual values ('1');

It works. Received on Thu Oct 02 2003 - 14:35:09 CEST

Original text of this message