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.ja  v  a 2 s.co  m
SQL> SELECT CONCAT('A ', 'test') FROM dual
  2