How To Concatenate Two Text Values

Q

How To Concatenate Two Text Values? - Oracle DBA FAQ - Understanding SQL Basics

✍: 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 

2007-04-23, 4636👍, 0💬