Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle cross table
<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
![]() |
![]() |