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

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
thanks
Re: Purge Script [message #312826 is a reply to message #312825] Wed, 09 April 2008 20:10 Go to previous message
ThomasG
Messages: 3189
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: Fri Dec 09 01:50:09 CST 2016

Total time taken to generate the page: 0.23042 seconds