Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Dual - multiple rows
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
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
![]() |
![]() |