1.触发器
create [or replace] trigger tri_name
[before | after | instead of] tri_event
on table_name | view_name | user_name | db_name
[for each row] [when tri_condition]
begin
plsql_sentences;
end tri_name;
实例:
create or replace tirgger tri_dept
befor insert or update or delete
on dept //创建触发器,当dept表发生插入、修改、删除操作时引起触发器执行
declare
var_tag varchar2(10);//声明一个变量,存储对dept执行的操作类型
begin
if inserting then //inserting条件谓词,true或者false
var_tag :='插入';
elsif updating then
var_tag :='更新';
elsif deleting then
var_tag :=‘删除’;
insert into dept_log values(var_tag,sysdate);
ebd tri_dept;