Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

Concat concatenates two strings

The general format for this function is:CONCAT(string1, string2) SQL> SQL> SELECT CONCAT('A ', 'concatenation') FROM dual; CONCAT('A','CON --------------- A concatenation SQL>