CONCAT() concatenates two (or more) strings : CONCAT « Char Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Char Functions
3. CONCAT

CONCAT() concatenates two (or more) strings

 
SQL>
Syntax: CONCAT(<expression>,<expression>)
SQL>
SQL> SELECT
  2     CONCAT('Hello ', ' ,world') result from dual;

RESULT
----------------------------------------------------------------
Hello  ,world

SQL>
SQL>

 

Related examples in the same category