oracle插入返回主键&&根据时间获取最新的一条数据

<!-- 查询车辆最新出厂区订单记录 -->
   <select id="queryMaxVehRecordByOutFactory" parameterType="java.util.Map" resultType="com.extracme.volvopark.netty.domain.BrakeOpen">
	  SELECT 
	  		orderSeq,vin,orderStatus,timeType
	  FROM 
	  (
		   SELECT 
				o.ORDER_SEQ orderSeq,v.VIN vin,o.ORDER_STATUS orderStatus,o.TIME_CLASSIFICATION timeType
			FROM 
				ORDER_INFO o
			INNER JOIN   
				VEHICLE_INFO v
			ON 
				o.VIN=v.VIN
			where   
				TO_CHAR(SYSDATE , 'YYYYMMDDHH24MI') > o.PLAN_PICKUPTIME
	   			AND o.REAL_PICKUPTIME IS NOT NULL 
	    		<!-- AND o.REAL_RETURNTIME IS NULL -->
	    		and o.ORDER_TYPE = 2
				<!-- AND o.ORDER_STATUS=3 -->
				AND (v.RFID =  #{rfid,jdbcType=VARCHAR} or v.RFID1 =  #{rfid,jdbcType=VARCHAR} or v.RFID2 =  #{rfid,jdbcType=VARCHAR} or v.RFID3 =  #{rfid,jdbcType=VARCHAR} or v.RFID4 = #{rfid,jdbcType=VARCHAR})
			ORDER BY o.PLAN_RETURNTIME DESC 
		) where rownum=1
 </select>
----------------插入返回主键
  <!-- 插入出停车场记录 -->
   <insert id="insertParkOrFactoryOut" parameterType="com.extracme.volvopark.netty.domain.VehicleInOutInfo">
    <selectKey resultType="java.lang.Long" order="BEFORE" keyProperty="vehicleInOutInfoSeq">  
      SELECT VEH_INOUT_SEQ.NEXTVAL from DUAL 
   	</selectKey>
    insert into VEHICLE_IN_OUT_INFO
    <trim prefix="(" suffix=")" suffixOverrides=",">
     <if test="vehicleInOutInfoSeq != null">
        VEHICLE_IN_OUT_INFO_SEQ,
      </if>
      <if test="vin != null">
        VIN,
      </if>
   
      
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
   	 <if test="vehicleInOutInfoSeq != null">
      	#{vehicleInOutInfoSeq,jdbcType=DECIMAL},
       </if>
      <if test="vin != null">
        #{vin,jdbcType=VARCHAR},
      </if>
 </trim>

  </insert>

ps：


private Long vehicleInOutInfoSeq;