Oracle PL/SQL - Concatenation Operator with NULL Operands

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

Introduction

The concatenation operator ignores null operands.

Demo

SQL>
SQL> BEGIN-- from   w w w . j a v a 2s  .  c o  m
  2    DBMS_OUTPUT.PUT_LINE ('>' || NULL || NULL || '<');
  3    DBMS_OUTPUT.PUT_LINE (NULL || NULL);
  4    --DBMS_OUTPUT.PUT_LINE (NULL || "Test");
  5  END;
  6  /


SQL>
SQL>

Related Topic