String||String

String||String concatenates two strings. The general format for this function is:

String||String


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

'THIS'||'IS'||
--------------
This is a test

SQL>