String||String : CONCAT « Character String Functions « Oracle PL/SQL Tutorial

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

This function concatenates two strings.

The general format for this function is:

String||String

SQL> SELECT 'This' || ' is '|| 'a' || ' concatenation' FROM dual;

'THIS'||'IS'||'A'||'CON
-----------------------
This is a concatenation

SQL>