oracle - 哪位高手可以帮忙解释一下SQL 中[%=]的意思

问题描述

问 题

SELECT * FROM WF_INSTANCE A, WFV_TASK B, G_PRJ_XMXX C
WHERE A.INSTID = B.INSTID [%=if(isSuperAdmin(curUser()),""," AND ((B.FINISHUSER IS NOT NULL AND B.FINISHUSER='"+curUser()+"' OR B.FINISHUSER IS NULL AND B.EXECUSER IS NOT NULL AND B.EXECUSER='"+curUser()+"') OR (B.FINISHUSER IS NULL AND B.EXECUSER IS NULL AND ((B.EXECROLE IS NOT NULL AND "+concatCols("wfdata","B.ROLESUBSYS,'.',B.EXECROLE")+" IN ("+userRoles(curUser(),null,",",true)+")) OR B.EXECROLE IS NULL)))" + if(hasRole('appzjgg', 'SJ_GBKZ') || hasRole('appzjgg', 'SJ_JB'), " AND C.CORG_ IN (select ORGANISEID from ORGANISE where PARENTID = '" + curOrg() + "')", ""))%]
ORDER BY B.ARRIVETIME DESC

解决方案

这个不是标准的sql语句，应该是某种模板语言，用来根据变量拼接出sql语句。

这篇关于oracle - 哪位高手可以帮忙解释一下SQL 中[%=]的意思的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！