Re: SQLPLUS - rollup concatenation question

Dan Levy wrote:

> A query of the kind brains of the group.
>
> Is there any function available in sqlplus that will allow the concatenation
> rollup of a textual field with an SQL query.
>
> And if available, what is the earliest version of Oracle that this will work
> on.
>
> For example this would look like
>
> Mytable
>
> A B
> ---+---
> ape bug
> ape dog
> ape man
> cat rat
> cat dog
>
> select concatenationrollup(A,B,';') from Mytable;
>
> A B
> --- ---
> ape bug;dog;man
> cat dog;rat
>
> Thanks in advance
> Dan
>
> If replying by email please use
> drlevy_at_glowing.com (replace "glowing" with "lucent")

No. You will need to use PL/SQL.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)