I have a table in which there is a identifier against which I have email address. Now there can be multiple entries for a identifier. Example
I need to get the list of email addreess against each identifier a,b and c in a single row. could some body tell me how to do this in oracle sql.
the end result should be
I don't want to write code. I just want ot use query.