469,602 Members | 1,838 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 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 was Ok yesterday. I suppose that system.dual loads
two times. How to fix it?
Jul 19 '05 #1
3 9403
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 guiromero | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.