Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> trigger updating a master table from detail table
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