Shulou(Shulou.com)06/01 Report--

No more nonsense, just paste the code to everyone, the specific code is as follows:

Create a sequence

Create sequence seq_studentstart with 6increment by 1maxvalue 500nominvaluenocyclenocache

Create trigger

Create or replace trigger trigger_studentbefore insert on studentfor each row declareBEGINselect seq_student.nextval into: new.id from dual;END

Summary

The above is the editor to introduce to you the Oracle digital type number self-increasing implementation code, I hope to help you, if you have any questions, please leave me a message, the editor will reply you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.