Oracle SQL - String||String

Introduction

This function concatenates two strings.

The general format for this function is:

String||String 

Demo

SQL>
SQL>--   w  ww .ja  va2s  . c  o  m
SQL> SELECT 'This' || ' is '|| 'a' || ' concatenation' FROM dual ;

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

SQL>

Quiz