创建表

 CREATE TABLE CUST
   (	CUST_ID NUMBER,
	LAST_NAME VARCHAR2(30),
	FIRST_NAME VARCHAR2(30)
   ) ;

自动插入

DECLARE
  v_cust_id     NUMBER;
  v_last_name   VARCHAR2(30);
  v_first_name  VARCHAR(30);
BEGIN
  FOR i IN 1..1000 LOOP
    v_cust_id := i;
    v_last_name := 'Last' || TO_CHAR(i, 'FM000');
    v_first_name := 'First' || TO_CHAR(i, 'FM000');
    INSERT into cust (cust_id, last_name, first_name)
    VALUES (v_cust_id, v_last_name, v_first_name);
  END LOOP;
  COMMIT;
  
END;