Concat concatenates two strings : CONCAT « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. CONCAT

The general format for this function is:CONCAT(string1, string2)

SQL>
SQL> SELECT CONCAT('A ', 'concatenation') FROM dual;

CONCAT('A','CON
---------------
A concatenation

SQL>








11.4.CONCAT
11.4.1.CONCAT(x, y) appends y to x
11.4.2.Concat concatenates two strings
11.4.3.String||String