SV: Re: Select from dual return 3 rows !
- From: Frank B Hansen <frank4oraclel@xxxxxxxx>
- To: David Sharples <davidsharples@xxxxxxxxx>
- Date: Tue, 8 Nov 2005 12:17:51 +0100 (CET)
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:
- » SV: Re: Select from dual return 3 rows !
