oracle 与 达梦创建函数返回序列的下一个值

1. oracle

CREATE OR REPLACE  FUNCTION nextval(v_seq_name in varchar2) 
 Return number Is
  v_seq number;
  v_sqlstr varchar2(128);
begin
   v_sqlstr:='select 'v_seq_name'.nextval '' from '' dual';
   execute immediate v_sqlstr into v_seq;
   return v_seq; 
 END;

2. 达梦

CREATE OR REPLACE  FUNCTION nextval(v_seq_name in varchar2) 
 Return number Is
  v_seq number;
  v_sqlstr varchar2(128);
begin
   set v_sqlstr= CONCAT('select ' ,v_seq_name,'.nextval from dual');
   execute immediate v_sqlstr into v_seq;
   return v_seq; 
 END;