Home » RDBMS Server » Server Administration » time remaining(interval)
time remaining(interval) [message #372304] Thu, 01 February 2001 03:37 Go to next message
timmy
Messages: 10
Registered: February 2001
Junior Member
...once a record is committed to a table, i need a procedure that would delete that record after 7days ...there will be a field that would have the sysdate to display date/time the record was committed

any takers? thanks

Report message to a moderator

Re: time remaining(interval) [message #372305 is a reply to message #372304] Thu, 01 February 2001 07:24 Go to previous messageGo to next message
me
Messages: 66
Registered: August 2000
Member
delete from table_name
where date_field < sysdate-7

Report message to a moderator

Re: time remaining(interval) [message #372319 is a reply to message #372304] Fri, 02 February 2001 06:57 Go to previous message
John R
Messages: 156
Registered: March 2000
Senior Member
And then set up a DBMS_JOB process to run that delete every dat.

Report message to a moderator

Previous Topic: insert into....bla bla...select @@indentity as 'ID' ?
Next Topic: ltrim
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 14:13:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.