Oracle 字符串函数

<select id="queryPage" parameterType="java.util.Map" resultMap="DoorPo"> SELECT  t.controllersn as CONTROLLERSN, <include refid="join_columns"/>  FROM TB_DOOR_CONTROLLER t LEFT JOIN TB_DOOR_DOOR d ON t.CONTROLLERSN=d.controllerid <where>             instr(d.DOORENABLED,  '1') &gt; 0 <if test="@Ognl@isNotEmpty(controllerid)">                   and t.CONTROLLERSN=#{controllerid} </if> <if test="@Ognl@isNotEmpty(zoneid)">                   and t.zoneid=#{zoneid} </if> </where> </select>