ITPub博客

今天给海鹏在测试库中处理了一个多根节点的结果集合；现在要是实现行列转换拼接成一个独立的行已经有两个方法了，哈哈哈哈哈哈哈，第二个方法可以实现[@more@]行转列08:45:47 SQL> select * from usr;NAME----------张三李四王五已选择3行。已用时间: 00: 00: 00.0008:45:57 SQL> Select Substr(Sys_Connect_By_Path(Name, ','), 2)08:46:51 2 From (Select Rownum Rid, Rownum + 1 Next_Rid, Name From Usr)08:46:51 3 Where Rid = (Select Count(*) From Usr)08:46:51 4 Start With Rid = 108:46:51 5 Connect By Prior Next_Rid

http://www.91linux.com/html/article/database/oracle/20081216/14775_4.html http://203.208.39.132/search?q=cache:TJHNiInuVlgJ:blog.csdn.net/baoqiangwang/archive/2009/10/22/4712461.aspx+oracle%E5%88%86%E6%9E%90%E5%87%BD%E6%95%B0+%E7%B4%AF%E8%AE%A1&cd=3&hl=zh-CN&ct=clnk&gl=cn&st_usg=ALhdy29N6zIg3PpMQ30XKkkcwLGxpcIdqg[@more@]select region_id, 2 customer_id, 3 ntile(5) over(order by sum(customer_sales) desc) til 4 from user_order 5 group by region_id, custo