Concatenate Two Text Values in Oracle

Q

How To Concatenate Two Text Values in Oracle?

✍: FYIcenter.com

A

There are two ways to concatenate two text values together:

  • CONCAT() function.
  • '||' operation.

Here is some examples on how to use them:

SELECT 'FYI' || 'Center' || '.com' FROM DUAL;
FYICenter.com 

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

 

Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 133👍, 0💬