Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: trigger?
On Fri, 18 May 2001 08:19:49 +0200, "Jørn Hansen" <joh_at_stibo.dk> wrote:
>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
>
Thanks Jorn. I'll look into this.
tony
>"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 - 08:21:34 CDT