SQLPLUS - rollup concatenation question

Andy Hassall · *nix forums Guru Joined: 20 Feb 2005 Posts: 874

On Fri, 11 Feb 2005 16:16:25 -0600, "Dan Levy" <Dee-Arr-Levy@lucent.com> wrote:

DA Morgan · *nix forums Guru Joined: 06 Mar 2005 Posts: 1042

Dan Levy wrote:

Dan Levy · *nix forums beginner Joined: 11 Feb 2005 Posts: 1

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@glowing.com (replace "glowing" with "lucent")

Google