Re: Return rows as 1 line?
From: joel garry <joel-garry_at_home.com>
Date: Mon, 17 May 2010 14:02:24 -0700 (PDT)
Message-ID: <39437163-a8f8-4c11-a1ec-7957fe94f3c6_at_z13g2000prh.googlegroups.com>
On May 17, 1:17 pm, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> Ok, I am hoping this is now going to be nuts, but say I have data like
> this:
>
> ID PRODUCT SKU
> 1 ABC 123
> 1 DEF 456
> 2 XYZ 000
> 2 MNO 999
> 3 GHI 888
>
> And this is what I would need:
>
> 1,ABC:123,DEF:456
> 2,XYZ:000,MNO:999
> 3,GHI:888
>
> So, records that have a certain criteria would have certain columns
> concatenated. I'm thinking of putting together a dynamic query and
> then opening a cursor and selecting from it, creating the string as I
> go along.
>
> Any thoughts? I'm going to go with the dynamic cursor unless someone
> else has a better idea.
Date: Mon, 17 May 2010 14:02:24 -0700 (PDT)
Message-ID: <39437163-a8f8-4c11-a1ec-7957fe94f3c6_at_z13g2000prh.googlegroups.com>
On May 17, 1:17 pm, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> Ok, I am hoping this is now going to be nuts, but say I have data like
> this:
>
> ID PRODUCT SKU
> 1 ABC 123
> 1 DEF 456
> 2 XYZ 000
> 2 MNO 999
> 3 GHI 888
>
> And this is what I would need:
>
> 1,ABC:123,DEF:456
> 2,XYZ:000,MNO:999
> 3,GHI:888
>
> So, records that have a certain criteria would have certain columns
> concatenated. I'm thinking of putting together a dynamic query and
> then opening a cursor and selecting from it, creating the string as I
> go along.
>
> Any thoughts? I'm going to go with the dynamic cursor unless someone
> else has a better idea.
http://asktom.oracle.com/pls/asktom/f?p=100:11:4579694231612304::::P11_QUESTION_ID:229614022562
jg
-- _at_home.com is bogus. B of A branch in a van down by the river (click on aerial or birds-eye view): http://locators.bankofamerica.com/locator/locator/3881__Alton__Parkway,__Suite__B_92606_IRVINE_CA/bank_branch_locations/Received on Mon May 17 2010 - 16:02:24 CDT