473,387 Members | 1,456 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 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 9809
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bliss | last post by:
Hi All, I have a table Truck_Journey with the following structure Tj_Date Date Tj_Truck_Id Number(5) Tj_Truck_No Varchar2(10) Tj_Km Number(9) ....
1
by: Yaroslav K. Kravchishin | last post by:
Oracle 7.0.1 Server When I type SQL> select sysdate from dual; SYSDATE --------- 01-OCT-03 01-OCT-03 2 rows selected.
3
by: Arthur | last post by:
Hey Everyone, Is this an Oracle bug? Here is my cursor statement: CURSOR tax_portal_cursor IS SELECT * FROM web_payment@remotedb WHERE caps_code IN ( SELECT * FROM TABLE(CAST(l_caps_codes...
3
by: George | last post by:
Hi, The sql query below returns data in the 'note' field from a table called ww_rec_1 from the previous month and displays the sum of hours for each category. SELECT note,SUM(hours)FROM...
13
by: Joey Martin | last post by:
I'm sure this has to be a simple fix. I just cannot figure it out. To resolve the typical apostrope issue, I have the acarriername = Replace(txtcarriername.text, "'", "''") My problem is that...
2
by: raj | last post by:
Hi all, I'm using this code to import some a .txt files onto a webpage, but I keep seeing single quotes amd double quotes as question marks. Here's the code: <textarea disabled="disabled"...
3
by: Yaroslav K. Kravchishin | last post by:
Oracle 7.0.1 Server When I type SQLselect sysdate from dual; SYSDATE --------- 01-OCT-03 01-OCT-03 2 rows selected.
2
by: sanQUEST | last post by:
hi, If I can create a dual table ,then why can't I select from it? like :select sysdate from dual ? thanks sanQUEST
1
by: karuppiah | last post by:
Hi All, i need query,how to select last 3 month ,last 3wek,last 3 days , this last 3 month and 3 week should be friday, using sysdate from dual table, there is no exsting table, pls any one help...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.