DECLARE
x number;
BEGIN
x := 0;
LOOP
x := x+1;
EXIT WHEN x > 1000;
insert into t_name values(seq_name.nextval,'value0','value1' || x,0);
END LOOP;
commit;
--输出语句
DBMS_OUTPUT.put_line('END LOOP :x=' || x);
END;
oracle 循环demo
最新推荐文章于 2021-04-12 15:33:31 发布