In oracle: employees table contain more than 10 million data. For update I'm using
rownum for faster update.
CREATE OR REPLACE PROCEDURE emp_up AS begin loop update employees set commission_pct=0 where commission_pct is null and rownum <=10000; exit when sql%notfound; commit; end loop; end;
In postgresql: postgresql does not support rownum. Is there any way to update employees table in postgres with the similar way in oracle?