Skip to Main Content
Forums

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!

concatenate two column values with a delimiter(',')

User_BXLRVOct 9 2019 — edited Oct 9 2019

Requirement : concatenate two column values with a delimiter(',')

Table A
Column 1Column 2
1A
Table B
Column 1Column 3
1B

Output :

Column 1

Column 2||column 3

1A,B

The output is column 1 from Table A and Table B which is primary key and column 2||Column 3

I can get this functionality as below

Column 2||','||Column 3 but when column 2 is null and column 3 is not null  i am getting ',' at the beginning which i don't want.

Please suggest.
This post has been answered by Frank Kulash on Oct 9 2019
Jump to Answer
Comments
Post Details
Added on Oct 9 2019
3 comments
18,651 views