Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot delete using rownum why ??????

626673Sep 24 2008 — edited Sep 24 2008
create 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 22 2008
Added on Sep 24 2008
5 comments
4,945 views