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?
|
||||
ORACLE: deleting old records automatically form a tablepthompson2002 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