Challenge!! Crack it if you are a man!!

Hi ,

                I have the following requirement in
Oracle 7.3, please note ORACLE 7.3!!

                I have a table with primary key
columna and columnb. For a given value of columna ,there can be 6 different values of columnb and this 6 is fixed. I want a view which will stretch and flatten this table. That is I want a view which will show me in ONE ROW columna and the 6 different values of columnb.

i.e., Table is,

columna	colb1
columna	colb2
columna	colb3
columna	colb4
columna	colb5
columna	colb6

I want a view which will represent it as,
columna	colb1	colb2 colb3 colb4 colb5 colb6

It is real challenge, because I dont want a 6- way join!!!Hahaha!!! I know how to do with a 6 way join!!I dont want that!!

Any real men around??

--Posted from EarthWeb Discussions. http://discussions.earthweb.com Received on Sat May 08 1999 - 14:44:36 CDT