CareerCup

I want to run a function that does that automatically for me until the condition is complete (condition is some update statement),if i have 2000 records and exit when condition should be counter<500;
so if i have 2000 records so counter will be 2000/500 =4
loop will execute for 4 times
update statement should consist of
update tablename set counter=1 where rownum<500

this process continues until the update condition is met

if i have 2000 records and exit when condition should be counter<500;
so if i have 2000 records so counter will be 2000/500 =4
loop will execute for 4 times
update statement should consist of
update tablename set counter=1 where rownum<500

this process continues until the update condition is met