Term: CONCAT

Definition:
The Oracle CONCAT function allows you to join (concatenate) two strings together.

CONCAT(string_1, string_2);

string_1 and string_2 are the two strings to be concatenated.

The || operator allows you to concatenate 2 or more strings together:

The syntax for the || operator is:

string_1 || string_2 || string_n;



'Sunday'|| ' May 15th' - returns 'Sunday May 15th'



'1' || '2' || '2' || '4' - returns '1234'

CONCAT may also be used in more complex expressions and statements:

standard.CONCAT(

lef    VARCHAR2 CHARACTER SET ANY_CS,

right  VARCHAR2 CHARACTER SET ANY_CS)

RETURN VARCHAR2 CHARACTER SET LEFT%CHARSET;

Related Links:

Oracle/PLSQL String Functions: CONCAT

Related Code Snippets:

Concatenate || - The || operator allows you to concatenate 2 or more strings together.
String Functions: CONCAT - Concatenates two or more strings.