SELECT CONCAT('Hello', CONCAT(' _ ','bye')), CONCAT('good', 'bad') FROM dual;
SELECT LAST_NAME , FIRST_NAME , CONCAT(LAST_NAME, FIRST_NAME) FROM EMPLOYEES e ;
SELECT FIRST_NAME , LAST_NAME , FIRST_NAME || ' ' || LAST_NAME FROM EMPLOYEES e ;