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

Oh, btw, the answer does NOT include cursors, PL/SQL, or dbms_output_anything. All native, ANSI-standard SQL.

Paul

Paul Horan <kerryh_at_buffnet.net> wrote in message news:3735c6be.0_at_news3.buffnet.net...
> 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 - 22:25:24 CDT