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