By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,231 Members | 1,707 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,231 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 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+
3 Replies


P: n/a
Make sure that you have only one row in DUAL. Your output makes me
think that you might have 2 rows.

Daniel
Jul 19 '05 #2

P: n/a
gr****@mail.ru (Yaroslav K. Kravchishin) wrote in message news:<c6**************************@posting.google. com>...
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 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
Jul 19 '05 #3

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

SQL> truncate table dual;
SQL> insert into dual values ('1');

It works.
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.