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

Home -> Community -> Usenet -> c.d.o.server -> Trigger Questions

Trigger Questions

From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Wed, 27 May 1998 07:14:22 -0700
Message-ID: <356C1FBD.6195@comp.polyu.edu.hk>


Hello all,

        I want to create a trigger. The trigger is fired when column A or column B is modified or a record newly insert into table T. Is this possible? And how to do this?

        Moreover, if both column A and column B values are changed, how can I prevent the trigger fired twice?

THanks,
Jimmy Received on Wed May 27 1998 - 09:14:22 CDT

Original text of this message

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