oracle触发器的简单使用

--------------创建触发器-------------------

create or replace trigger tri_emp_sal
before insert on test22
for each row
declare

begin
 
   dbms_output.put_line('启动了insert触发器!');

end;

---------------------------------

--------------创建触发器-------------------

create or replace trigger tri_emp_sal2
before delete on test22
for each row
declare

begin
  dbms_output.put_line('启动了delete触发器!');
end;

---------------------------------

--------------创建触发器-------------------

create or replace trigger tri_emp_sal3
before update on test22
for each row
declare

begin
  dbms_output.put_line('启动了update触发器!');
end;

---------------------------------