Oracle查询,当一个SQL返回为一个列表,另一个SQL返回一个以逗号分隔的字符串,如何将这个两个SQL整合起来
执行第一个SQL为:
SELECT T.PARTY_HCODE
FROM REF_PARTY_BASICINFO T, (
SELECT T3.pcode AS partycode, T3.ratingvalue AS rtvalue
FROM (
SELECT T2.PARTY_HCODE AS pcode, T2.effectdate AS edate, T2.ratingi...
原创
2019-08-29 14:36:59 ·
247 阅读 ·
0 评论