利用Oracle WMSYS.WM_CONCAT函数实现数据表记录行列

[size=large]数据库有个PERSON_INFO表，记录如下：[/size]
[img]http://dl.iteye.com/upload/picture/pic/132684/a65e8988-c2a1-3f91-aa68-3ff80fbe2e4d.png[/img]
[size=large]我想通过一条SQL，返回如下图所示的结果：[/size]
[img]http://dl.iteye.com/upload/picture/pic/132686/86cb41b5-ebfc-3d19-a815-89adb23c617d.png[/img]
[size=large]怎么做？
强大的Oracle提供了WMSYS.WM_CONCAT函数可以解决此问题：[/size]

select WMSYS.WM_CONCAT(t.person_name) as PERSON_NAMES, t.dept_name
  from person_info t
 group by t.dept_name

[size=large]（注意，WMSYS.WM_CONCAT函数须与GROUP BY联合使用。）
That's All !
[/size]