Oralce数据库ID字段自动递增.docVIP

Oracle数据库创建表ID字段的自动递增 将表t_uaer的字段ID设置为自增:(用序列sequence的方法来实现) ----创建表Create table t_user(Id number(6),userid varchar2(20),loginpassword varchar2(20),isdisable number(6)); ----创建序列create sequence user_seq increment by 1 start with 1nomaxvaluenominvaluenocache ----创建触发器create or replace trigger tr_userbefore insert on t_userfor each rowbeginselect user_seq.nextval into :new.id from dual;end; ----测试insert into t_user(userid,loginpassword, isdisable)values(ffll,liudddyujj, 0);insert into t_user(userid,loginpassword, isdisable)values(dddd,zhang, 0)select * from t_user;就可以看出结果。