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.
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