<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>