Transpose Columns
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Transpose Columns

  1. #1
    Join Date
    Nov 2000
    Posts
    205
    Does anyone have an easy way to select rows but show them transposed?

    eg
    name code zip
    aa 432 03744
    bb 343 94342

    to show as
    aa
    432
    03744

    bb
    343
    94342


    Thanks in advance,
    Nirasha
    Nirasha Jaganath

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    See the print_table function in the following link:
    http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID,F4950_P8_CRITERIA:1035431863958,{print_table}
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    hello

    look here http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID,F4950_P8_CRITERIA:124812348063,{transpose}

    regards
    hrishy

Posting Permissions

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



Click Here to Expand Forum to Full Width