Skip to Main Content

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!

Dynamic Concatenation

1012216Jul 11 2013 — edited Jul 11 2013

Hi all,

I would like to dynamically concatenate a bunch of columns by a "-" or ","

I do not know the number or columns.

For example: If I have a table x that has 20 columns. I would like to say Select * from X seperate by "-".

Thank you

This post has been answered by BluShadow on Jul 11 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2013
Added on Jul 11 2013
3 comments
608 views