Re: Trigger Questions

CREATE OR REPLACE TRIGGER trig_1

   AFTER
   INSERT OR UPDATE OF a, b
   ON t
   FOR EACH ROW DECLARE BEGIN
   IF INSERTING
   THEN

• code here

   ELSIF UPDATING
   THEN

• code here

   END IF; EXCEPTION END;
/

Take a look at the Application Developer's Guide, Chapter 9, "Using Database Triggers."

HTH, Joe Rogers
Intelligent Information Systems, Inc.
joer_at_renewal-iis.com

Jimmy wrote:

> 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:28:26 CDT