Oracle Trigger简单用法

1. trigger 是自动提交的，不用COMMIT，ROLLBACK

2. trigger最大为32K，如果有复杂的应用可以通过在TRIGGER里调用PROCEDURE或FUNCTION来实现。

3. 语法

CREATE OR REPLACE TRIGGER <trigger_name>
<BEFORE | AFTER> <ACTION>
ON <table_name>

DECLARE
 <variable definitions>
BEGIN
  <trigger_code>
EXCEPTION
  <exception clauses>
END <trigger_name>;
/

 

例子，trigger调用sequence自动添加主键id：

create sequence pk_sys_dictionary
start with 1
increment by 1
nocache;

 

create or replace trigger tri_sys_dictionary
  before insert on sys_dictionary 
  for each row
declare
 
begin
  select pk_sys_dictionary.nextval into :new.id from dual;
end;
/