...

View Full Version : ORACLE: deleting old records automatically form a table



pthompson2002
09-13-2002, 03:54 PM
We want to delete rows from a table that are more than a year old, we'd like to do it automatically, for example have a script that runs once a week at 2am and deletes the records. Is there a way we can do this?

bcarl314
09-13-2002, 04:01 PM
I'd hit google and look for "stored prcedures" or "triggers" using an oracle db.


#100!



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum