oracle迴圈語句

迴圈語句示例

declare
v_rlt number(8) := -37;
begin
  <<fst_loop>>
  loop
    v_rlt := v_rlt + 1;
    if v_rlt < 37 then
      insert into tm_plan_month
        (pk_id, plan_id, dept_name, month, ratio, create_date, create_user)
      values
        (v_rlt + 1100, 1, 'Planungskosten', v_rlt, 0, sysdate, 'rootadmin');
      commit;
    end if;
  end loop fst_loop;
  dbms_output.put_line('LOOP迴圈已經結束！');
end;