全部博文
-
编辑 删除
oracle 多条查询记录 结果连接成以逗号分割字符串
SELECT so.process_instance_id,( SELECT LTRIM( MAX(SYS_CONNECT_BY_PATH(wo, ',')), ',') FROM (SELECT wo, RN, LEAD(RN) OVER(ORDER BY RN) RN1 FROM (SELECT wo, ROW_NUMBER() OVER(ORDER BY wo DESC) RN FROM (  
