create sequence seq_name increment by 1 start with 1 maxvalue 10000000 no cycle cache 10
两种方法 方法一: 用触发器建一个序列 create sequence a_seq increment by 1 start with 100; 建一个触发器 create or replace trigger t_a before insert on a for each row begin select s_a.nextval into :new.b from dual; end;方法二: 建一个序列 create sequence a_seq increment by 1 start with 100; 使用 insert into tbl(id,....) values (a_seq.nextval,....)
“先建一个序列 create sequence seq_name ...然后执行 insert into table values(seq_name.nextval,.....)seq_name.nextval会自动增加,”这样的结果是每次加20,不是加1
你查一下你的序列中increment by 1是还是increment by 20increment by 1 ---加1 increment by 20 ---加20
increment by 1
start with 1
maxvalue 10000000
no cycle
cache 10
方法一:
用触发器建一个序列
create sequence a_seq increment by 1 start with 100;
建一个触发器
create or replace trigger t_a
before insert on a
for each row
begin
select s_a.nextval into :new.b from dual;
end;方法二:
建一个序列
create sequence a_seq increment by 1 start with 100;
使用
insert into tbl(id,....)
values (a_seq.nextval,....)
create sequence seq_name ...然后执行
insert into table values(seq_name.nextval,.....)seq_name.nextval会自动增加,”这样的结果是每次加20,不是加1
increment by 20 ---加20