示例:
<update id="updateGuidePage" parameterType="string">
MERGE INTO LY_SJS_WDZM_YXLXD_YDYM dest
USING (SELECT #{userId, mode=IN, jdbcType=VARCHAR} AS USERID, '0' AS YXYM
FROM DUAL) src
ON (dest.USERID = #{userId, mode=IN, jdbcType=VARCHAR})
WHEN MATCHED THEN
UPDATE SET dest.YXYM = '0'
WHEN NOT MATCHED THEN
INSERT (USERID, YXYM)
VALUES (#{userId, mode=IN, jdbcType=VARCHAR}, '0')
</update>