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!

Sql Query to convert multiple column lines into single line

655591May 12 2009 — edited May 12 2009

Hi,

I need to display all values of a column into a single row/line/record.
I.e., There is a table EMP, consists of 10 records

EMP

EMP NO
1
2
3
.
.
10

I want to display EMPNO as: 1-2-3- ... -10

Thanks
Santhosh K

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2009

Added on May 12 2009

5 comments

2,040 views