SQL: Displaying rows as column headers help

From: laura pena <lizzpenaorclgrp@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 24 Jul 2008 13:38:12 -0700 (PDT)

So I have the following requirement:
 
CODE          COL_ID  SPECIES  FISH_ID   LOCUS     ALLELES
chintest           11       23220        1            Omm1080v1  252,268
chintest           11       23220        1            Oki10v1  183,241
chintest           11       23220        1            christian  252,268
chintest           11       23220        2            Omm1080v1  256,284
chintest           11       23220        2            Oke4v1     245,245
chintest           11       23220        2            Oki10v1  187,225

output to look like Locus should be shown columns wise with Alleles under the 
locus name:
CODE    COLID      SPE   FISH_ID  Omm1080v1 Oki10v1    christian Omm1080v1  
Oke4v1
chintest      11       23220        1         252,268
chintest      11       23220        1                           183,241
chintest      11       23220        1                                         
252,268
chintest      11       23220        
2                                                        256,284
chintest      11       23220        
2                                                                         
245,245
chintest      11       23220        2                            187,225
 
 
 
Any ideas how to  (even a start would be good) write this query? Any help is as 
always appreciated.
 
Thanks,
Lizz

Follow-Ups:

RE: Displaying rows as column headers help
From: Jackie Brock

RE: Displaying rows as column headers help
From: Ken Naim

Re: SQL: Displaying rows as column headers help
From: Nigel Thomas

SQL: Displaying rows as column headers help

Other related posts: