SQL sentence

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:43:50 CDT