SQL Language Guide : 4. Elements of SQL Statements : SQL Operations : String Concatenation Operations
 
Share this page                  
String Concatenation Operations
To concatenate strings, use either the operator + or ||.
For example:
'This ' + 'is ' + 'a ' + 'test.'
gives the value:
'This is a test.'
Likewise:
'Hello ' || 'World'
gives the value:
'Hello World'
Also, the concat function can be used to concatenate strings. For details, see String Functions.