How to use timers

From: Kamel Hamard <hamard_at_iro.umontreal.ca>
Date: Tue, 17 Aug 1999 01:21:38 GMT
Message-ID: <CO2u3.2034$2a3.383167@carnaval.risq.qc.ca>

Hi,

I want to program the following application under Oracle:

I have records which are inserted in a table A. Each inserted record has a insertion date.
The table records A is visited every 24 houres and the records which are in the table for more 24 houres are deleted from the table A.

Is it possible implement this mecanism only based on oracle ressource for example using timers and triggers?

Thanks for any idea to do it.

PS: I dont want to use a external program to pool the table A every 24 houres to remove the records.

Kamel. Received on Mon Aug 16 1999 - 20:21:38 CDT