There is a table store data as:

columnA columnB
1 A
1 B
1 C
1 D
2 A
2
2 C
2 D

what's the most efficent way to create a veiw as:

1 A B C D
2 A C D

I can use decode to do this. or matrix table to join them.

Any body have better ideas?

Thanks.


Oracle LazyDBA home page