-- Create sequence 序列create sequence P_idminvalue 0maxvalue 9999999999999999999999999999start with 54787617increment by 1cache 20;
---触发器
CREATE OR REPLACE TRIGGER P_TRR_ID BEFORE
INSERT ON Person REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROWdeclarenextid number;beginselect P_id.nextval into :new.ID from sys.dual;end P_TRR_ID;--新闻热点
疑难解答