Home » SQL & PL/SQL » SQL & PL/SQL » Purge Script (Oracle10g)
Purge Script [message #312825] Wed, 09 April 2008 20:05 Go to next message
Messages: 153
Registered: February 2008
Location: CANADA
Senior Member

My requirement is create a procedure which will move the data after every 5 months in to another history table.
I have no idea how to calculate months.so that on the basis of date i can move the data from fact table to history table automatically after every run.
Any help will be appreciated
Re: Purge Script [message #312826 is a reply to message #312825] Wed, 09 April 2008 20:10 Go to previous message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
TRUNC and ADD_MONTHS comes to mind as being useful for such calculations.
Previous Topic: create new row and inserting variables as values
Next Topic: Regarding Pseudo Columns
Goto Forum:

Current Time: Tue Jul 25 10:25:53 CDT 2017

Total time taken to generate the page: 0.13454 seconds