Oracle获得Sequence的当前值

2017-07-18 17:47:14  访问(1779) 赞(0) 踩(0)

• 内容
• 工具：生成脚本
• 示例代码源码

• select sequence_name,last_number,increment_by 
  from user_sequences where sequence_name='S_MYSEQUENCE'
  

• Sequence名称 ：	如：SEQ_SLOWX_WEB_ITEM
  输出脚本：

• 
  
          /// <summary>
          /// Oracle生成获得Sequence当前值的脚本语句
          /// </summary>
          /// <param name="sequenceName">sequence名称</param>
          /// <returns></returns>
          public string OracleDBToolGetSequenceCurValueScript
              (
                  string sequenceName 
              )
          {
              if (sequenceName == null || sequenceName.Length == 0)
                  return "select sequence_name,last_number,increment_by from user_sequences";
  
              return "select sequence_name,last_number,increment_by from user_sequences where sequence_name='"+sequenceName.ToUpper().Trim()+"' ";
          }
  

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)