Seeing double output in SELECT SYSDATE FROM DUAL;

[Yaroslav K. Kravchishin]

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?

[Frank]

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