1.创建user1表
create table user1(
id number primary key,
name varchar2(20)not null,
password varchar2(20) not null,
age number
);
2.创建序列
CREATE SEQUENCE USER_ID_SEQ INCREMENT BY 1 START WITH 1;
创建序列从1开始每次自增1
3.创建触发器
CREATE OR REPLACE TRIGGER TRG_USER1 BEFORE INSERT ON USER1 FOR EACH ROW BEGIN SELECT USER_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL; END TRG_USER1;
insert into user1(name,password,age) values('张三','2222',20);
执行成功,id不需要手动写入,实现自增。
PS:
删除触发器:
drop SEQUENCE USER_ID_SEQ
删除序列:
drop trigger TRG_USER1