root/trunk/sql/oracle/makeNumSeq.sql

CREATE OR REPLACE PROCEDURE makeNumSeq(maxNum INT) IS
BEGIN
  DECLARE i INT := 1;
  BEGIN
    DELETE FROM numSequence;
    WHILE i<=maxNum LOOP
      INSERT INTO numSequence (n) VALUES (i);
      i:=i+1;
    END LOOP;
  END;
END;
/

CALL makeNumSeq(500);