我有个意见,不用关触发器,在触发器里来一个判断。DECLARE
iid NUMBER;
BEGINif :NEW.Id is null then
SELECT Id.NEXTVAL INTO iid FROM DUAL;
:NEW.Id:=iid;
else
while Id.CURRVAL< :NEW.Id loop
SELECT Id.NEXTVAL INTO iid FROM DUAL;
end loop;
end if;你如果觉得好,不要忘了加分哦!哈哈
iid NUMBER;
BEGINif :NEW.Id is null then
SELECT Id.NEXTVAL INTO iid FROM DUAL;
:NEW.Id:=iid;
else
while Id.CURRVAL< :NEW.Id loop
SELECT Id.NEXTVAL INTO iid FROM DUAL;
end loop;
end if;你如果觉得好,不要忘了加分哦!哈哈
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货