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;
ORACLE 单列查询变单行显示
原文：http://blog.csdn.net/helloboat/article/details/44175423
