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

Thread: convert many records into a single record

  1. #1
    Join Date
    Aug 2000
    Posts
    30

    Cool convert many records into a single record

    Hi anyone can give me a solution for this problem:

    My view returns data like this:

    select * from myview;

    [Id] [Name] [Function] [Functionvalue]

    1 Test 1 Testing 1 Answer 1
    1 Test 1 Testing 2 Answer 2
    1 Test 1 Testing 3 Answer 3
    1 Test 1 Testing 4 Answer 4

    I want to write a query based on this view, so that my data should look like this:


    [Id] [Name] [Testing1] [Testing2] [Testing3] [TEsting4]
    1 Test 1 Answer 1 Answer 2 Answer 3 Answer 4

    Thanks in advance,
    Jee

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492
    Seems nobody does any research anymore, this question has been answered hundreds (thousands?) of times on every forum.

    go to asktom.oracle.com
    and search for 'pivot table'
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Aug 2000
    Posts
    30
    Thanks LKBrwn_Dba....

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