ORACLE 10g 的行列互转函数

行列互转下面这个函数最简单，虽然是多行转一列，但正是我要的结果。感觉有点象字符类型的sum函数，哈哈。（直接从别人的贴在粘贴过来的哈。）；sys_context的用法学习了。

SQL> create table test(c1 varchar2(10),c2 number);

Table created

SQL> insert into test values('A',80);

1 row inserted

SQL> insert into test values('B',70);

1 row inserted

SQL> insert into test values('C',80);

1 row inserted

SQL> insert into test values('D',60);\

1 row inserted

SQL> insert into test values('E',70);

1 row inserted

SQL> commit;

Commit complete

SQL> select * from test;

C1               C2
---------- ----------
A                 80
B                 70
C                 80
D                 60
E                 70

SQL> select WMSYS.WM_CONCAT(c1),c2 from test group by c2;

WMSYS.WM_CONCAT(C1)                                                  C2
-------------------------------------------------------------------------------- ----------
D                                                                                       60
B,E                                                                                    70
A,C                                                                                    80

SQL>