CONCAT

The Oracle and PL/SQL CONCAT function allows you to join (concatenate) two strings together.

The general format is:

CONCAT(char1,char2)

See “|| operator”

Example 1:

SELECT CONCAT('JOHN ','WILLIAMS') FROM DUAL;

returns:

JOHN WILLIAMS