摘要:
将多行数据拼接成一行:--wmsys.wm_concatselect wmsys.wm_concat(a.hdid) as test from flow_currentrecord a where a.flowid=222 group by a.flowid;但有大小限制:字符串缓冲区太小,超过varchar 4000长度。扩展:更改返回类型为clob--Type CREATE OR REPLACE TYPE zh_concat_im AUTHID CURRENT_USER AS OBJECT ( CURR_STR clob, STATIC FUNCTION ODCIAGGREGATE... 阅读全文