海鸥航迹

学习之笔记，好文之收集。

导航

2011年1月24日 #

Oracle 行列转换(PIVOT)的N种方法

摘要： Oracle SQL - pivoting one row of several columns into one column of several rows Oracle Tips by Burleson Consulting There are many ways to use Oracle to pivot column data for display on a single row:... 阅读全文

posted @ 2011-01-24 15:10 海天一鸥 阅读(8111) 评论(0) 推荐(0) 编辑

ORACLE wm_concat (wmsys.) 函数(行列转换函数)

摘要： SQL wm_concat functionExpert Oracle Tips by Burleson Consulting September 19, 2010 Question: I have a table test_test and I need to count the distinct mark columns and them display all matching valu... 阅读全文

posted @ 2011-01-24 15:02 海天一鸥 阅读(2813) 评论(0) 推荐(0) 编辑