oracle 主键自增

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

导读：注意：new后面的和主键对应 CREATE TABLE item ( iid INT, title VARCHAR2(50), CONSTRAINT pk_iid PRIMARY KEY (iid) ); CREATE TABLE news ( nid INT, title VARCHAR2(50), pubdate DATE, content LONG, iid INT, CONSTRAINT pk_nid PRIMARY KEY (nid), CO

注意：new后面的和主键对应

CREATE TABLE item (
iid INT,
title VARCHAR2(50),
CONSTRAINT pk_iid PRIMARY KEY (iid)
);
CREATE TABLE news (
nid INT,
title VARCHAR2(50),
pubdate DATE,
content LONG,
iid INT,
CONSTRAINT pk_nid PRIMARY KEY (nid),
CONSTRAINT fk_iid FOREIGN KEY (iid) REFERENCES item (iid)
ON DELETE SET NULL
);
-- 测试数据

--create sequence customer_id_seq increment by 1 start with 1 ;

create or replace
trigger trg_item before insert on item for each row
begin
select CUSTOMER_ID_SEQ.nextval into :new. iid from dual;
end;
/
create or replace
trigger trg_news before insert on news for each row
begin
select CUSTOMER_ID_SEQ.nextval into :new.nid from dual;
end;

INSERT INTO item (title) VALUES ('aaa'); INSERT INTO item (title) VALUES ('体育新闻'); INSERT INTO item (title) VALUES ('娱乐新闻'); INSERT INTO item (title) VALUES ('财经新闻'); INSERT INTO item (title) VALUES ('科技新闻');

（编辑：李大同）

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