Re: Reading column into a string variable

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 13 Nov 2006 12:39:43 -0800
Message-ID: <1163450383.322529.107270@m7g2000cwm.googlegroups.com>

zomer wrote:
> Hi,
> I need to read all entries of a column into a varchar variable. There
> are about 100 entries.... how can i do it in PL/SQL?
>
> Table
> Name
> alex
> brad
> cynthia
> .
> .
> .
> .
> zomer
>
> Anticipated output
> alex,brad,cynthia.....,zomer

Probably you should create a plsql table and do a bulk collect into the table. Include a where clause that includes the order by so that it is sorted in the order you desire.

>
> Thanks.
Received on Mon Nov 13 2006 - 14:39:43 CST