Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: Select from dual return 3 rows !

Re: Re: Select from dual return 3 rows !

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 8 Nov 2005 06:55:47 -0500
Message-ID: <9177895d0511080355r24e3fbecmcc3b8dc47f5d837f@mail.gmail.com>


probably system owns a table called dual ... check that first.

Raj

On 11/8/05, Frank B Hansen <frank4oraclel_at_yahoo.dk> wrote:
>
> Hi David
> OK. Next question and some additional info:
> It is only when connected as SYSTEM that 3 rows are returned. If I
> connect as SYS og SCOTT, only 1 row is returned.
> A select from x$dual returns one row:
> sys_at_HCRD9397> select * from x$dual;
> ADDR INDX INST_ID D
> -------- ---------- ---------- -
> 01B74DC8 0 1 X
> and the question:
> How do I delete row number the second and third row from dual ?
> Thanks,
> Frank
>
>
> *David Sharples <davidsharples_at_gmail.com>* skrev:
>
> someone inserted 2 extra rows into dual, find them and tell them politely
> not to do it again.
> Then delete the other rows as you have a broken database right now
>
> On 11/8/05, Frank B Hansen <frank4oraclel_at_yahoo.dk> wrote:
> >
> > No matter what I select from dual, I get 3 rows. Anyone seen this
> > behaviour ?
> >
> >
>

--
----------------------------------------------
This space is available for rent.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 08 2005 - 05:57:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US