sorry, didn't know that it is limited by an edition
it worked for me on 10.2.0.4 and 10.2.0.5 database but I used either
Standard or Enterprise edition (as corporate programmer I use Express
Edition like once a year for personal projects)
so nothing then, good luck with the issue
hoppo
On 10. 12. 2010 7:47, gayathri Dev wrote:
it is not working in my 10g edition as well.
Thanks
On Thu, Dec 9, 2010 at 10:41 PM, Gopakumar Pandarikkal
<[email protected] <mailto:[email protected]>> wrote:
replace(wm_concat(c1),',','')
It is not working in my 10g express edition !!!
Gayathri, is it working in your system ?
many ways of solving this is given here. but all udf based.
http://www.oracle-base.com/articles/misc/StringAggregationTechniques.php
gopa
On Fri, Dec 10, 2010 at 11:41 AM, Andrej Hopko
<[email protected] <mailto:[email protected]>> wrote:
just try it like this =)
SELECT replace(wm_concat(c1),',','')
FROM tab1;
for me it works also on 10g (tested now and used many times
before)
On 10. 12. 2010 5:33, gayathri Dev wrote:
No Gopa, this is 10g.
Thanks
-G
On Thu, Dec 9, 2010 at 8:28 PM, Gopakumar Pandarikkal
<[email protected] <mailto:[email protected]>> wrote:
if it is version 11,you may use wmconcat() function
regards
Gopa
On Dec 10, 2010 6:48 AM, "gayathri Dev"
<[email protected] <mailto:[email protected]>> wrote:
Hi All,
I would like to concatenate column value as single string.
Eg:
select c1 from tab1
a
b
c
I need the output as
abc
Thanks in advance
-G
--
You received this message because you are subscribed to
the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to
[email protected]
<mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:[email protected]>
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to
the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to
[email protected]
<mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:[email protected]>
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the
Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to
[email protected]
<mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:[email protected]>
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to
[email protected]
<mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:[email protected]>
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
Gopakumar P.G.
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
<mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:[email protected]>
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
