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>


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.ORG
Received on Wed Nov 29 2000 - 17:17:42 CET

Original text of this message