oracle数据库wm_concat有长度限制,如果长度超长会显示如下提示:
例如原始SQL:
select rcid, wm_concat(column_comment) as des from dm_s_resource_catalog_metadata where rcid=‘d6b3d14a17314cdbbe750a57428c4abc’ group by rcid
替代方案:
select XMLAGG(XMLELEMENT(E, column_comment || ‘,’)).EXTRACT(’//text()’).getclobval() des from dm_s_resource_catalog_metadata where rcid=‘d6b3d14a17314cdbbe750a57428c4abc’