SELECT pbs, pbs || ',' || WMSYS.WM_CONCAT(bs) AS FIDSTR
FROM (select substr(bs, 0, instr(bs, '.', -1) - 1) as pbs, bs
from BS_METADATAMODEL)
group by pbs
上面实现的是 组织成 分组的 各字段在一组的字符串。
select substr(bs, 0, instr(bs, '.', -1) - 1) as pbs, bs
from BS_METADATAMODEL
实现的是竖型的 按字段显示