SQL> create or replace trigger employeesins
2 after insert,update on employees
3 declare
4 departmentid char;
5 begin
6 select departmentid into departmentid
7 from employeesins where departmentid=:new.departmentid;
8 if(departmentid is null) then
9 rollback;
10 end if;
11 end employeesins;
12 /
after insert,update on employees
*
ERROR 位于第 2 行:
ORA-00969: 缺少 ON 关键字
按提示修改逗号为or,运行 1 create or replace trigger employeesins
2 after insert or update on employees
3 declare
4 departmentid char;
5 begin
6 select departmentid into departmentid
7 from employeesins where departmentid=:new.departmentid;
8 if(departmentid is null) then
9 rollback;
10 end if;
11* end employeesins;
SQL> /
after insert or update on employees
*
ERROR 位于第 2 行:
ORA-04082: NEW 或 OLD 引用不允许在表层触发器中
2 after insert,update on employees
3 declare
4 departmentid char;
5 begin
6 select departmentid into departmentid
7 from employeesins where departmentid=:new.departmentid;
8 if(departmentid is null) then
9 rollback;
10 end if;
11 end employeesins;
12 /
after insert,update on employees
*
ERROR 位于第 2 行:
ORA-00969: 缺少 ON 关键字
按提示修改逗号为or,运行 1 create or replace trigger employeesins
2 after insert or update on employees
3 declare
4 departmentid char;
5 begin
6 select departmentid into departmentid
7 from employeesins where departmentid=:new.departmentid;
8 if(departmentid is null) then
9 rollback;
10 end if;
11* end employeesins;
SQL> /
after insert or update on employees
*
ERROR 位于第 2 行:
ORA-04082: NEW 或 OLD 引用不允许在表层触发器中
解决方案 »
- 请问Oracle11g怎么卸载????
- 导入dmp文件报错ORA-12154: TNS: 无法解析指定的连接标识符
- 帮忙看一下触发器
- 关于删除重复数据的问题
- 好煩人的問題!請教高手!
- 急需!!!求助SQL语句(在线等待)
- Oracle解析sql语句的过程?(问题解决好,还可以加分)
- 万分紧急,诸位大虾帮帮我这个笨老赵,在线等候~~~~
- win10系统使用VM虚拟机与win7使用VM虚拟机有什么不同
- SQL*PLUS求助:求薪水最高的第6名到第10名雇员
- 奇怪!!ORACLE 10G为什么我用IE无法打开管理控制台,而用MAXTHON却可以??????????
- 请教:oracle里面怎么判断表存在
2 after insert or update on employees for each row
3 declare
4 departmentid char(10);
5 begin
6 select departmentid into departmentid
7 from employeesins where departmentid=:new.departmentid;
8 if(departmentid is null) then
9 rollback;
10 end if;
11 end employeesins;
12 / 运行正确