Changes between Version 2 and Version 5 of Ticket #29222


Ignore:
Timestamp:
12/31/21 06:47:27 (9 months ago)
Author:
Mariusz Felisiak
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #29222

    • Property Owner nobody deleted
    • Property Triage Stage changed from Unreviewed to Accepted
  • Ticket #29222 – Description

    v2 v5  
    77which is unexpected.
    88
    9 ''"Although Oracle treats zero-length character strings as nulls, concatenating a zero-length character string with another operand always results in the other operand, so null can result only from the concatenation of two null strings. However, this may not continue to be true in future versions of Oracle Database. To concatenate an expression that might be null, use the NVL function to explicitly convert the expression to a zero-length string."'' (see [https://docs.oracle.com/database/121/SQLRF/operators003.htm#SQLRF51158 documentation]).
     9''"Although Oracle treats zero-length character strings as nulls, concatenating a zero-length character string with another operand always results in the other operand, so null can result only from the concatenation of two null strings. However, this may not continue to be true in future versions of Oracle Database. To concatenate an expression that might be null, use the NVL function to explicitly convert the expression to a zero-length string."'' (see [https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Concatenation-Operator.html#GUID-08C10738-706B-4290-B7CD-C279EBC90F7E]).
Back to Top