Oracle PL/SQL - PL SQL Operator Concatenation Operator

Introduction

The concatenation operator || appends one string operand to another.

Demo

SQL>
SQL> DECLARE-- w ww  .j  a  v a2s.co m
  2    x VARCHAR2(4) := '1234';
  3    y VARCHAR2(4) := '5678';
  4  BEGIN
  5    DBMS_OUTPUT.PUT_LINE (x || y);
  6  END;
  7  /
12345678

PL/SQL procedure successfully completed.

SQL>

Related Topics