How To Concatenate Two Character Strings?

Answer

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('wb','center','.com') FROM DUAL;
WithoutBook.com