查询squence

<selectKey resultClass="string" keyProperty="partnerBindingRecordId">
   SELECT to_char(sysdate,'yyyymmdd')||lpad(WLTDATA.SEQ_WLT_PARTNER_LOTTERY_LOG.nextval, 11, '0') AS idWltPartnerLotteryLog FROM DUAL
    </selectKey>

posted @ 2016-03-11 17:08  神玄晓  阅读(180)  评论(0编辑  收藏  举报