DECLARE
num1 INTEGER := 123;
CODE VARCHAR2(20) := '123';
BEGIN
FOR i IN 1..5 LOOP
INSERT INTO USER1.ORDER
(ID,
NUM)
VALUES (NUM1,CODE);
num1 :=num1 +1;
code :=code+1;
END LOOP;
COMMIT;
END;
DECLARE
num1 INTEGER := 123;
CODE VARCHAR2(20) := '123';
BEGIN
FOR i IN 1..5 LOOP
INSERT INTO USER1.ORDER
(ID,
NUM)
VALUES (NUM1,CODE);
num1 :=num1 +1;
code :=code+1;
END LOOP;
COMMIT;
END;