I need to recycle the value in the database after reaching @ max count .. for that planned to use oracle sequences and found that following way we can recycle the sequence value from the start :
DROP SEQUENCE sms_job_seq;
CREATE SEQUENCE sms_job_seq
MINVALUE 1
MAXVALUE 100
START WITH 1
INCREMENT BY 1
CYCLE
NOCACHE;
we have to set cycle property during sequence creation .. then after reaching max limit .. (100 here) next value will start from 1. (No need of application coding to do this :) )
Cheers..
Subscribe to:
Post Comments (Atom)
Popular Posts
-
I need to recycle the value in the database after reaching @ max count .. for that planned to use oracle sequences and found that followin...
-
Traditional way to implement Singleton in Single threaded environment may cause of problem of double-checked locking implementation in mult... -
Recently I was setting up maven project and trying to deploy application after build on the tomcat server but during setup POM.xml it was ...
-
Problem : Change a column type (varchar to clob) usig SQL query . Solution : To change column type column should be dropped and then c...
No comments:
Post a Comment
Thanks for your comment, will revert as soon as we read it.