CONCAT

CONCAT joins two expressions as a single character string. The data type of the return value is the same as the expressions, or if they are mixed, the one that results in a lossless conversion.

Return Value

CHAR | NCHAR | VARCHAR2 | NVARCHAR2

Syntax

CONCAT(char1, char2)

Arguments

char1 and char2 are text expressions.

Example

CONCAT('The current date is ', 'October 13, 2006') returns the string The current date is October 13, 2006.