I have a table called fm_rel having the following columns
id,creationtime. Every day we add entries to this table. I need the logic(database trigger) which will identify any record which is older than 7 days and delete the record.

Can I write a trigger which can identify the age with out doing any manipulations on the record.

I am not sure it is feasible also , any ideas will be appreciated.


Shri

How about something like

delete from fm_rel where creationtime < current date -7 days

To perform this I should have a process runs everyday. Can we write a intellegent trigger(I don't trigger supports this... some way) which automatically identifies n days older data and delete it automatically. Any ideas?

Once a trigger is written, its ready for execution always. Make some condition like On INSERT/UPDATE, i mean whenever there will be some action on the source table then the TRIGGER will be FIRED.
See the Syntax of Triggers for better understanding.

Thanks,
Jay