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;
No comments:
Post a Comment