DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: PLSQL

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    hai

    i have a table

    C1 C2

    A B
    A C
    A D

    Now I need an output like this

    A BCD

    ie concatenating the string for a particular value of C1
    Like how we perform aggregation on groupby
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    Apr 2002
    Location
    Philippines
    Posts
    77
    try creating a function which returns a concatenation of c2 values given c1, then use it in the query something like:

    select c1, concat_function(c1)
    from table_name
    group by c1

    hth.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width