SV: Re: Select from dual return 3 rows !

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 ?  

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 08 2005 - 05:19:56 CST