471,050 Members | 1,396 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

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 was Ok yesterday. I suppose that system.dual loads
two times. How to fix it?
Jul 19 '05 #1
3 9517
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
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
> > 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.

Similar topics

1 post 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
3 posts views Thread by Yaroslav K. Kravchishin | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.