创建序列:
create sequence sequence_userid
increment by 1
start with 2021001
maxvalue 2021999
minvalue 2021001
cycle
cache 3
order;
查询序列:
select sequence_userid.nextval from dual;
删除序列:
drop sequence sequence_userid;
使用序列插入数据:
insert into t_user(userid,email,pwd) values(sequence_userid.nextval,'2456679756,‘123456’);
序列可用于数据库表设计使id自增:
insert into t_user(userid) values(sequence_userid.nextval);
创建触发器:
(可以使用在两个表有一个相同的属性列的情况,可以保证数据一致性问题)
create or replace trigger usertoinfo
after insert
on t_user
for each row
begin
insert into userinfo(userid) values(sequence_userid.currval);
end;