Oracle 学习笔记(11)

行列转换

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的内容会补充进来。

posted on 2012-12-11 16:37  扭头撞到墙  阅读(132)  评论(0编辑  收藏  举报