1.在oracle里面怎么吧查出来的记录合并成一条呢?
从一个表里的查询结果
result
-------------
a
b
c变成
result
-----------
a b c2.另外
result1
------
one,two,three,select * from a where a.value in ('one','two','three')用result1怎么替代 ('one','two','three')呢?
从一个表里的查询结果
result
-------------
a
b
c变成
result
-----------
a b c2.另外
result1
------
one,two,three,select * from a where a.value in ('one','two','three')用result1怎么替代 ('one','two','three')呢?
http://blog.csdn.net/kinglht2.select '('''||Replace('one,two,three', ',', ''',''')||''')' from dual;