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..
This blog is dedicated to share my experience during my development as a purpose of notes and explorer various web / enterprise technologies like JAVA , JEE , Spring ,hybris, Portal , Jquery , RAI , JMS, Weblogic , SSL , Security, CS, MAC< Linux, Windows, Search, IOT, Arduino, Machine Learning, Tips, Angular, Node JS, React, Mac, Windows, Stack, Exception, Error etc. with examples.
Search This Blog
Subscribe to:
Post Comments (Atom)
Popular Posts
-
During git commit -m 'text' we observed error error: invalid object 100644 b1bc4dae98865adf256e130c6bce53bb09d3e93b for 'path...
-
In recent development, I was facing following issue with one of old existing POM file ; [ERROR] Failed to execute goal org.apache.maven....
-
Today we were facing some UI issues in different versions of browser. To troubleshoot the problem I found an exe which has collection of IE...
-
If you want to manage and monitor the services, you can use PM2 , a process manager for Node.js. This is particularly useful in production ...
No comments:
Post a Comment
Thanks for your comment, will revert as soon as we read it.