Re: How to concatenate multiple rows from db_source?

badri wrote:
>
> Hi:
>
> I would like to concatenate all rows of the db_source column
> for a given "name". Thus, I want one column in my result that has
> the concatenation of all the lines of the selected procedure,
> for example.
>

DECLARE
        RESULT VARCHAR2(10000);
 CURSOR src FOR SELECT TEXT FROM DB_SOURCE WHERE ...; BEGIN
 FOR src_r IN src LOOP

    RESULT:= RESULT || src_r.text;
 END LOOP;
END;

-- 
S. Lott
Consultant, NE Region
CTG
SLOTT_at_DELPHI.COM
S.LOTT_at_CTG.COM
800-992-5350 box 7053