Listagg Usage to get a specific type of o/p

[oecboy]

Hi. I have a table with data in below format:
Table A
Id Value
1 R
2 S1
2 S2
3 T

I need the o/p in below format:
Col
R|S1|T
R|S2|T

This might vary. The general idea is that multiple value for any given id must be aggregated separately.
Any help will be awesome. Thanks in advance.

Regards
Vicky

[Tim...]

Hi.

At first glance this seems like a normal string aggregation thing.

http://www.oracle-base.com/articles/mis ... niques.php

Actually, it's quite different. I'm really not sure how I would approach this. I will mull it over, but nothing springs to mind...

Cheers

Tim...