GaramX

CREATE OR REPLACE TRIGGER 트리거이름
  FOR 트리거링 이벤트 ON 테이블명
    COMPOUND TRIGGER
  -- 전역 변수 선언
  g_global_variable VARCHAR2(10);
  TYPE TYPE_SALED_TAB IS TABLE OF SALED%ROWTYPE;
  G_SALED_TAB TYPE_SALED_TAB := TYPE_SALED_TAB();
 
  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
    IF INSERTING OR UPDATING OR DELETING THEN
      NULL;
    END IF;
    NULL; -- Do something here.
  END AFTER EACH ROW;
 
  AFTER STATEMENT IS   --명령문 레벨 트리거 AFTER
  BEGIN
    NULL; -- Do something here.
  END AFTER STATEMENT;
 
END <trigger-name>;