mysql脚本转oracle脚本

以下红色为字段名

1.concat()函数修改mysql可以多个参数，oracle只能两个参数，嵌套

mysql

<if test="address != null and address != ''">
    AND xu.ADDRESS like concat('%',#{address,jdbcType=VARCHAR},'%')
</if>

oracle

<if test="address != null and address != ''">
    AND xu.ADDRESS like concat(concat('%',#{address,jdbcType=VARCHAR}),'%')
</if>

2.设置时间

mysql

<if test="reviserDate != null and reviserDate != ''">
    AND REVISER_DATE = #{reviserDate,jdbcType=VARCHAR}
</if>

oracle

<if test="reviserDate != null and reviserDate != ''">
    AND REVISER_DATE = TO_DATE(#{reviserDate,jdbcType=VARCHAR},'yyyy-mm-dd hh24:mi:ss')
</if>

 

 3.mysql 时间比较-oracle时间比较

mysql

字段名 TASK_FORCE_TIME

UNIX_TIMESTAMP(TASK_FORCE_TIME) >= UNIX_TIMESTAMP(#{tapeStartTimeStart,jdbcType=VARCHAR})

oracle

TASK_FORCE_TIME >= to_date(#{tapeStartTimeStart,jdbcType=VARCHAR}, 'yyyy-mm-dd hh24:mi:ss')