oracle 自增主键
一、创建表
???? create?table?tables(
???????????userid?number(10)?primary?key,??/*主键，自动增加*/
???????????username?varchar2(20)
???? );
?
二、创建序列
?? CREATE?SEQUENCE?id_Sequence
?????? INCREMENT?BY?1???--?每次加几个??
???? ??START?WITH?1?????--?从1开始计数??
???? ??NOMAXVALUE???????--?不设置最大值??
???????NOCYCLE??????????--?一直累加，不循环??
???? ??CACHE?10;?
三、创建触发器
CREATE?TRIGGER?id_trigger BEFORE
insert?ON??tables FOR?EACH?ROW
begin
select?id_Sequence.nextval?into:New.userid?from?dual;
end;
四、测试
insert?into?Test_Increase(Username)?values(null, 'test')
