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 -> Re: trigger updating a master table from detail table

Re: trigger updating a master table from detail table

From: Kay Kanekowski <kkanekowski_at_mindcommerce.de>
Date: Wed, 25 Jul 2001 08:23:24 +0200
Message-ID: <9jls79$5jo$1@fermi.tro.net> 






"Philippe Makowski" <makowski.philippe_at_wanadoo.fr> schrieb im Newsbeitrag news:9jkivt$4f7$1_at_wanadoo.fr...



>   WHERE NUM_ETAB = OLD.NUM_ETAB



Hi ,



try


    WHERE NUM_ETAB = :OLD.NUM_ETAB


But you don't have an OLD-Value in an insert.



hth


Kay
Received on Wed Jul 25 2001 - 01:23:24 CDT












Original text of this message













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