<div>
<div class="content wysiwyg-content">
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<br />
<br />
a,a@b.com<br />
a,b@b.com<br />
a,c@c.com<br />
b,m@b.com<br />
b,k@c.com<br />
c,c@c.com<br />
<br />
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.<br />
<br />
the end result should be <br />
a,a@b.com,b@b.com,c@c.com<br />
b,m@b.com,k@c.com<br />
c,c@c.com<br />
I don't want to write code. I just want ot use query.
</div>
</div>


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

a,a@b.com
a,b@b.com
a,c@c.com
b,m@b.com
b,k@c.com
c,c@c.com

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 
a,a@b.com,b@b.com,c@c.com
b,m@b.com,k@c.com
c,c@c.com
I don't want to write code. I just want ot use query.

Converting rows to columns(Oracle SQL)

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.