[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Converting rows to columns(Oracle SQL)

Posted on 2009-05-08
1
Medium Priority
?
1,319 Views
Last Modified: 2013-12-07
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.
0
Comment
Question by:manjeetsc
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 200 total points
ID: 24339133
please see this tutorial how to implement this function, usually known under the name of stragg:
http://www.sqlsnippets.com/en/topic-11591.html
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses
Course of the Month9 days, 15 hours left to enroll

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question