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>