Oracle PL/SQL - PL SQL Operator Concatenation Operator

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Operator
  4. Concatenation Operator

Introduction

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

Demo

SQL>
SQL> DECLARE-- from www. j  a v  a 2 s. c  om
  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