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 

 

Increment Dates by 1 in Oracle

Use NULL as Conditions in Oracle

Understanding SQL Language Basics for Oracle

⇑⇑ Oracle Database Tutorials

2019-12-02, 2100🔥, 0💬