--Insert Beforeトリガ
  CREATE OR REPLACE TRIGGER TBI_MSTW000010
  BEFORE INSERT 
  ON MSTW012010
  REFERENCING OLD AS OLD NEW AS NEW
  FOR EACH ROW 
  BEGIN
 	:new.CA := TO_CHAR(SYSDATE,'YYYYMMDD');
 	:new.CB := TO_CHAR(SYSDATE,'HH24MMSS');
  END;
 
  --Update Beforeトリガ
  CREATE OR REPLACE TRIGGER TBU_MSTW000010
  BEFORE UPDATE 
  ON MSTW000010
  REFERENCING OLD AS OLD NEW AS NEW
  FOR EACH ROW 
  BEGIN
 	:new.CC := TO_CHAR(SYSDATE,'YYYYMMDD');
 	:new.CD := TO_CHAR(SYSDATE,'HHMMSS');
  END;