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: 3186
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: Thu Oct 27 06:33:22 CDT 2016

Total time taken to generate the page: 0.16609 seconds