SELECT
t.NODE_ID,
t.NODE_CODE,
t.NODE_CNAME,
t.NODE_ENAME,
t.NODE_LEVEL,
t.VERSION_ID,
t.VERSION_CODE,
t.VERSION_CNAME,
t.VERSION_ENAME,
t.DIM_GROUP_CODE,
t.DIM_GROUP_CNAME,
t.DIM_ID,
t.DIM_CODE,
t.DIM_CNAME,
t.DIM_ENAME,
t.LEVEL_ID,
t.MAINTAINED_BY,
t.MAINTAINED_BY_GUID,
t.REVIEWER,
t.REVIEWER_GUID,
t.APPROVER,
t.APPROVER_GUID,
t.BIZ_ENV_ID,
t.CREATION_USERCN,
t.CREATION_USERCN_GUID,
t.LAST_UPDATE_USERCN,
t.LAST_UPDATE_USERCN_GUID,
t.CREATION_DATE,
t.LAST_UPDATE_DATE
FROM
DIM_NODE_PERMISSION_CONFIG_T AS t,
DIM_BASE_INFO_T t1
WHERE
t.dim_id = t1.dim_id
AND t1.is_open_permission_config = 'Y'
AND LOWER(t.MAINTAINED_BY_GUID) LIKE LOWER(concat ('%', '197348844673184', '%'))
ORDER BY t.last_update_date desc
UNION
SELECT
t2.NODE_ID,
t2.NODE_CODE,
t2.NODE_CNAME,
t2.NODE_ENAME,
t2.NODE_LEVEL,
t2.VERSION_ID,
t2.VERSION_CODE,
t2.VERSION_CNAME,
t2.VERSION_ENAME,
t2.DIM_GROUP_CODE,
t2.DIM_GROUP_CNAME,
t2.DIM_ID,
t2.DIM_CODE,
t2.DIM_CNAME,
t2.DIM_ENAME,
t2.LEVEL_ID,
t2.MAINTAINED_BY,
t2.MAINTAINED_BY_GUID,
t2.REVIEWER,
t2.REVIEWER_GUID,
t2.APPROVER,
t2.APPROVER_GUID,
t2.BIZ_ENV_ID,
t2.CREATION_USERCN,
t2.CREATION_USERCN_GUID,
t2.LAST_UPDATE_USERCN,
t2.LAST_UPDATE_USERCN_GUID,
t2.CREATION_DATE,
t2.LAST_UPDATE_DATE
FROM
DIM_NODE_PERMISSION_CONFIG_T AS t2,
DIM_BASE_INFO_T t3
WHERE
t2.dim_id = t3.dim_id
AND t3.is_open_permission_config = 'Y'
AND t3.dim_id in('d2870') and t2.node_id in('19999589')
为什么这段失去了、
最新发布
寻找特定GUID的HashCode
本文探讨了一种特殊的需求，即找到一个GUID，其HashCode值恰好为Integer.MIN_VALUE，并且需要去除GUID中的所有横杠，使其成为32位的字符串。
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
