Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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>