kbs、pgsql : 可以自定义分割符号
SELECT array_to_string(ARRAY(SELECT unnest(array_agg( mc ))),';') as mc
FROM dsr
oracle: 默认分割符号,
SELECT wm_concat( mc ) as mc
FROM dsr
kbs、pgsql : 可以自定义分割符号
SELECT array_to_string(ARRAY(SELECT unnest(array_agg( mc ))),';') as mc
FROM dsr
oracle: 默认分割符号,
SELECT wm_concat( mc ) as mc
FROM dsr