Re: trigger?

From: Jørn Hansen <joh_at_stibo.dk>
Date: Fri, 18 May 2001 08:19:49 +0200
Message-ID: <990166622.192277@radon.stibo.dk>

Hi tony

Instead of a trigger, you could use DBMS_JOB to setup a procedure that executed on a daily basis and removed old rows.

/Jørn

"tony" <ttigger4321_at_hotmail.com> wrote in message news:3b0403b2.16309948_at_news.dal.ca...
> Hi. I want to create a trigger that will delete rows that are sysdate
> - 3 or older.
>
> Here's a select that returns the correct rows:
>
> select * from table_a
> where
> last_activity_date >= sysdate - 3
>
> Can anyone show me the syntax to cretate this trigger?
>
> TIA,
> tony
Received on Fri May 18 2001 - 01:19:49 CDT