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 - 04:47:11 CDT