Home » RDBMS Server » Server Administration » sql query to delete data when it expire
sql query to delete data when it expire [message #375208] Mon, 06 August 2001 02:02 Go to next message
Charmaine
Messages: 1
Registered: August 2001
Junior Member
I was wondering whether sql enable us to set a expiry date to data, and auto delete when it has reach the expiry date?
eg: I got a forum. then i want sql to auto delete a message when it has reach the expiry date of 7 days?
Please help.

Report message to a moderator

Re: sql query to delete data when it expire [message #375212 is a reply to message #375208] Mon, 06 August 2001 05:53 Go to previous message
murarishettysrinivas
Messages: 9
Registered: July 2001
Junior Member
it can be done provided u have some date column in your table

and write a procedure to delete the rows of the past week and assign this procedure to
DBMS_JOB with interval as 1 week

Report message to a moderator

Previous Topic: Re: Update, constraint restruction, workaround...
Next Topic: oracle 8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 10:18:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.