//触发器 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;