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;