ORA-01400: 無法将 NULL 插入 ("S01"."A02_EMPLOYEES"."ID") 錯誤

這是建立sequence

​

1 create sequence TEST_SEQ

2

3 minvalue 1

4

5 maxvalue 999999999999999999999999999

6

7 start with 1

8

9 increment by 1

10

11 cache 20;

這是建立trigger的

CREATE OR REPLACE TRIGGER " TEST_TRI" BEFORE

        INSERT ON TEST

        FOR EACH ROW       

BEGIN

          SELECT test_seq.NEXTVAL INTO :NEW.ID FROM DUAL;

        END;