trigger?

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 Thu May 17 2001 - 12:04:48 CDT