?如何使用PL/SQL 合并查询的结果集并用逗号隔开
select replace(max(substr(sys_connect_by_path(meaning,','),2)),',',',') cc
from
(select meaning,lead(meaning)over(order by rownum desc) no from tableName )
connect by prior meaning = no
start with no is null;
?如何使用PL/SQL 合并查询的结果集并用逗号隔开
select replace(max(substr(sys_connect_by_path(meaning,','),2)),',',',') cc
from
(select meaning,lead(meaning)over(order by rownum desc) no from tableName )
connect by prior meaning = no
start with no is null;