首先建一个测试表格
‘
接下来
create sequence sq1;
create or replace trigger tr2 before insert on ceshi for each row
declare i number;
begin
while(new.id is null )
select sq1.nextval into :new.id from dual;
end;
首先建一个测试表格
‘
接下来
create sequence sq1;
create or replace trigger tr2 before insert on ceshi for each row
declare i number;
begin
while(new.id is null )
select sq1.nextval into :new.id from dual;
end;