Simple demo for CONCAT function: concatenate two strings together
SQL> SELECT CONCAT('Oracle','Server') AS Concat FROM Dual; CONCAT ------------ OracleServer SQL>