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
