SQL sentence

From: Mª Carmen Lozano <noriepa_at_teleline.es>
Date: Thu, 21 Jul 2005 08:38:00 GMT
Message-ID: <I9JDe.2318677$I96.2903415@telenews.teleline.es>

I have a table in oracle with information similar to this:

city     code
A         XX
B         SS
A         ZZ
C         YY
D         XX
B         SS
B         ZZ

I need to preferably make by means of a sentence SQL or by means of a process a table with the following structure:

city     SS     XX     YY     ZZ
A         0         1         0        1
B         2         0         0        1
C         0         0         1        0
D         0         1         0        0

Can somebody help me?
A greeting and thank you very much

Noriepa Received on Thu Jul 21 2005 - 03:38:00 CDT