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
