Skip to Content
Former Member
Dec 16, 2011 at 02:56 PM

Using custom function and group by clause in BODI


I have a situation in which I need to use custom fuction and group by clause as well in BODI,

I need to do something like this in BODI,

select A,group_concat(B) from dual group by A

here A is a number and B is a varchar

I need to concat the data in B which is string


business 1

objects 1

data 1

integrator 1

output should be "business objects data integrator".. I just want to achieve group_concat function as it is, in BODI.. Thanks 😊