oracle 中
new.字段名 是啥意思, 例如下面的代码CREATE OR REPLACE TRIGGER T_EvaluationCon_insert BEFORE INSERT
ON EVALUATIONCON
FOR EACH ROW
Declare
n1 Number;
begin
select max(NORDERNUM)
into n1
from EvaluationCon
where NEVALUATIONINFOID=:new.NEVALUATIONINFOID; If n1 is not null Then
:New.NORDERNUM:=n1+1;
else
:New.NORDERNUM:=1;
end if;
end;
new.字段名 是啥意思, 例如下面的代码CREATE OR REPLACE TRIGGER T_EvaluationCon_insert BEFORE INSERT
ON EVALUATIONCON
FOR EACH ROW
Declare
n1 Number;
begin
select max(NORDERNUM)
into n1
from EvaluationCon
where NEVALUATIONINFOID=:new.NEVALUATIONINFOID; If n1 is not null Then
:New.NORDERNUM:=n1+1;
else
:New.NORDERNUM:=1;
end if;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货