Re: Trigger Question
From: Peter Mapson <mapsonp_at_ois.com.au>
Date: 1996/09/10
Message-ID: <32356c21.0_at_news.ois.net.au>#1/1
Date: 1996/09/10
Message-ID: <32356c21.0_at_news.ois.net.au>#1/1
I'd be inclined to do the following (which saves on any further calls to the database):
CREATE TRIGGER stuff_deleted_trigger
BEFORE DELETE
ON stuff
FOR EACH ROW
BEGIN
INSERT INTO stuff_deleted(x, y, z, deleted_date, deleted_by)
VALUES( :old.x, :old.y, :old.z, sysdate, user ) ;
END;
/
Received on Tue Sep 10 1996 - 00:00:00 CEST