Re: possible dual table problem

saropani_at_my-dejanews.com wrote in article <6m7tim$f29$1_at_nnrp1.dejanews.com>...
>> I think i know the problem. As you know the dual table must have only one row.
> Somehow another row has been inserted. So, all you have to do is just
delete
> one of them as SYS user,
>
> connect SYS/'passwd';
> DELETE FROM dual WHERE ROWNUM > 1;

DELETE FROM dual WHERE ROWNUM < 2;

rownum>1 will never work.

• Alexander I.Doroshko, aid_at_grant.kharkov.ua
  • Bank "Grant", Kharkov, Ukraine