循环操作

create or replace procedure test_insert(v_gcdzj number,v_cdzj number) is

  num number := 1;
  cursor test_cur is
    SELECT t.*
      FROM xlzx_nrwh t
     WHERE t.gcdzj = v_gcdzj
       and t.cdzid = v_cdzj
     order by t.bt;
begin

  for test_rec in test_cur
   loop
    update xlzx_nrwh a set a.bt = num||'_'|| a.bt WHERE a.nrzj = test_rec.nrzj;
    num := num + 1;
  end loop;

  commit;
end test_insert;