just try it like this =)
SELECT replace(wm_concat(c1),',','')
FROM tab1;
for me it works also on 10g (tested now and used many times before)
On 10. 12. 2010 5:33, gayathri Dev wrote:
No Gopa, this is 10g.
Thanks
-G
On Thu, Dec 9, 2010 at 8:28 PM, Gopakumar Pandarikkal
<[email protected] <mailto:[email protected]>> wrote:
if it is version 11,you may use wmconcat() function
regards
Gopa
On Dec 10, 2010 6:48 AM, "gayathri Dev" <[email protected]
<mailto:[email protected]>> wrote:
Hi All,
I would like to concatenate column value as single string.
Eg:
select c1 from tab1
a
b
c
I need the output as
abc
Thanks in advance
-G
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to
[email protected] <mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:[email protected]>
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
<mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:[email protected]>
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
