Home » SQL & PL/SQL » SQL & PL/SQL » Stored procedure to delete information within number of days? (Oracle 10g)
Stored procedure to delete information within number of days? [message #345800] Thu, 04 September 2008 19:42 Go to next message
boarder1026
Messages: 1
Registered: September 2008
Junior Member
Hello everyone,

I am struggling with creating a stored procedure which will allow me to delete old data from specific tables within a specific date range. Ideally what I would like to do is to create a stored procedure where I can specify the delete from let's say 6 different tables and an adhoc number of days. I am new to this and any help is greatly appreciated.

Regards,
Re: Stored procedure to delete information within number of days? [message #345803 is a reply to message #345800] Thu, 04 September 2008 20:18 Go to previous message
BlackSwan
Messages: 25043
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

> I can specify the delete from let's say 6 different tables and an adhoc number of days
You should pass into the procedure either two dates (begin & end dates) or begin date & number of days forward.
Previous Topic: select sql for non-english chancter
Next Topic: Alternative way to write the query
Goto Forum:
  


Current Time: Wed Dec 07 08:37:33 CST 2016

Total time taken to generate the page: 0.17601 seconds