下面是一个触发器
create or replace trigger d_update
after delete or update of deptno on d
for each row
begin
if (updating and :old.deptno != :new.deptno) then
update e set deptno = :new.deptno where deptno = :old.deptno;
end if;
if deleting then
delete e when deptno = :old.deptno;
end if;
end;在编译的时候产生错误
SQL> show errors
Errors for TRIGGER SCOTT.D_UPDATE:
LINE/COL ERROR
-------- -------------------------------------
6/19 PL/SQL: ORA-00933: SQL 命令未正确结束
6/5 PL/SQL: SQL Statement ignored请问一下,上面的错误如何修改,谢谢
create or replace trigger d_update
after delete or update of deptno on d
for each row
begin
if (updating and :old.deptno != :new.deptno) then
update e set deptno = :new.deptno where deptno = :old.deptno;
end if;
if deleting then
delete e when deptno = :old.deptno;
end if;
end;在编译的时候产生错误
SQL> show errors
Errors for TRIGGER SCOTT.D_UPDATE:
LINE/COL ERROR
-------- -------------------------------------
6/19 PL/SQL: ORA-00933: SQL 命令未正确结束
6/5 PL/SQL: SQL Statement ignored请问一下,上面的错误如何修改,谢谢
解决方案 »
- SQL语句
- 商品最低报价与该报价供应商SQL
- SQL优化
- OracleParameterCollection 只接受非空的 OracleParameter 类型对象,不接受 OracleParameter 对象。
- Oracle多表联查分页
- oracle存储过程动态参数如何编写及如何引用动态参数
- 两个ORACLE 数据库之间访问问题!(急)
- 服务器可以连结,客户Normal可以连结,system及sys用户不能连结????
- 我装了10g,怎么没有像 DBA Studio/8i ,Management Console/9i这样的管理工具啊?
- for cursor_a in cursor_test loop这样的命名规则可取吗?
- 求一SQL语句
- exp 的時候 會把index也導出來嗎?
create or replace trigger d_update
after delete or update of deptno on d
for each row
begin
if (updating and :old.deptno != :new.deptno) then
update e set deptno = :new.deptno where deptno = :old.deptno;
end if;
if deleting then
delete from e where deptno = :old.deptno;
end if;
end;
after delete or update of deptno on d
for each row
begin
if (updating and :old.deptno != :new.deptno) then
update e set deptno = :new.deptno where deptno = :old.deptno;
end if;
if deleting then
delete e when deptno = :old.deptno;
end if;
end;
after delete or update of deptno on d
for each row
begin
if (updating and :old.deptno != :new.deptno) then
update e set deptno = :new.deptno where deptno = :old.deptno;
end if;
if deleting then
delete from e when e.deptno = :old.deptno;
end if;
end;
after delete or update of deptno on d
for each row
begin
if (updating and :old.deptno != :new.deptno) then
update e set deptno = :new.deptno where deptno = :old.deptno;
end if;
if deleting then
delete from e where e.deptno = :old.deptno;
end if;
end;
----》delete e where deptno = :old.deptno;