创建表
CREATE table user_tr(
id int primary key,name varchar2(10),
gender varchar2(2),
phone number(11),
address varchar(20)
)
创建表的序列
start with 1
increment by 1
nocache;
创建触发器
before insert on user_tr
for each row when(new.id is null)
begin
select user_seq.nextval into:new.id from dual;
end;
通过插入数据测试成功
insert into user_tr(name,gender,phone,address) values('赵四','男',13074519901,'黄山');
insert into user_tr(name,gender,phone,address) values('香秀','女',13074519901,'观音山');
insert into user_tr(name,gender,phone,address) values('小刘能','女',13071514961,'普陀山');
insert into user_tr(name,gender,phone,address) values('刘大能','男',13071514451,'峨眉山');