-
delete rows by rownum
Hi. I have a tbale that contains 800K rows.
I want to delete the first 100K rows. I have written this script, but
it does not seem to work. Can someone assist or have another method ?
Thanks.
declare
cursor a1 is select 1 from dual;
x number:=1;
begin
for i in 1..100000 loop
delete t_bitmap1_hold where rownum=x;
end loop;
end;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|