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

In article <01be9a17$7db51fa0$155595c1_at_default>,   "Glenn Baron" <gbaron_at_dial.pipex.com> wrote:
> 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

Well put - I would have left out the 'Regards' though - and the 'I'm a woman' part ;-)

> 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
> >
> >
>

--
Oliver Willandsen - [European Commission - http://europa.eu.int]

All comments represent my own opinion and may not in any circumstance be regarded as stating an official position of the European Commission

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 10 1999 - 07:32:37 CDT