oracle 触发器
好久没写触发器了。这个项目用了比较多的触发器。
最近又开始温习了一遍触发器的相关内容:
触发器的种类:
1、DML触发器
create or replace trigger trigger_name
{before/after}
{insert/delete/update of columns}
on table_name
reference old as old new as new
[for each row]
[when condition]
begin
trigger_body;
{before/after}
{insert/delete/update of columns}
on table_name
reference old as old new as new
[for each row]
[when condition]
begin
trigger_body;
end tigger_name;
2、替代触发器
create or replace trigger trigger_name
instead of
{insert/delete/update of column }
on view_name
reference old as old new as new
[for each row]
[when condition]
begin
trigger_body;
end tigger_name;
instead of
{insert/delete/update of column }
on view_name
reference old as old new as new
[for each row]
[when condition]
begin
trigger_body;
end tigger_name;
3、系统触发器
create or replace trigger trigger_name
{before/after}
{ddl_event_list/database_event_list}
on {database/schema.SCHEMA}
[when clause]
begin
trigger_body;
end tigger_name;
{before/after}
{ddl_event_list/database_event_list}
on {database/schema.SCHEMA}
[when clause]
begin
trigger_body;
end tigger_name;
-------------------------------
例子我就不列举了,触发器比较简单,只是许久不用了会忘记语法!故温习之!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26977915/viewspace-745581/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26977915/viewspace-745581/