fqj-kylin
9/20/2017 - 2:45 AM

获取数据库的自增长序列

获取数据库的自增长序列

<!-- 获取站内信编号(日期+数列自增长) -->
<select id="selectSeqNo" resultType="string">
	<![CDATA[
      select to_char(sysdate,'YYYYMMDD')||SEQ_MESSAGETEXT_ID.NEXTVAL from dual
	]]>
</select>

<!-- 查询机构开户申请流水号 -->
<select id="selectOrderId" resultType="string">
    <![CDATA[  
        select to_char(SYSDATE, 'yyyymmdd') ||
               lpad(to_char(SEQ_APPCORPACCT.nextval), 12, '0')
          from dual
    ]]>
</select>
<!-- 新增反馈信息(登录用户)  -->
<insert id="insertFeedBackMsgLogin" parameterType="com.bosera.iof.emp.beans.FeedbackMsgVO">
	<![CDATA[
		insert into feedbackmsg_login
		  (ID, MESSAGE, FUNDACCT, ADDTIME,IDTP,IDNO,DISTRIBUTORTYPE,NAME,OPID)
		VALUES
		  (to_char(sysdate,'YYYYMMDD')||SEQ_FEEDBACKMSG_LOGIN.NEXTVAL, #{message}, #{fundAcct}, sysdate,#{idTp},#{idNo},#{distributorType},#{name},#{opId})
	]]>
</insert>
create sequence SEQ_PINGAN
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;