Oracle SQL - Function CONCAT function

Introduction

CONCAT function concatenates two strings.

The general format for this function is:

CONCAT(string1, string2) 

Demo

SQL>
SQL>-- from   w w w  .j ava 2s  . com
SQL> SELECT CONCAT('A ', 'test') FROM dual
  2