Re: rotation table in 90 degree - help

Use decode to turn rows into columns.

Daniel Morgan

ori wrote:

> Hi,
>
> I need to create a view that looks like a 90 degree rotation of the
> original table.
> for example: say my table looks like:
> A B
> 1 100
> 2 500
> 3 150
> 2 300
> 2 350
> 1 200
>
> then my view should look something like:
> 1 100 200
> 2 500 300 350
> 3 150
>
> I cant know how many rows in the table contain the same A data.
> can I create a view like this?
>
> thanks alot
> Ori
Received on Fri Feb 15 2002 - 10:59:52 CST