坚守 法官职业道德:请问这个触发器脚本有什么语法错误!
来源:百度文库 编辑:高考问答 时间:2024/05/05 14:23:07
create or replace trigger Attach_trig_autoinc
before insert on Attachment
for each row
begin
if (:new.AttachID is null) then
select Attachment_seq.nextval into :new.AttachID from dual;
end if;
end;
before insert on Attachment
for each row
begin
if (:new.AttachID is null) then
select Attachment_seq.nextval into :new.AttachID from dual;
end if;
end;
我知道