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
<pandarik...@gmail.com <mailto:pandarik...@gmail.com>> wrote:
if it is version 11,you may use wmconcat() function
regards
Gopa
On Dec 10, 2010 6:48 AM, "gayathri Dev" <gd0...@gmail.com
<mailto:gd0...@gmail.com>> 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
Oracle-PLSQL@googlegroups.com <mailto:Oracle-PLSQL@googlegroups.com>
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
<mailto:oracle-plsql-unsubscr...@googlegroups.com>
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 Oracle-PLSQL@googlegroups.com
<mailto:Oracle-PLSQL@googlegroups.com>
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
<mailto:oracle-plsql-unsubscr...@googlegroups.com>
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 Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
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 Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
