Oracle连接字符串
How to make String Conjunction ?Below is a article from my old blog.多行记录合并字符串的几种方法怎么合并多行记录的字符串?什么是合并多行字符串(连接字符串)呢,例如:SQL> desc test;Name Type Nullable Default Comments ------- ------------ -------- ------- -------- COUNTRY VARCHAR2(20) Y CITY VARCHAR2(20) Y SQL> select * from test;COUNTRY CITY-------------------- --------------------中国 台北中国 香港中国 上海日本 东京日本 大阪要求得到如下结果集:------- --------------------中国 台北,香港,上
在itpub开博了
In my career If there is something gave me big help , that is one person and two groups.One person is my uncle , he once been ORACLE southwest region manager, he let me learn Oracle.Two groups is itpub and cnoug. At first I got many knowledge from cnoug , then I became an administrator of cnoug , answered thousands question for oracle fans. But since 2008, cnoug is getting crash, so sad ... In itpub, I just search material or ask question. Only request, no give :- ) Indeed, I got much useful inf