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;