oracle触发器

//触发器 hello world

create or replace trigger update_emp_trigger

after

update on employees

for each row(可以去掉，这代表每行都执行)

begin

dbms_output.put_line('hello world');

end;

//触发

update employees set salary=salary+100 where department_id=80;

//复习一下增删改

insert into employees values(1001,2000,'aa');

//插入触发器

create or replace trigger update_emp_trigger2

after

insert on employees

begin

dbms_output.put_line('hello world')；

end;

//new 和old的使用分别代表更新前和更新后的数据

create or replace trigger update_emp_trigger3

after

update on employees

for each row

begin

dbms_output.put_line('old' || :old.salary || ',' || 'new' || :new.salary);

end;

//

create or replace trigger delete_emp_trigger

before

delete on employees

for each row

begin

        insert into emp2

        values(:old.employee_id,:old.salary);

end;