Force get sequence Next value/Current value (Oracle function)

Original link--http://blog.csdn.net/qq525099302/article/details/47146393
Why use a function to get sequence values see here

--Create a function to get the next value of the sequence Create or replace function Get_seq_next (seq_name  in varchar2) return  number is seq_val  number;  beginexecute immediate ' select '| | seq_name| | '. Nextval from dual ' into Seq_val;    return seq_val; end Get_seq_next;--Create a function to get the next value of the sequence (before it can be used until the next value is obtained) Create or replace function Get_seq_curr (seq_name  in varchar2) return  number is seq_val  number;  beginexecute immediate ' select '| | seq_name| | '. Currval from dual ' into Seq_val;    return seq_val; end Get_seq_curr;

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Force get sequence Next value/Current value (Oracle function)