Seeing double output in SELECT SYSDATE FROM DUAL;

[Yaroslav K. Kravchishin]

Oracle 7.0.1 Server
When I type
SQLselect 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]

Re: Seeing double output in SELECT SYSDATE FROM DUAL;

Yaroslav K. Kravchishin wrote:

Oracle 7.0.1 Server
When I type
SQLselect 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