SQL Functions:CONCAT

CONCAT:This function is same as concatenation operator (||).Used to concantenate two characters, which can be any of CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB.

Select CONCAT(char01,char02) from table Name;

Select CONCAT(First_name,Last_name) “Full Name” from EMP;