本帖最后由 dan 于 2020-4-6 19:40 编辑
案例:
goods表当插入插入一条数据时,自动为这条数据添加自动增长的序列号。 案例用表: create table goods (id number primary key,gname varchar2(20) default '' not null,price number type varchar2(10)); 开始: create sequence goodId; create or replace trigger tri_goods_add /* 作用:当对某表添加数据时,会自动添加其主键 */ before insert on goods for each row begin select goodId.nextval into :new.id from dual; end; / 测试: insert into goods (gname) values ('tv'); insert into goods (gname) values ('tv2'); insert into goods (gname) values ('tv3'); |