How to convert Columns into Rows in Oracle 9i? RRS feed

  • 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,


    Friday, July 15, 2011 1:21 AM


All replies