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!

Oracle SQL - need to concatenate data from multiple rows

tparvaizSep 24 2020 — edited Sep 25 2020

Hi, I have an oracle table, something like this

ID City

1 A

1 B

3 C

here is the output that I want

ID City

1 A, B

3 C

(multiple values grouped together separated by a column)

can you please advise the SQL

Thanks

Added on Sep 24 2020

3 comments

7,165 views