Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I need to denormalize data in sql query, please help!

tracey.sheppardSep 11 2007 — edited Sep 20 2007
With the query

select ref, start_time, end_time, person
from appointments

I get, eg:

REF START_TIME END_TIME PERSON
1234 10:00 11:00 USER1
1234 10:00 11:00 USER2

The users want to see it like this:

REF START_TIME END_TIME PERSON
1234 10:00 11:00 USER1, USER2

How do I do this just in sql?

cheers
Tracey.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2007
Added on Sep 11 2007
6 comments
1,503 views