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
