以下代码在运行时总是提示选项缺失或无效
如图:
代码1:
create or replace functioncheck_ID(departmentid in char)
return number
as
num number;
xnumber;
begin
select count(*) into x from departments
where departmentID=departmentid;
if x>0 then
num:=0;
else
num:=-1;
end if;
return(num);
end;
代码2:
create or replace tridder employeesIns after insert or update on employees for each rowdeclare num number;begin select count(*) into num from departments where departmentID=:NEW.departmentID; if num=0 then dbms_output.PUT_LINE('职员所在部门不存在'); end if;end;
第二段代码运行时也有同样的错误提示呢
追答create or replace tridder employeesIns
拼写错误。
触发器的单词是 TRIGGER 而不是 tridder