Re: Matrix select with SQL: is it possible?

"gil guerillot" <gil.guerillot_at_ratp.fr> wrote in message news:9r8go9$27db$1_at_gotix.reseau.ratp...
> I have a table with 3 fields:
>
> column: Object axes value
>
> Datas: Oi Xi/Yi Vi
>
> the field axes is always with the same separator (/)
>
> i 'd like to obtain a matrix result with sql:
>
> Yi
> Oi Xi Vi
>
>
> example of table
>
> Object axes value
> O1 A1/B1 V1
> O1 A2/B1 V2
> O1 A1/B2 V3
> O1 A2/B2 V4
>
>
> result wanted:
>
> B1 B2
> O1 A1 V1 V3
> O1 A2 V2 V4
>
>
> Is it possible and how can i do?
>
>
> thanks
>
>
>
>
>

No version and version dependent answer

Regards,

Sybrand Bakker
Senior Oracle DBA Received on Thu Oct 25 2001 - 03:19:07 CDT