userinfo表id需要实现自增效果
1.创建序列
2.创建触发器
1.创建序列
-- Create sequence create sequence seq_userinfo minvalue 1 start with 1 increment by 1;
2.创建触发器
create or replace trigger tigger_userinfo before insert on userinfo for each row declare begin select SEQ_userinfo.nextval into:New.id from dual; end tigger_userinfo;
