SQL format resultset dilemma

[ttrinh]

Hi,
I want to return a resultset with a grouping function in it that lists all common items on a single row.
Like if I have a table like so :
Field1 Field2 field3 field 4
-----------------------------------------
1 a a b
1 a a d
1 a c c
I want it to be format like :
Field1 Field2 field3 'result'
-----------------------------------------
1 a a b, d
1 a c c

I am told this is not possible with straight sql(ie group by functions) but how to do it ?
any help appreciated !!
TIA

 

[Mockenrue]

You need PL/SQL for this, using a PL/SQL table.

 

[ttrinh]

Mockenrue,
Can you elaborate ? possibly with an example? I use PL/SQL but I'm not sure I follow what you mean

thanks

 

[Mockenrue]

I don't know if you're familiar with the PL/SQL Table concept, but with that you can
create temporary arrays in a procedure or function. I did not quite understand your
example case but I guess what you want to do is tallying occurances of combinations.

You can build a PL/SQL table in which you register the combinations encountered and
its count. After that you can present the results by reading from the PL/SQL table.

As I said, I didn't understand the required logic/criteria in your case, so can't give an
example.