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;