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>
Home »
Oracle »
String Functions » 

Related: