Can trigger and store procedure
run by itself?
Is it possible to execute triggers or procedures on their own ?
I want to clean up records from my database at a certain date. Some
records may last for a few days, others for a few weeks depending on whatkind
of information they have.
Is something possible or should i write a client-based program which
i must run every day ?
Ans:
Why not write a stored procedure that is submitted via DBMS_JOB package
to do this, at least this way the code will be contained in the database,
and could be executed at whatever interval you like.