随笔分类 - oracle
摘要：代码实例，俩个条件判断，如果都不符合走else语句 SELECT TMRP.xm , TMRP.sj , TMRP.BGYX , TCUI.PHONE , TCUI.MAIL , CASE WHEN TCUI.PHONE IS NOT NULL THEN TCUI.PHONE WHEN TMRP.s
阅读全文
摘要：第一种写法（1）： 原符号 < <= > >= & ' "替换符号 < <= > >= & ' "例如：sql如下：create_date_time >= #{startTime} and create_date_time <= #{e
阅读全文
摘要：CASE WHEN V.GET_NUM /V.EFFECTIVE_NUM is null THEN '' WHEN V.GET_NUM /V.EFFECTIVE_NUM is not null THEN TO_CHAR ( NVL(ROUND (V.GET_NUM /V.EFFECTIVE_NUM,
阅读全文
摘要：<if test="STATE !=null and STATE !=''"> <if test="STATE == 5 or STATE == '5'"> AND TCRT.STATE = #{STATE} </if> <if test="STATE == 4 or STATE == '4'">
阅读全文