SQL: Displaying rows as column headers help

From: laura pena <lizzpenaorclgrp_at_yahoo.com>
Date: Thu, 24 Jul 2008 13:38:12 -0700 (PDT)
Message-ID: <246264.40689.qm@web58206.mail.re3.yahoo.com>

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
 
 

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 24 2008 - 15:38:12 CDT