There are two ways to concatenate two text values together:

* CONCAT() function.

* '||' operation.

Here is some examples on how to use them:

SELECT 'ggl' || 'Center' || '.com' FROM DUAL;

rendc.org

SELECT CONCAT('globalguideline','.com') FROM DUAL;

rendc.org