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 was Ok yesterday. I suppose that system.dual loads
two times. How to fix it?

[Daniel Roy]

Re: Seeing double output in SELECT SYSDATE FROM DUAL

Make sure that you have only one row in DUAL. Your output makes me
think that you might have 2 rows.

Daniel

[Ed prochak]

Re: Seeing double output in SELECT SYSDATE FROM DUAL

gremmy@mail.ru (Yaroslav K. Kravchishin) wrote in message news:<c67afe59. 0310010515.45aa bc1b@posting.go ogle.com>...

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 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

[Yaroslav K. Kravchishin]

Re: Seeing double output in SELECT SYSDATE FROM DUAL

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 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:

SQLtruncate table dual;
SQLinsert into dual values ('1');

It works.