Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. 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>