1、创建序列
CREATE SEQUENCE hyhdld_seq
MINVALUE 1START WITH 1
INCREMENT BY 1
CACHE 10;
2、创建触发器
create or replace TRIGGER hyhdld_tri
BEFORE INSERT ON hyhdld
FOR EACH ROW
WHEN (NEW.ID IS NULL)
BEGIN
SELECT hyhdld_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
3、insert 语句的时候不用管id的值,其会自增。