how to concatenate two string or two values in oracle sql ?

Question

Question

Amira

Asked: June 14, 20162016-06-14T23:36:50+03:00 2016-06-14T23:36:50+03:00In: Oracle SQL

i have a beginner question in SQL
how to concatenate two string or two values in sql?

You must login to add an answer.

Need An Account,

Hassan AbdElrahman · Answer 1 · 2016-06-14T23:40:40+03:00

Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

It is ||, for example:

select 'Mr ' || emp_name from employees;

or concatenate two column values by :

select first_name || '-' || last_name
from employees;