行列转换
select max(substr(sys_connect_by_path(column_name,','),2)) from (select column_name,rownum rn from table_name) start with rn=1 connect by rn=rownum ;
接下来关于sys_connect_by_path的内容会补充进来。