CREATE TABLE TEST1 (ID NUMBER(8),NAME VARCHAR2(8));Table createdCREATE SEQUENCE TEST1_ID
INCREMENT BY 1
START WITH 1021
NOCACHE
NOCYCLE;Sequence createdINSERT INTO TEST1
VALUES (TEST1_ID.NEXTVAL,'MIKE');1 row insertedSELECT * FROM TEST1; ID NAME
--------- --------
1021 MIKE
INCREMENT BY 1
START WITH 1021
NOCACHE
NOCYCLE;Sequence createdINSERT INTO TEST1
VALUES (TEST1_ID.NEXTVAL,'MIKE');1 row insertedSELECT * FROM TEST1; ID NAME
--------- --------
1021 MIKE
CREATE OR REPLACE TRIGGER TRIGGER_TEST
BEFORE INSERT ON TEST1
FOR EACH ROW
BEGIN
SELECT TEST1_ID.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/