--先建一个序列: create sequence seq_name increment by 1 start with 1 maxvalue 999999999 nocycle cache 10--使用序列:insert into table(id,name) values(seq_name.nextval,'name'); --将自动增1
create table a(b int, cvarchar2(5));建一个序列create sequence a_seq increment by 1 start with 100;建一个触发器create or replace trigger t_abefore insert on afor each rowbeginselect s_a.nextval into :new.b from dual;end;
用序列来实现 --建序列: create sequence seq_name increment by 1 start with 1 maxvalue 99999999999 nocycle cache 10--调用: insert into table(id,name) values(seq_name.nextval,'名字');
create sequence seq_name
increment by 1
start with 1
maxvalue 999999999
nocycle
cache 10--使用序列:insert into table(id,name) values(seq_name.nextval,'name'); --将自动增1
--建序列:
create sequence seq_name
increment by 1
start with 1
maxvalue 99999999999
nocycle
cache 10--调用:
insert into table(id,name) values(seq_name.nextval,'名字');