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

Use PLSQL:
cursors and dbms_output.put_line ............ If you are a real man you'll figure it out on your own

Good luck!

Vitaliy Mogilevskiy

Sanjaya Ganesh wrote:

> 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 Sun May 09 1999 - 00:40:24 CDT