Oracle PL/SQL/Char Functions/CONCAT

Материал из SQL эксперт
Перейти к: навигация, поиск

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>