-- 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;--新聞熱點
疑難解答
