SQLPLUS - rollup concatenation question

From: Dan Levy <Dee-Arr-Levy_at_lucent.com>
Date: Fri, 11 Feb 2005 16:16:25 -0600
Message-ID: <cujarp$muh_at_netnews.proxy.lucent.com>



[Quoted] [Quoted] 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") Received on Fri Feb 11 2005 - 23:16:25 CET

Original text of this message