Re: Help with Trigger!!!

From: Prasad Chavali <pchavali_at_assettech.com>
Date: Tue, 9 Mar 1999 18:05:38 -0700
Message-ID: <7c4ggv$64r$1@nnrp02.primenet.com>

Well this depends on how are you deleting the records.

If you are using developer tools you can do a pre-delete trigger and do what ever you want. Or else you can have a database trigger in the database on the table. You can use procedure builder or any other PL/SQL compiler to do that.

HTH Prasad Chavali
pchavali_at_assettech.com

Database Generation Ltd. wrote in message <36E575AE.1EE2_at_dircon.co.uk>...
>Dear friends,
>
>Is it possible (and if it possible - how) to create the trigger BEFORE
>delete that will copy the record before delete it into another table
>with the same structure?
>
>Thank you very much in advance.
>Eugene
Received on Tue Mar 09 1999 - 19:05:38 CST