Cannot delete using rownum why ??????
626673Sep 24 2008 — edited Sep 24 2008create table test(no int,name varchar2(25));
insert into test values(1,'aaaa');
insert into test values(2,'bbbb');
insert into test values(3,'cccc');
insert into test values(1,'dddd');
insert into test values(5,'aaaa');
delete from test where rownum=4;
0 rows deleted
i am unable to delete using rownum from the table pls help
Thanks
Rangan S