Re: Complex Select

From: Jens Kammler <zero.privat_at_goldmail.de>
Date: Thu, 20 May 2010 19:07:05 +0200
Message-ID: <ht3q8m$3iq$00$1_at_news.t-online.com>


"The Magnet" <art_at_unsu.com> schrieb :
> I've modified this select statement so that it will take a column from
> multiple rows and concatenate them and delimit them. The value
> returned is this:
>
> 2:Media","1:Pages","5:Trading","3:Links
>
> However, using the query below, I cannot find a way to get the
> beginning and ending quotes. Help?
>

Untestet, what about?

  '"' || LTRIM(SYS_CONNECT_BY_PATH(services,''","''),''","'') || '"' services Received on Thu May 20 2010 - 12:07:05 CDT

Original text of this message