ORACLE 单列查询变单行显示
- 作者: 嗫?暁雲?
- 来源: 51数据库
- 2022-08-17
SELECT substr(sys_connect_by_path(dutywork, ';'), 2)
FROM (select dutywork,rownum rn
from t_test)
WHERE connect_by_isleaf = 1
START WITH rn = 1
CONNECT BY prior rn = rn - 1;
查询表t_test的一列，查询出的结果，显示为一行，各个行之间以“;”分割
推荐阅读
