循环语句示例
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;