Returns a concatenation of two character strings. The character data can be of the data types CHAR and VARCHAR2. The return value is the same data type as the character data.



The following restrictions apply when you use the CONCAT function in the SELECT command:

  • The function does not support LOB data types, including BLOB, CLOB, NCLOB, and BFILE data types.

  • The function does not support national character set data types, including NCHAR, NVARCHAR2, and NCLOB data types.