CONCAT OPERATOR “||”

The Oracle and PL/SQL || operator allows you to join (concatenate) two or more strings together.

The general format is:

char1||char2||char3...

Example 1:

SELECT 'JOHN '||'WILLIAMS' FROM DUAL;

returns:

JOHN WILLIAMS

Example 2:

SELECT 'a'||'b'||'c' FROM DUAL;

returns:

abc