oracle存储过程

定义oracle存储过程：

CREATE OR REPLACE 
PROCEDURE "V111111" AS
BEGIN
for x in 1 .. 200 loop
begin
INSERT INTO test_index ("ID", "FLOW_CODE", "CREATE_DATE") VALUES (SEQ_XXX.NEXTVAL, '100000' + x, TO_DATE('2019-11-27 10:52:54', 'SYYYY-MM-DD HH24:MI:SS'));
end;
end loop;
commit;
END;

执行存储过程：

begin
V111111;
end;

生成数据结果：