How to convert Columns into Rows in Oracle 9i?

Question

User1666665689 posted

Dear Friends,

I am a newbie to Oracle..  I have a requirement. It is like Converting the Columns into Rows.

For Example: I have a table which looks like this:

colname1   colname2   colname3
data            data            data

I would like to have a query which returns the result set in this way:

Attribute    Value
colname1   data
colname2   data
colname3   data

Note: I need to make use of the Oracle 9i.

Plz help me in achieving this.

Thanks and Regards,

G.V.N.Sandeep

Answer 1

User535082756 posted

hi

Try this link

http://www.sqlsnippets.com/en/topic-12698.html

Hope it helps..

thanks,

 

Answer 2

User-484744148 posted

Hi,

Try this link. http://asktom.oracle.com/pls/asktom/f?p=100:11:293494070073516::::P11_QUESTION_ID:4031849343543

Look at the decode solution almost half way of the page. I think its the one you need.

NOTE: This is for 9i and up. :)

Regards,

Sgt. 8log