Re: let table grow for two months then delete first month
weird. I see in the documentation that you cannot actually use NOW() as a default value.
Really I was happy with using TIMESTAMP but I could not partition my table using this.
As I remember I cannot use function calls in a TRIGGER? Luckily I am filling this table using an event so I suppose I can just add the NOW() in my EVENT?
Would this be a correct approach?
Subject
Written By
Posted
Re: let table grow for two months then delete first month
April 10, 2012 01:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.