Oracle PL/SQL - Concatenation Operator with NULL Operands

Introduction

The concatenation operator ignores null operands.

Demo

SQL>
SQL> BEGIN-- from   www  .  j  a v a 2 s .  co  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