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 <[email protected]> wrote: > Hi Gayathri, > > U can use Pivot query. > > > Thanks, > Venkat > > > > > On Fri, Dec 10, 2010 at 12:47 PM, Andrej Hopko <[email protected]>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 < >> [email protected]> 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 <[email protected]>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 < >>>> [email protected]> wrote: >>>> >>>>> if it is version 11,you may use wmconcat() function >>>>> >>>>> regards >>>>> Gopa >>>>> >>>>> On Dec 10, 2010 6:48 AM, "gayathri Dev" <[email protected]> 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 [email protected] >>>>> To unsubscribe from this group, send email to >>>>> [email protected] >>>>> 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 [email protected] >>>>> To unsubscribe from this group, send email to >>>>> [email protected] >>>>> 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 [email protected] >>>> To unsubscribe from this group, send email to >>>> [email protected] >>>> 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 [email protected] >>>> To unsubscribe from this group, send email to >>>> [email protected] >>>> 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 [email protected] >>> To unsubscribe from this group, send email to >>> [email protected] >>> 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 [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> 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 [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> 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 [email protected] > To unsubscribe from this group, send email to > [email protected] > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
