假设您的表被调用t1,您的主键被称为idFirst,创建序列:
create sequence t1_seq start with 1 increment by 1 nomaxvalue;
create trigger t1_trigger
before insert on t1
for each row
begin
select t1_seq.nextval into :new.id from dual;
end;
将自动增量主键添加到oracle中的现有表中
假设您的表被调用t1,您的主键被称为idFirst,创建序列:
create sequence t1_seq start with 1 increment by 1 nomaxvalue;
create trigger t1_trigger
before insert on t1
for each row
begin
select t1_seq.nextval into :new.id from dual;
end;