假设数据库student中Id为主键,每次自动新增
1、新建一个自增序列
create sequence student_id_seq increment by 1 start with 1;
2、创建一个触发器,每次自动添加
create or replace trigger trg_student before insert on student for each row when (new.id is null)
begin
select student_id_seq.nextval into :new.id from dual;
end; (注意为new)