Hi All,

Can some one tell me how to do inverse of a matrix concept in ORACLE.
i.e. Consider a table which has three rows and two columns.
I need a query which will provide me two rows and three columns.
All columns should become rows and all the rows should become columns.

It will be great if some one could provide an answer for the same.


Thanks and regards,
Srivatsan.

Srivatsan

Dear Srivatsan either you want to display in this order or store in that order ?





Cheers (:_:)



Numan
--------------------------------------------------
Love is the most beautiful thing of this world. So do this !

We have store in that order.i.e.you have create another table which should be the inverse of this table.

Srivatsan

Try looking here asktom.oracle.com and search for analytical functions.