- 博客(4)
- 收藏
- 关注
原创 oracle中用sql语句以“,”分割取第一个值
select distinct REGEXP_SUBSTR(SUBMIT_PERSION_ORG_ID,'[^,]+',1,1 ) orgId, REGEXP_SUBSTR(SUBMIT_PERSION_ORG_NAME,'[^,]+',1,1 ) orgName, sum(count(*)) over (partition by REGEXP_SUBSTR(SUBMIT_PERSION_ORG_ID,'[^,]+',1,1 ) )from BUSI_INFOwhere .
2022-04-11 15:41:30
3921
原创 通过根节点遍历子节点集合
public List<String> orgIdsList(String id){ AbstractOrganizationBO organizationTree = organizationService.getOrganizationTree(); //首先通过根节点获取子节点 OrganizationBO organizationBO = (OrganizationBO) organizationTree.locateNode(id); List<.
2022-03-25 09:41:28
175
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人