Dual - multiple rows

From: <g.renfrew_at_acca.org.uk>
Date: Thu, 02 Sep 1999 10:11:43 GMT
Message-ID: <7qligq$738$1@nnrp1.deja.com>

Hi everyone,

I'm running 7.3.2.3 on Solaris 2.6 and came across a bit of a weird problem with the DUAL table. When I selected from DUAL it always returned two identical rows. On all my other databases I would only ever expect one row returned, as is normal. This problem caused a couple of errors with "ora-1422: exact fetch returns more than requested number of rows". When I did "select * from dual" it returned the following:
DUMMY

X
x

Since all my other databases returned only 'X' I deleted from dual where DUMMY = 'x' and everything is ok now. Any ideas on how an extra row would appear in DUAL?

Best Regards
Graeme Renfrew
DBA
ACCA
Glasgow

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 02 1999 - 05:11:43 CDT