Go Back   CodingForums.com > :: Computing & Sciences > Computer Programming
Reload this Page ORACLE: deleting old records automatically form a table

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 09-13-2002, 03:54 PM   PM User | #1
pthompson2002
New Coder

 
Join Date: Aug 2002
Location: Ipswich
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
pthompson2002 is an unknown quantity at this point
ORACLE: deleting old records automatically form a table
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?
pthompson2002 is offline   Reply With Quote
Old 09-13-2002, 04:01 PM   PM User | #2
bcarl314
Mega-ultimate member


 
Join Date: Jun 2002
Location: Winona, MN - The land of 10,000 lakes
Posts: 1,855
Thanks: 1
Thanked 45 Times in 42 Posts
bcarl314 will become famous soon enough
I'd hit google and look for "stored prcedures" or "triggers" using an oracle db.


#100!
bcarl314 is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


« Previous Thread | Next Thread »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:25 AM.
Advertisement
Log in to turn off these ads.