在触发器里,如何把一个表的最大ID取出来,赋给另一个变量?
Create Or Replace Trigger After_insert_Receive
after insert on TB_SMS_RECEIVE
REFERENCING OLD AS old_v NEW AS new_v FOR EACH ROW
declare
ID Number;
begin
select ID:=max(ID) from TB_SMS_SURVEY;
end ;
不行啊
Create Or Replace Trigger After_insert_Receive
after insert on TB_SMS_RECEIVE
REFERENCING OLD AS old_v NEW AS new_v FOR EACH ROW
declare
ID Number;
begin
select ID:=max(ID) from TB_SMS_SURVEY;
end ;
不行啊
是不是应该写成select max(ID) into ID from TB_SMS_SURVEY;
select max(ID) into ID from TB_SMS_SURVEY;
end;
select max(ID) into ID from TB_SMS_SURVEY;
end;