Re: Displaying rows as columns

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 10 Feb 2006 20:49:08 +0100
Message-ID: <43ecee3b$0$17041$626a54ce@news.free.fr>

"Ric" <vsangal_at_yahoo.com> a écrit dans le message de news: 1139600577.935916.125160_at_g14g2000cwa.googlegroups.com...
|I have this kind of data
|
| ID Text
| 1 a
| 1 b
| 1 c
|
|
| I want to display this data as
|
| 1, a, b, c
|
| in sql plus oracle Any suggestions
|

Yes, search for pivot on google or AskTom.

Regards
Michel Cadot Received on Fri Feb 10 2006 - 13:49:08 CST

This message: [ Message body ]
Next message: hpuxrac: "Re: Designing indexes"
Previous message: Ric: "Displaying rows as columns"
In reply to: Ric: "Displaying rows as columns"
Next in thread: Ric: "Re: Displaying rows as columns"
Reply: Ric: "Re: Displaying rows as columns"
Reply: Ric: "Re: Displaying rows as columns"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US