SELECT
xmlagg(
XMLPARSE (
CONTENT TRANSLATE (unique_id USING CHAR_CS) || ',' WELLFORMED
)).getclobval()
FROM
BIM_ELEMENTCODE
WHERE
xmlagg(
XMLPARSE (
CONTENT TRANSLATE (unique_id USING CHAR_CS) || ',' WELLFORMED
)).getclobval()
FROM
BIM_ELEMENTCODE
WHERE
pj_id = '0305'
如果数据量不是巨大,可以加上RTRIM
SELECT
RTRIM (
xmlagg(
XMLPARSE (
CONTENT ent_code || ',' WELLFORMED
)).getclobval(),
','
)
FROM
BIM_ENTITY;