sql

update GRAS_DEPT_SERVICER
         set
         SERVICER_NO=#{servicerNo,jdbcType=VARCHAR},
         UPDATED_USER = #{updatedUser,jdbcType=VARCHAR},
         UPDATED_DATE =sysdate
         where
         DEPT_NO =#{deptNo,jdbcType=VARCHAR}
         and  IS_VALID='Y'