--创建自增ID,名称为:表名_字段名_SEQ (创建序列) CREATE SEQUENCE testTable1_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE;
-- 为Insert操作创建触发器,无需在SQL语句里写NEXTVAL,名称为表名_INS_TRG (创建触发器)
CREATE OR REPLACE TRIGGER tkf_Log_INS_TRG BEFORE INSERT ON tkf_Log FOR EACH ROW WHEN(NEW.ID IS NULL)
BEGINSELECT TKF_LOG_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;