Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Crosstab with Oracle SQL, PL/SQL

Crosstab with Oracle SQL, PL/SQL

From: chris <dawnchri_at_gmx.de>
Date: Thu, 07 Dec 2000 14:43:56 +0100
Message-ID: <3A2F941B.462EF179@gmx.de> 






Hello,



does anybody can give me an easy example in Oracle SQL, PL/SQL of a
'crosstable' like following,



from...


USA           1997        44
China          1997        64
Canada       1997        13
USA           1998        47
China          1998        78
Canada       1998        97






to...


                  1997        1998
USA            44             47
China           64             78
Canada        13             97


Received on Thu Dec 07 2000 - 07:43:56 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US