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
Email me when people comment.
Email me when people comment.
Loading...
An error occurred in subscribing you.
Email me when people comment.
Email me when people comment.
Loading...
An error occurred in subscribing you.
CareerCup is the world's biggest and best source for software engineering interview preparation. See all our resources.
Open Chat in New Window
Open Chat in New Window