Oracle SQL - Function CONCAT function

Introduction

CONCAT function concatenates two strings.

The general format for this function is:

CONCAT(string1, string2) 

Demo

SQL>
SQL>-- w  w  w. j a v  a2  s .c  om
SQL> SELECT CONCAT('A ', 'test') FROM dual
  2