Home » SQL & PL/SQL » SQL & PL/SQL » Concentrating multiple rows? (Oracle 9)
Concentrating multiple rows? [message #333787] Mon, 14 July 2008 07:54 Go to next message
Messages: 1
Registered: July 2008
Junior Member

Maybe there are millions of answers, but I don't know how to find them. Sad

I have two tables:
The first one contains a group name and a link to the person who is responsible for this group
The second table contains the details for this person.

I need a statement which gives me the following output:

Name and email address (from the userform) an than a list of all groups for which this person is responsible IN ONE COLUMN.

Should look like this:

tom tom@x.xom eroup1, group2
sam sam@x.com group3, group4, group5

How can I do this?

Re: Concentrating multiple rows? [message #333789 is a reply to message #333787] Mon, 14 July 2008 07:58 Go to previous message
Messages: 4621
Registered: February 2005
Location: East Coast USA
Senior Member
Seearch for pivot here.
Previous Topic: How to dedicate USER1 for SID_INSTANCE 1
Next Topic: Complex Report using SQL*PLUS
Goto Forum:

Current Time: Sat Oct 22 02:37:00 CDT 2016

Total time taken to generate the page: 0.09865 seconds