how to update a column in my table by procedure in plsql using for loop?
<p>i was written  a code to without for loop,please provide me solution to update it by for loop,create or replace procedure PR_UPDATETBEMP(COMM IN NUMBER) AS</p>

<pre><code>begin
  UPDATE XX_TBEMP
  SET COMM=SAL*.05
  WHERE SAL BETWEEN 80000 AND 99999;
end PR_UPDATETBEMP;
</code></pre>