Oracle PL/SQL/Char Functions/CONCAT

CONCAT() concatenates two (or more) strings

   <source lang="sql">

SQL> Syntax: CONCAT(<expression>,<expression>) SQL> SQL> SELECT

 2     CONCAT("Hello ", " ,world") result from dual;

RESULT

---

Hello ,world SQL> SQL>

</source>
   
  

Simple demo for CONCAT function: concatenate two strings together

   <source lang="sql">

SQL> SELECT CONCAT("Oracle","Server") AS Concat FROM Dual; CONCAT

---

OracleServer SQL>

      </source>