Oracle SQL - String||String

Introduction

This function concatenates two strings.

The general format for this function is:

String||String 

Demo

SQL>
SQL>-- w w  w .  j ava2s  .co  m
SQL> SELECT 'This' || ' is '|| 'a' || ' concatenation' FROM dual ;

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

SQL>

Quiz