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的一列，查询出的结果，显示为一行，各个行之间以“;”分割