调用远程接口条件是空去掉这个条件直接用SQL实现

调用远程接口条件是空去掉这个条件直接用SQL实现
在java或者其他程序中可以进行条件是空判断决定是否拼接，但是在直接调用远程SQL接口时则需要特殊处理，如下：

SELECT *
FROM (
         SELECT t1.MEET_NAME, t1.PROJECT_NAME, t2.MEET_NAME1 as NAME,t1.MEET_TIME,t1.SORT,
                ROW_NUMBER() OVER (ORDER BY t1.MEET_NAME) AS rn
         FROM IPD_675336037173576581 t1
                  LEFT JOIN IPD_2 t2 on t1.F_ID = t2.NO
         WHERE NVL({PROJECT_NAME}, t1.PROJECT_NAME) = t1.PROJECT_NAME
           AND
             t1.MEET_TIME BETWEEN
                 NVL(TO_DATE({MEET_TIME_START}, 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('0001-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))
                 AND NVL(TO_DATE({MEET_TIME_END}, 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('9999-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

           AND  t1.MEET_NAME LIKE '%' || {MEET_NAME} || '%'
           AND t1.SORT >= NVL({SORT_MIN}, SORT) AND t1.SORT < NVL({SORT_MAX}, SORT) + 1
     )