SELECT
(t1.DEPTCNAME||'-'||t1.MARK_TYPE||'-'||t2.CHECK_ITEM||'-'||t3.BY1||'-'||t3.content_standard) AS "textFile",<!--拼接考核/扣分依据下拉框-->
t3.IID AS "textId",<!--拼接考核/扣分依据下拉框iid-->
t3.SCORE AS "score",<!--加减分-->
t1.IID AS "markTypeId",<!--考核评分类别id-->
t2.IID AS "checkItemId",<!--考核评分检查项目iid-->
t3.IID AS "contentStandardId"<!--检查内容与评分标准iid-->
FROM
${projectSchema}.T_MARK_TYPE t1
inner JOIN ${projectSchema}.T_MARK_CHECK_ITEM t2 ON
t1.IID = t2.MARK_TYPE_ID
inner JOIN ${projectSchema}.T_CONTENT_STANDARD t3 ON
t2.IID =t3.CHECK_ITEM_ID
WHERE 1=1 AND t1.REC_STATUS = '0'
AND t2.REC_STATUS = '0'
AND t3.REC_STATUS = '0'

注意：这里oracle是使用"||“来进行字段的拼接而不是使用”+"号

在拼接的过程中我习惯性的使用了“+号”导致我编译器报错“SQL 错误 [1722] [42000]: ORA-01722: 无效数字”,这里有详细的帖子解释关于报错“无效数字的”例子；
https://blog.csdn.net/a1720119024/article/details/90381995