Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012
    Posts
    1

    Question Unanswered: Alternate solution of listagg function in oracle 10g?

    My requirement is
    source-
    NUM VAL

    1 A
    1 B
    2 B
    3 C
    4 D
    4 E

    target-
    NUM VAL

    1 A,B
    2 B
    3 C
    4 D,E

    I want to get the target either by sql query or procedure but not using listagg function. Can anyone help?

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    You may find many alternative methods in this article: http://www.oracle-base.com/articles/...Techniques.php
    Some of them also allow ordering of the aggregated string. Just pick up the one you like most.

Posting Permissions

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