插入数据返回主key

mysql写法：

<insert id="insertData" parameterType="参数">
  <selectKey resultType="Integer" keyProperty="id" >
     select last_insert_id()
   </selectKey>
    INSERT INTO exch_rate_file_info
   (REQ_BIN,
    EXCH_CNT,
    FILE_NAME,
    FILE_PATH,
    LIST_SIZE,
    CHK_USER_ID,
    STAT,
    raw_add_time,
    raw_add_user_id,
    raw_update_time,
    raw_update_user_id)
 VALUES
   (#{reqBin},
    #{exchCnt},
    #{fileName},
    #{filePath},
    #{listSize},
    #{chkUserId},
    #{stat},
    #{rawAddTime},
    #{rawAddUserId},
    #{rawUpdateTime},
    #{rawUpdateUserId})
  </insert>

oracle写法：

 <insert id="insert.activationCode" parameterClass="ozzy.activationCodeDTO">
  <selectKey resultClass="long" keyProperty="pkid">
   SELECT WLTDATA.SEQ_ACTIVE_NO.NEXTVAL FROM DUAL
  </selectKey>
  INSERT INTO
   WLTDATA.WLT_ACTIVE_NO (WLT_ACTIVE_NO_ID,PRODUCT_ID,PID,BATCH_NO,CREATE_DT,ACTIVE_STATUS,ACTIVE_NO,CREATED_BY,CREATED_DATE,UPDATED_BY,UPDATED_DATE)
  VALUES
   (#pkid#,#productId#,#partnerId#,#batchNo#,#createD#,#activationStatus#,#activationCode#,#createdBy#,sysdate,#updatedBy#,sysdate)
 </insert>