Oracle PL/SQL/Char Functions/String Concatenate

String||String: concatenates two strings

SQL> -- String||String
SQL>
SQL> -- This function concatenates two strings.
SQL>
SQL> -- String||String
SQL> SELECT "This" || " is "|| "a" || " concatenation" FROM dual;
"THIS"||"IS"||"A"||"CON
-----------------------
This is a concatenation
SQL>