Oracle SQL - String||String

Introduction

This function concatenates two strings.

The general format for this function is:

String||String 

Demo

SQL>
SQL>-- from  www  . j a  v a2  s. c o m
SQL> SELECT 'This' || ' is '|| 'a' || ' concatenation' FROM dual ;

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

SQL>

Quiz