今天写了一个SQL语句,放入工程
- SELECT *
- FROM GR_EDUCATION_BACKGROUND
- WHERE SYSDATE - decode(eb_end_date, null, sysdate, EB_END_DATE) < 730
报错,The content of elements must consist of well-formed character data or markup
经查mybatis不能有小于号,把代码更换成
- SELECT *
- FROM GR_EDUCATION_BACKGROUND
- WHERE 730 > SYSDATE - decode(eb_end_date, null, sysdate, EB_END_DATE)
错误消失