摘要:
SELECT T_TABLE1.ID, T_TABLE1.IDS, LISTAGG(T_TABLE2.NAME, ',') WITHIN GROUP ( ORDER BY T_TABLE2.ID) PRO_NAMES FROM T_TABLE1, T_TABLE2 WHERE INSTR(',' | 阅读全文
摘要:
--将查询的,分隔的字段从行转成列select REGEXP_SUBSTR(ids, '[^,]+', 1, rownum) AS ids from ( select listagg(ids, ',') WITHIN GROUP ( ORDER by ID) ids from t_table ) c 阅读全文
摘要:
sping中的controller接收实体参数时如果实体中存在list属性,当list数值过大时报错 public class Model{ private List<String> strings; } 报错信息:"Invalid property 'rynrlist[256]' of bean 阅读全文