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@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@xxxxxxxxx> 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@xxxxxxxx> wrote: No matter what I 
select from dual, I get 3 rows.  Anyone seen this behaviour ?

Other related posts: