timed update in Oracle
From: edoardo.selva <edoardo.selva_at_intertecnica.net>
Date: 29 Nov 2000 17:17:42 +0100
Message-ID: <552D35D67B17D41187C20040C7995B8E1353A4_at_back-office.intertecnica.net>
Date: 29 Nov 2000 17:17:42 +0100
Message-ID: <552D35D67B17D41187C20040C7995B8E1353A4_at_back-office.intertecnica.net>
Hi all.
[Quoted] I have the following problem. I have to update a table on a timed basis,
that is I have to delete lines when they are "older" than a fixed time (the
timestamp is recorded in a column of the table). I thought about triggers,
but it seems to me that they are not activable on timed events.
This could be done writing an external application that periodically (e.g.,
each hour) forces the SQL deletion of the lines where the difference (actual
[Quoted] time - timestamp) is more than a fixed delay. Anyone can suggest a better
solution, without involving external apps developing?
Thank you in advance.
Edoardo Selva
Intertecnica Engineering Group
Project Division
-- Posted from root_at_[195.120.85.10] via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Wed Nov 29 2000 - 17:17:42 CET