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

Using custom function and group by clause in BODI

34 Views

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

B A

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 😊