If you have N lines,
you can safely run:
delete from dual where rownum < N
in order to have only one remaining.
Pierre
g.renfrew_at_acca.org.uk wrote:
>
> 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 - 15:25:52 CDT
