Miscellany

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