This question was raised previously, Search "Concatenating rows in Oracle SQL" topic in this group.
Regards, Sonty On Dec 12, 7:41 am, gayathri Dev <gd0...@gmail.com> wrote: > Thanks all.. > Pivot was in 11, tried stragg.. it worked fine. > finally choose sys_connect_by_path. > > appreciate all of your help. > > -G. > > On Sat, Dec 11, 2010 at 9:29 AM, Andrey Nikolaev > <nikolaev.and...@gmail.com>wrote: > > > It's worth looking at the function sys_connect_by_path. It'll be a bit > > more complex than stragg or wm_concat but it's there since version 9. > > > On Dec 10, 7:07 pm, gayathri Dev <gd0...@gmail.com> wrote: > > > appreciate all the responses. > > > Let me try to use Pivot and stragg > > > shall post updates. > > > > On Fri, Dec 10, 2010 at 7:33 AM, Michael Moore <michaeljmo...@gmail.com > > >wrote: > > > > > Typo, should say: AGGregation. > > > > Mike > > > > > On Fri, Dec 10, 2010 at 7:32 AM, Michael Moore < > > michaeljmo...@gmail.com>wrote: > > > > >> What you are looking for is called a "stragg" function. STRing > > > >> AGGrication. > > > > >> If you google 'plsql stragg' you will find many examples of how to do > > it. > > > >> I have some examples at work which I would post, but I'm currently on > > > >> vacation. > > > > >> Mike > > > > >> On Thu, Dec 9, 2010 at 11:31 PM, R venkat <byven...@gmail.com> wrote: > > > > >>> Hi Gayathri, > > > > >>> U can use Pivot query. > > > > >>> Thanks, > > > >>> Venkat > > > > >>> On Fri, Dec 10, 2010 at 12:47 PM, Andrej Hopko <ado.ho...@gmail.com > > >wrote: > > > > >>>> sorry, didn't know that it is limited by an edition > > > > >>>> it worked for me on 10.2.0.4 and 10.2.0.5 database but I used either > > > >>>> Standard or Enterprise edition (as corporate programmer I use > > Express > > > >>>> Edition like once a year for personal projects) > > > > >>>> so nothing then, good luck with the issue > > > > >>>> hoppo > > > > >>>> On 10. 12. 2010 7:47, gayathri Dev wrote: > > > > >>>> 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 > > > > >>>> -- > > > >>>> 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 > > > > >>> -- > > > >>> Cheers, > > > >>> Venkat > > > > >>> -- > > > >>> 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
