Home » SQL & PL/SQL » SQL & PL/SQL » Sequence reseted automatically ?
Sequence reseted automatically ? [message #20340] Wed, 15 May 2002 05:30 Go to next message
Yves
Messages: 1
Registered: May 2002
Junior Member
My sequence must be start at zero at the beginning of month, be incremented until end of month for each record and... be restart at zero for next month !

How to make that ?? what the sql for that ??? any idea will be appreciate.. sure !!

Report message to a moderator

Re: Sequence reseted automatically ? [message #20343 is a reply to message #20340] Wed, 15 May 2002 06:11 Go to previous message
vivek
Messages: 59
Registered: October 2001
Member
A sequence cannot be reset as per time intervals. What u can do is create a trigger to fire each motnh beginning. this trigger could drop the existing trigger and create a new one.

Report message to a moderator

Previous Topic: wild card filtering
Next Topic: nested outer joins
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 18:05:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.