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
