mysql,oracle在mybatis模糊查询

mysql:

<if test="deviceType != null and deviceType != ''">and device_type like CONCAT('%', #{deviceType}, '%')</if>

oracle:

<if test="faultModeCode != null and faultModeCode != ''">

    AND hqfmd.fault_mode_code LIKE '%' || #{faultModeCode} || '%'
</if>