Purpose
CONCAT() concatenates two strings.
Syntax
CONCAT(char1,char2)
Parameters
| Parameter | Description |
|---|---|
| char1 | A string that can be of the CHAR, VARCHAR2, NCHAR, NVARCHAR2, or CLOB data type. |
| char2 | A string that can be of the CHAR, VARCHAR2, NCHAR, NVARCHAR2, or CLOB data type. |
Return type
The return type is the same as the data type of char1.
Examples
The following example concatenates the string Hello and the string , world!.
obclient> SELECT CONCAT('Hello',', world!') FROM DUAL;
+---------------------------+
| CONCAT('HELLO',',WORLD!') |
+---------------------------+
| Hello, world! |
+---------------------------+
1 row in set