CONCAT

Oracle string functions

The CONCAT function returns the concatenation of 2 strings. You can also use the || command for this.

Example: CONCAT('abc','def') = 'abcdef'