en, 系统中GROUP函数都是对数值进行计算(除了DISTINCT),而我想对字符串进行计算,比如说,将GROUP出来的字符串字段相连接,如: tab1表里的数据如下: col1 col2 ----------------- 0001 Tom 0001 Jack 0001 Mike 0002 Kate 0002 Rose 0002 Fene写一个函数MERGE_STRING(strCol VARCHAR2, delimeter VARCHAR2),然后用SQL:SELECT COL1,MERGE_STRING(COL2, ",") FROM TAB1 GROUP BY COL1,可以得到如下结果: col1 MERGE_STRING(COL2, ",") ----------------- 0001 Tom,Jack,Mike 0002 Kate,Rose,Fene
tab1表里的数据如下:
col1 col2
-----------------
0001 Tom
0001 Jack
0001 Mike
0002 Kate
0002 Rose
0002 Fene写一个函数MERGE_STRING(strCol VARCHAR2, delimeter VARCHAR2),然后用SQL:SELECT COL1,MERGE_STRING(COL2, ",") FROM TAB1 GROUP BY COL1,可以得到如下结果:
col1 MERGE_STRING(COL2, ",")
-----------------
0001 Tom,Jack,Mike
0002 Kate,Rose,Fene