create or replace procedure insert_dbz_two is cursor cur_dbz is select nvl(id,0) id,name,nvl(powerlevel,0) power,planet from dragonballz; i pls_integer ; begin i:= 1 ; for cur_rec in cur_dbz loop if cur_rec.id = 0 then update dragonballz set id = 1 , powerlevel = (i*22000); end if; i := i +1 ; end loop; end; / think it as only androids have id = 0 ,ok my friend