esql常用语法示例

1.为空判断

--isNotEmpty startDate

AND SU.CREATE_DATE >=to_date(#startDate#,'yyyy/mm/dd')

--end

2.if判断语句

--iff proType == 0
     AND ATT.ATTR_CODE = 'SUGG_HOST_UNIT'
--iff proType == 1
    AND ATT.ATTR_CODE = 'SUGG_CO_ORGANIZER'
--end

3.取值

#startDate#

4。根据序列名获取序列，$$获取的值不带引号
--[selectSeqId]
select to_char($$.nextval) from dual;