tried the same on 10g No luck!..:-(
On Thu, Dec 9, 2010 at 10:11 PM, Andrej Hopko <ado.ho...@gmail.com> wrote: > 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> 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> 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 >> 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 > > > -- > 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 > -- 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
