Oracle SQL - Function CONCAT function

  1. HOME
  2. Oracle SQL
  3. Function
  4. 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 .java  2 s  . c o m
SQL> SELECT CONCAT('A ', 'test') FROM dual
  2