Oracle创建序列和触发器

发布时间：2020-12-12 15:19:38 所属栏目：百科来源：网络整理

导读：-- Create sequence 序列 create sequence P_id minvalue 0 maxvalue 9999999999999999999999999999 start with 54787617 increment by 1 cache 20; ---触发器 CREATE OR REPLACE TRIGGER P_TRR_ID BEFORE INSERT ON Person REFERENCING OLD AS OLD NEW AS N

-- Create sequence 序列
create sequence P_id
minvalue 0
maxvalue 9999999999999999999999999999
start with 54787617
increment by 1
cache 20;

---触发器

CREATE OR REPLACE TRIGGER P_TRR_ID BEFORE

INSERT ON Person REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW declare nextid number; begin select P_id.nextval into :new.ID from sys.dual; end P_TRR_ID; --

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!