469,578 Members | 1,869 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

Seeing double output in SELECT SYSDATE FROM DUAL;

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?
Jul 19 '05 #1
1 2836
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Yaroslav K. Kravchishin | last post: by
3 posts views Thread by Arthur | last post: by
3 posts views Thread by George | last post: by
13 posts views Thread by Joey Martin | last post: by
1 post views Thread by Yaroslav K. Kravchishin | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.