Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Cursor
On 27 apr, 00:22, Jimbo <jamesfer..._at_hotmail.com> wrote:
> ok heres what Im trying to do....Im trying to flatten a record
> set...so say case number 07 has orders 1 and 3 associated with
> it....if you do a select youll get.
>
> case number order number
> ----------------- --------------------
> 07 1
> 07 3
>
> I want to use a cursor so I can concatenate the order number field and
> return
>
> case number order numbers order count
> ------------------ --------------------- -----------------
> 07 1, 3 2
>
> I can only think to do this with a cursor....if you know another way
> Im all ears
>
> -Jim
Why would you want to flatten (denormalize) a record - what's the
bigger picture
behind this - probably you focus on a little piece where te big
picture
can give a completely different (and for Oracle, far more effective!)
solution.
Received on Fri Apr 27 2007 - 04:08:20 CDT