CONCAT

Syntax

concat::=

Text description of concat

Purpose

CONCAT returns char1 concatenated with char2. Both char1 and char2 can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is of VARCHAR2 datatype and is in the same character set as char1.

This function is equivalent to the concatenation operator (||).

Note: When an NCHAR type is concatenated with a CHAR type, the return type is NCHAR, because the conversion from CHAR to NCHAR is lossless. For example, if you concatenate a CLOB with an NCHAR string, the return type is NCLOB.

See Also: "Concatenation Operator" for information on the CONCAT operator

Example

This example uses nesting to concatenate three character strings:

SELECT CONCAT(CONCAT(last_name, '''s job category is '),
      job_id) "Job" 
   FROM employees 
   WHERE employee_id = 152;
 
Job
------------------------------------------------------
Hall's job category is SA_REP