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

    Unanswered: How to change row into columns

    Hi to all
    I am new to oracle
    I have table like this

    Productname Materialname Rate output
    p1 M1 3.2 1000
    p1 M2 1.2 2000
    p1 M3 1.6 1322
    p1 M4 . .
    P2 m1 . .
    p2 m2 . .
    p2 m3 . .
    p2 m4 . .
    . . . .
    . . . .
    . . . .
    . . .

    But i have requirenment like.
    Productname M1 m2 m4 m4 Rate output


    Plz help me how to achiev this...

    Thanks in advance

    Yogisha

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    interesting use of dots .......
    do they impart special knowledge that I am not tuned to receive?
    Exactly what RATE & OUTPUT value should exist in new/change row?
    What happens to previously existing rows after producing desired results?
    I am sure you understand my confusion ........

    Realize everyone here speaks SQL so feel free to use it for future posts here.
    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
  •