Oracle Database Interview Question:

How To Concatenate Two Text Values in Oracle?

Submitted by: Administrator

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;
globalguideline.com

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

Submitted by: Administrator