Oracle SQL - String||String

  1. HOME
  2. Oracle SQL
  3. Function
  4. String||String

Introduction

This function concatenates two strings.

The general format for this function is: 

String||String

Demo

SQL>
SQL>-- from w  ww.j a va2 s  .c o m
SQL> SELECT 'This' || ' is '|| 'a' || ' concatenation' FROM dual ;

'THIS'||'IS'||'A'||'CON
-----------------------
This is a concatenation

SQL>

Quiz