Purpose
You can call this function to concatenate 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