Re: Return rows as 1 line?
Date: Tue, 18 May 2010 01:36:15 +0000 (UTC)
On Mon, 17 May 2010 14:02:24 -0700, joel garry wrote:
> On May 17, 1:17 pm, The Magnet <a..._at_unsu.com> wrote:
>> Ok, I am hoping this is now going to be nuts, but say I have data like
>> 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:
>> 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 >
To tell the truth, I don't really like Tom's answer, either. Oracle is a relational database. Relational databases should return the requested rows, as quickly as possible. Relational databases are not formatting tools. Formatting the output is a job for the client tools, not for Oracle.Received on Mon May 17 2010 - 20:36:15 CDT