DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2000

    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,

  2. #2
    Join Date
    Jul 2002
    Lake Worth, FL
    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
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.