By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,341 Members | 1,395 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,341 IT Pros & Developers. It's quick & easy.

Seeing double output in SELECT SYSDATE FROM DUAL;

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.