先创建表:
CREATE TABLE TB_USER
(
ID INTEGER PRIMARY KEY,
USER_NAME VARCHAR2(20) NOT NULL,
USER_AGE INTEGER NOT NULL
);
CREATE SEQUENCE SEQ_USER
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 10;
CREATE OR REPLACE TRIGGER TR_USER BEFORE INSERT ON TB_USER FOR EACH ROW
BEGIN
SELECT SEQ_USER.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
然后,用loop循环来插入数据:
DECLARE
V_AGE TB_USER.USER_AGE%TYPE;
V_NAME TB_USER.USER_NAME%TYPE;
V_COUNT INTEGER:=0;
BEGIN
LOOP
SELECT DBMS_RANDOM.value(1, 100) INTO V_AGE FROM DUAL;
V_NAME := 'USER_' || V_AGE;
INSERT INTO TB_USER(USER_NAME, USER_AGE) VALUES (V_NAME, V_AGE);
EXIT WHEN V_COUNT = 100;
V_COUNT := V_COUNT+1;
END LOOP;
COMMIT;
END;