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

Well, I'm a man, and I know how to do it too, but even I'm too offended by the question to post the response.

Paul Horan
VCI
Springfield, MA

Glenn Baron <gbaron_at_dial.pipex.com> wrote in message news:01be9a17$7db51fa0$155595c1_at_default...
> Well, I know how to do it but I'm a woman.
>
> Obviously a macho type like you would be unable to accept advice from a
> 'girl' , so crack it yourself sonny.
>
> Regards,
>
> Alison
>
> Sanjaya Ganesh <sganesh_at_apple.com> wrote in article
> <37348614_at_discussions>...
> >
> > 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 - 12:35:07 CDT