Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> trigger updating a master table from detail table

trigger updating a master table from detail table

From: Philippe Makowski <makowski.philippe_at_wanadoo.fr>
Date: Tue, 24 Jul 2001 21:40:34 +0200
Message-ID: <9jkivt$4f7$1@wanadoo.fr>

this code doesn't compil any idea ?
EVENEMENT is a détail table of ETABLISSEMENT.

CREATE TRIGGER DATE_MAJ_ETAB_EVENEMENTS
  AFTER DELETE OR UPDATE OR INSERT ON EVENEMENT FOR EACH ROW WHEN (OLD.NUM_ETAB IS NOT NULL)
BEGIN
  UPDATE ETABLISSEMENT SET DATE_MAJ_ETAB = SYSDATE   WHERE NUM_ETAB = OLD.NUM_ETAB
END
;
thanks Received on Tue Jul 24 2001 - 14:40:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US