lunzi

create or replace trigger del_master_test
  before delete on master_test  
  for each row
declare
  -- local variables here
begin
  insert into master_test_log
    (name)
  values
    (:old.admin_name);

end del_master_test;