banweili008的博客

需求需要把多行数据拼接为一行,而且要按顺序 一开始用的EN_CONCAT函数,数据拼接是没问题,可是排序却怎么也排不了,子查询呀,临时表啊都试了,但就是一group by 排序就乱 后来百度发现了listagg函数,简直不要太巴适~ SELECT T.ID, LISTAGG(T.NAME,',') WITHIN GROUP ORDER BY(T.ORDER_NO) FROM TABLE T GROUP BY T.ID ...

merge_into MERGE INTO LHJH_TBVAL_DNGHBZ A USING (SELECT '89DAE2E3BF9D7DD5E0530100007F2F38' AS VAL_ID FROM DUAL) B ON (A.VAL_ID = B.VAL_ID) WHEN MATCHED THEN UPDATE SET NUM_BFDX = '2', NUM_YKZBFDX = '1', NUM_WCL = ROUND('1' /