Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    46

    Unanswered: Rows to de displayed as columns

    Hello,

    I am working in Oracle 9.2.0.7. I have the data like this :

    Veh_Id Option_Cd Option_Desc

    25 AU CD Players
    25 AX AC
    25 AY Stereo

    and so on. That is for a Veh_Id I have 10 option_cds and option_desc stored in my table which is row wise.
    I want to fetch the data like this...

    Veh_Id Option_Cd Option_Desc Option_Cd Option_Desc ......

    as 10 columns for each veh_id.

    How do I achieve this? Can anyone help me on this ?

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    My blog article on Pivot Queries may help you.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    also search for examples on this board.
    There should be plenty of them.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •