Character String Functions Oracle PLSQL Tutorial

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>