PL/SQL Concat II

Oracle PL/SQL Concat || Function

The concat || operator allows us to concatenate 2 or more strings together.

The || operator syntax:

string1 || string2 || string_n

Example:

select 'PL' || ' SQL Tutorial' from dual;
would return 'PL SQL Tutorial'


select 'e'||'x'||'a'||'m' from dual;
would return 'exam'