The Oracle and PL/SQL || operator allows you to join (concatenate) two or more strings together.
The general format is:
char1||char2||char3...
Example 1:
SELECT 'JOHN '||'WILLIAMS' FROM DUAL;
returns:
JOHN WILLIAMS
Example 2:
SELECT 'a'||'b'||'c' FROM DUAL;
returns:
abc