触发顺序_eachrow_语句.txt

orale培训教材包括了所有的sql说明和实例

CREATE OR REPLACE TRIGGER han2
before  insert or update on man 
begin 
  
    dbms_output.put_line('语句 trigger!');
  
end;

--语句级触发器
CREATE OR REPLACE TRIGGER han1
before  insert or update on man for each row
begin 
  if :new.minzu!='汉' then 
    dbms_output.put_line('for each row trigger!');
  end if;
end;




--局部变量的定义
create or replace trigger han3 before 
insert or update on man 
declare
  v_name varchar2(20);
begin
  v_name:='called!';
  dbms_output.put_line(v_name);
end;