oracle sequence trigger创建 用于插入时自

-- Create sequence 
create sequence TEST_INFO_ID
minvalue 1
maxvalue 999999999999
start with 1
increment by 1
nocache;

-- Create trigger
CREATE OR REPLACE TRIGGER "INSERT_TEST_INFO_ID" 
    BEFORE INSERT ON TEST_INFO 
    REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
BEGIN
    if :NEW."ID" is null then
    SELECT TEST_INFO_ID.NEXTVAL INTO :NEW."ID" FROM DUAL;
    end if;
END;