Skip to Main Content

SQL Developer

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!

Query to display rows in a column to horizontal values

User_MURCJJun 13 2023 — edited Jun 13 2023

Let's say there is a table with emp_id and emp_name as below

emp_id | emp_name

1345 | Mark

1346 | Adam

1347 | George

1348 | Martin

1349 | Austin

1350 | Boris

Output:

Mark ; Adam; George; Martin; Austin; Boris

Comments
Post Details
Added on Jun 13 2023
1 comment
281 views