oracle19使用触发器和序列实现主键自增

最新推荐文章于 2024-05-04 08:19:01 发布

白菜菜菜菜菜

最新推荐文章于 2024-05-04 08:19:01 发布

阅读量755

点赞数

分类专栏：数据库相关文章标签： oracle 数据库 sql

本文链接：https://blog.csdn.net/weixin_41564625/article/details/125645468

版权

数据库相关专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.创建一个表

创建一个表，名为stu_info,字段如下：
在这里插入图片描述

2.创建一个序列

序列名为STU_DEQUENCE。

create sequence STU_DEQUENCE
minvalue 1
maxvalue 1
increment by 1
start with 1
nocache;

3.创建一个触发器

触发器名为：TRIGGER_STU_INSERT

create or replace TRIGGER TRIGGER_STU_INSERT
before insert on "stu_info"
for each row 
begin
select STU_DEQUENCE.nextval into :new."stu_id" from dual;
end;

4.插入内容

insert into "stu_info" ("stu_name","stu_sex","stu_age","stu_cls")
values('mary','1','14',2);
insert into "stu_info" ("stu_name","stu_sex","stu_age","stu_cls")
values('sola','1','14',3);
insert into "stu_info" ("stu_name","stu_sex","stu_age","stu_cls")
values('jieray','1','14',4);
insert into "stu_info" ("stu_name","stu_sex","stu_age","stu_cls")
values('tom','1','14',5);