RE: How to "concat" row values into a single column?

Listers,

The first time I ever saw someone use the "sys_connect_by_path" to concatenate values like this was in a posting from Stephane Faroult on this very list some time back (October 2003). Others may have independently come up with the same idea prior to that but I remember Stephane's posting because (1) it was the first time I had seen that approach, and, (2) how the heck does someone come up with such an idea, using that feature in such a novel way? Pretty cool <grin>.

Regards,

Larry G. Elkins
elkinsl_at_flash.net
214.954.1781

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Alex Gorbachev
> Sent: Wednesday, August 09, 2006 2:22 AM
> To: anysql_at_gmail.com
> Cc: saibabu_d_at_yahoo.com; oracle-l_at_freelists.org
> Subject: Re: How to "concat" row values into a single column?
>
>
> Look at http://tkyte.blogspot.com/2006/08/evolution.html
>
> 2006/8/8, Lou Fangxin <anysql_at_gmail.com>:
> > if running on 9i or above, PIPELINE function can be used to do this.
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l