创建表
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;