Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: Transpose a Table

    Hi Experts,

    Please help me out in the following requirement:

    Col1 Col2 Col3 Col4 Col5
    1 aaa bbb ccc ddd
    2 eee fff ggg hhh
    3 iii jjj kkk lll

    I need the out as following


    1 2 3
    aaa eee iii
    bbb fff jjj
    ccc ggg kkk
    ddd hhh lll

    Please help me out.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    search for below
    pivot
    rows to column
    column to rows

    GOOGLE is your friend
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2004
    Location
    Chennai
    Posts
    53
    -Mathan
    For a quick pocket reference of oracle refer http://pocketoracle.blogspot.com/

Posting Permissions

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