GaramX

CREATE OR REPLACE TRIGGER 트리거이름
  FOR 트리거링 이벤트 ON 테이블명
    COMPOUND TRIGGER
  -- 전역 변수 선언
  g_global_variable VARCHAR2(10);
 
  BEFORE STATEMENT IS   --명령문 레벨 트리거 BEFORE
  BEGIN
    NULL; -- Do something here.
  END BEFORE STATEMENT;
 
  BEFORE EACH ROW IS  --행레벨 트리거 BEFORE
  BEGIN
    NULL; -- Do something here.
  END BEFORE EACH ROW;
 
  AFTER EACH ROW IS  --행레벨 트리거 AFTER
  BEGIN
    NULL; -- Do something here.
  END AFTER EACH ROW;
 
  AFTER STATEMENT IS   --명령문 레벨 트리거 AFTER
  BEGIN
    NULL; -- Do something here.
  END AFTER STATEMENT;
 
END <trigger-name>;