it is not working in my 10g edition as well. Thanks
On Thu, Dec 9, 2010 at 10:41 PM, Gopakumar Pandarikkal < pandarik...@gmail.com> wrote: > replace(wm_concat(c1),',','') > > It is not working in my 10g express edition !!! > Gayathri, is it working in your system ? > > many ways of solving this is given here. but all udf based. > http://www.oracle-base.com/articles/misc/StringAggregationTechniques.php > > gopa > > > > On Fri, Dec 10, 2010 at 11:41 AM, 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 >> > > > > -- > Gopakumar P.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
