plsql跑触发器脚本会一直执行_PL / SQL触发器问题

你已经以块的形式展示了代码.但似乎你正在运行你作为一个脚本一起显示的内容,最初没有更新：

drop table SalUpdates cascade constraints;

create table SalUpdates(

SalSSN char(9),

newSalary decimal(10,2),

oldSalary decimal(10,2)

);

create or replace trigger t1

after update of salary on employee

for each row

begin

insert into SalUpdates values (:old.Ssn, :new.salary, :old.salary);

end;

在SQL Developer中作为脚本运行时,脚本输出窗口显示：

drop table SalUpdates cascade constraints

Error report -

ORA-00942: table or view does not exist

00942. 00000 - "table or view does not exist"

*Cause:

*Action:

Table SALUPDATES created.

Trigger T1 compiled

然后,如果您将更新语句添加到脚本：

drop table SalUpdates cascade constraints;

create table SalUpdates(

SalSSN char(9),

newSalary decimal(10,2),