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博客 ” ，链接：https://blog.itpub.net/26977915/viewspace-745581/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
