If you want concatenate multiple character strings into one, you need to use the CONCAT() function. Here are some good examples:

SELECT CONCAT('Welcome',' to') FROM DUAL;

Welcome to

SELECT CONCAT('ggl','center','.com') FROM DUAL;

GlobalGuideLine.com