Another Way to CONCAT in Oracle SQL

Question

I try to concat 3 columns with separator .

Example :

Result = TEST, TEST2 (2020)

Someone can help me ?

Thanks!

Answer 1

You can just express what you want using ||:

select last_name || ' ' || first_name || ' (' || login || ')'