Oracle使用触发器实现自增ID备忘录
userinfo表id需要实现自增效果1.创建序列
-- Create sequence create sequence seq_userinfominvalue 1start with 1increment by 1;
2.创建触发器
create or replace trigger tigger_userinfobefore insert on userinfo for each rowdeclarebegin select SEQ_userinfo.nextval into:New.id from dual; end tigger_userinfo;
页:
[1]