Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 15th, 2004, 03:48 AM
Registered User
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Inverse Matrix concept in ORACLE

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,

Old July 15th, 2004, 04:08 AM
Friend of Wrox
Join Date: Jun 2004
Posts: 331
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to qazi_nomi

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

Cheers (:_:)

Love is the most beautiful thing of this world. So do this !
Old July 15th, 2004, 04:23 AM
Registered User
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

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

Old July 19th, 2004, 10:37 AM
Authorized User
Join Date: May 2004
Posts: 28
Thanks: 0
Thanked 1 Time in 1 Post

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
XMail Concept (Help) gmbalaa General .NET 1 August 26th, 2007 01:57 PM
shopping cart concept sarah lee ASP.NET 1.0 and 1.1 Basics 1 October 16th, 2006 12:29 PM
Design Concept shazza Biztalk 1 August 23rd, 2006 09:54 AM
Concept of VB.net johnsonlim026 General .NET 1 July 10th, 2006 05:43 AM
Is there "Floating ToolBar" concept in C# ? kishore_peddi C# 1 April 15th, 2004 01:58 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.