Re: SQLPLUS - rollup concatenation question

On Fri, 11 Feb 2005 16:16:25 -0600, "Dan Levy" <Dee-Arr-Levy_at_lucent.com> 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

 Not with that exact syntax, but close; you need a user-defined aggregation function, and a "group by A". Go to http://asktom.oracle.com and search for "STRAGG" - 9i or later.

-- 
Andy Hassall / <andy_at_andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool