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!

how to concatenate multiple rows into one row using a SQL query

579729Jan 6 2011 — edited Jan 6 2011

Hi
I have a table table1 and three columns col1

data

col1
c11
c12
c13
c14
c15

Now using a SQL query (not any PL/SQL) I want the following output.

c11-c12-c13-c14-c15.

Is it possible?
If possible then please tell me how can I do that?

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 3 2011

Added on Jan 6 2011

3 comments

7,191 views