Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle cross table

Re: oracle cross table

From: Phil Preen <obiwan-preen_at_maytheforcebewithyou.co.uk>
Date: Tue, 11 Jan 2000 12:46:36 -0000
Message-ID: <947594966.397266@red.parallax.co.uk>

<analyst_user_at_my-deja.com> wrote in message news:85croe$66s$1_at_nnrp1.deja.com...
> I have the following data.
>
> Name Age Contact Amount
> --------------------------------------------------------
> John Smith 30 Jane Doe 10
> John Smith 30 Joe Klein 10
>
>
> I am trying to get this result.
>
> Name Age Primary Contact Secondary Contact Amount
> ---------------------------------------------------------------------
> John Smith 30 Jane Doe Joe Klein 10
>
>

There are lots of different ways to get those results from this data. What is it you are actually trying to do? Received on Tue Jan 11 2000 - 06:46:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US