Re: SQL question / Multiple rows output in one line
From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Wed, 5 Nov 2003 15:21:51 -0500
Message-ID: <d_udnY3GCf-NwTSiRVn-sg_at_comcast.com>
Date: Wed, 5 Nov 2003 15:21:51 -0500
Message-ID: <d_udnY3GCf-NwTSiRVn-sg_at_comcast.com>
write a stored function that does a PL/SQL loop to concatenate the values, call the function within the select column list
SELECT id, name, cities_list(id)
from ...
-- Mark C. Stock email mcstock -> enquery(dot)com www.enquery.com (888) 512-2048 "dirk" <dirk_at_acker.com> wrote in message news:3fa923f7_1_at_127.0.0.1...Received on Wed Nov 05 2003 - 21:21:51 CET
>
> How can I do this?
>
> Table A
>
> A B
> ---------------------
> John New York
> John Miami
> John ...
> Max London
>
> I want to do a SELECT which outputs
>
> John, New York Miami ... in one Line
>
> How can I do this?
> Can
>
>
>
> ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
> http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000
Newsgroups
> ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
=---