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
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